I am working with one other person on a VS 2005 vb.net web project that accesses SQL Server 2005. Both the computers are connected and my partner can run the application on his computer from his VS 2005 but we are getting an error on our first databind to a gridview on the page we are trying to run the error is below
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.)
I check the properties of the SQL Server and the check box is checked that says allow remote access. I am not sure what to do.
Hi,
First, please try to allow remote connections for TCP/IP and Named Pipe according to the following KB article.
http://support.microsoft.com/kb/914277/en-us
If that still doesn't work, you can check the following link for troubleshooting.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=275050&SiteID=1
No comments:
Post a Comment