SQL Server does not allow remote connections.

Hi.

I've got the some problem when the connecting to SQL Server from Local Computer to the my own SQL Server.

And, Massage is a " 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 dose not allow remote connection. (provider:Named Pipes Provider, error:40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error:1326)"

I wish, someone explan it about this problam.

re: SQL Server does not allow remote connections.

See http://support.microsoft.com/default...EN-US%3b914277.

Check also to see what the name of your SQL Server 2005 instance is (the name you see when you log into SQL Server itself). If SQL Server was installed with a Named Instance, instead of the Default Instance, it will be THAT name, instead of just the FQDN of the server. I had that issue and these two tidbits fixed me right up.

-Tom

re: SQL Server does not allow remote connections.

You will also set Mixed Authentication mode.
and restart sql services