August 6, 2008 at 10:37 am
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) ( Micorsoft SQL Server, Error: 53)
My sql server version : 9.00.1399.06
I tried to resolve by following this article but still same error.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
August 6, 2008 at 11:05 am
can some one help me in this.. its really urgent.
August 6, 2008 at 11:14 am
What kind of connection are you trying to establish? What application? Are you on the other side of a firewall from the server?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 6, 2008 at 11:33 am
do you have named pipes enabled on both the server and remote side? are you able to connect from another machine? have you typed in the server name correctly? are you able to ping the server?
August 6, 2008 at 11:34 am
I am trying to connect to my database instance through windows authentication. also I configured windows firewall to allow sql server
August 7, 2008 at 11:14 am
Is the database server set up for Windows/Mixed authentication?
What application are you trying to connect from?
Are both machines (client and server) on the same domain?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply