Wednesday, March 21, 2012

Help with Remote Connection

I am attempting to connect to SQL 2005 server. The server and the VS 2005 are on the same computer. I have configured the db so it uses the security for asp. The log in section connects fine and checks for the user. I have combined the old db with the new ASP security. If the user is not found then I open a connection using the open command and check for the user in the old part of the db. The is where I have trouble. I get the message below that the server connect but then won't allow remote connections. I have check the setting and the allow remote connections is checked. Thank in advance if anyone can help.

Endeavor

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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: 0 - No process is on the other end of the pipe.)

The error came from Named Pipes Provider. Please check the server network protocols to maks sure Named Pipes is enabled. You can check this in 'Configuration Tools'->'SQL Server Configuration Manager'->'SQL Server 2005 Network Configuration'.

You'd better also configure remote connections to use both TCP/IP and Named pipes in 'SQL Server 2005 Surface Area Configuration'.

|||

thanks for your response, I went throught a configured like you said, the named pipes were disabled in the configuration manager but the other were correct in the surface area config. But I am still getting the same error message when it get to the trying to open a connection useing the open command. Have you got any other ideas I can try to get it to work.

Endeaveor

sql

No comments:

Post a Comment