"Gabe" wrote:

> Please, help me!!
>
> I have Win XP SP 2 and SQL Server 2005 including Reporting Services.
> Under the default settings it works properly. I need to implement
> Forms Authentication. I followed the step from
> http://msdn2.microsoft.com/en-us/library/ms160724.aspx. The UILogon
> page appears but when I tried to connect through Logon button I got
> the following error:
>
> An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> Note: The user was registered on the database.
>
> The Sql Server Surface Area Configuration has Local and remote
> connections enabled.
>
> Will I apply any services pack?. I do not understand why Windows
> authentication mode works properly.
>
> Any suggestion??
>
> Thank you!!
>