I was wanting to use one of the samples called stock which is a notification sample and while i was reading the instrutions from the book, it did not match the managment studio for instance after i clicked on properties on a login there should have been a database access table on the right panel but it came up with user view, by then i thought i had an older version so i tried to update it to sp2 (x64 version the others came up with an hotfix error not being a win 32 app during extracting). after i installed it along with the new updates for documentation and samples it was no longer able to connect to my sql server instance that i had been using and this error comes up
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) (.Net SqlClient Data Provider)
i have gone to configuration manager and enabled named pipes as well as going to surface area config and enabled tcp/ip and named pipes but that has not resolve the area
Desperately need to get this problem resolve so if anyone can tell me how to fix i thank you in advance
Check the following link...
http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx
|||Hi Adam,
I updated my SQL Server 2005 with the SP2 and had no any problem.
I get this error message mostly when my SQL Service doesn't work. So i suggest you to check your SQL Services.
Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE
www.ekremonsoy.net
No comments:
Post a Comment