question

ramesh 1 avatar image
ramesh 1 asked

connection error 40 in sql server 2005 32 bit

hi team, i have installed sql server 2005 standard edition 32 bit on windows 2003 server, i am getting the error below 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 Serve . please help me
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
Ramesh, please check that you have the network protocols activated for this instance. You need to open SQL Server Configuration Manager and under SQL Server Network Configuration you can check that the correct protocols are active. I normally activate Shared Memory, Named Pipes and TCP/IP. As I understand it, Shared Memory is used for local connections on the server and the other two are for remote connections. Please check that Named Pipes and TCP/IP are activated (restart SQL Server is you change these settings), then try connecting again.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image ramesh 1 commented ·
hi William , i have verified it ,in the surface are configuration manager,remote connection, it is tcp/ip only.
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
You can also set an option for allowing remote connections in the surface area configuration manager, it this also set? Have you restarted SQL Server since making changes here?
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
Can you try the process explained here from the machine that you are getting the error message on? [ http://jonathanallen69.blogspot.com/2010/04/testing-database-connection-or-who-hell.html][1] Are you trying to connect from SSMS? Are you using SQL or Windows authentication? Do you get this issue from other computers? Can you connect from the local machine? [1]: http://jonathanallen69.blogspot.com/2010/04/testing-database-connection-or-who-hell.html
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
I like that approach to the problem (+1)
0 Likes 0 ·
Oleg avatar image Oleg commented ·
@Fatherjack This is a useful approach to troubleshoot the connection problems. I cannot help but notice though that the blogspot is a bit too invasive. Not that there is anything wrong with it, they all do it (context-sensitive ads) now. What I mean is this: - read the UDL article, get link to **database consultants** on the bottom of the page - click Home to go to the home page, get links to **Try Venus Bikini Kit** and **Premium Electric Razors** Pretty cool engine, seems to deduce information accurately.
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
@oleg - it used to be my only blog and I added the adverts as a trial on getting some income(!). I wrote that article for times like this, I can link to it and avoid typing it all out as an answer. I dont use the blog for SQL content very often now, as I blog at Simple-Talk, so its a little neglected.
0 Likes 0 ·
Oleg avatar image Oleg commented ·
@Fatherjack Maybe what I said did not come out right. I just wanted to point out that they have a pretty intelligent engine to read what people write and deduce the links correctly based on the context. This is by no means a trivial task to design such engine. By the way, I just noticed that you went over 9K. 9 down, just 1 to go to get to 5 digits figure. Congratulations!
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
@oleg - OK, I see. Yes, google are pretty cunning when it comes to marketing and advertising! I guess I am ultra cautious when I link to my blog as it could be seen as self promotion and frowned upon. Its just that this problem occurs so often that it seemed sensible to write the blog item. :-/ Yes, 10k is looming closer and closer. I started the year thinking I might get to 1k by Dec 2010, now I am wondering if it will be over 12k!! We shall see!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.