October 31, 2011 at 11:26 am
Dear All,
One of Our server is SQL is express edition and I am able to connect that server but when application team try to connect remotely it throws the following error;.
An error has occured 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 connection to SQL Server))
Regards,
Satish kumar
October 31, 2011 at 11:27 am
In SQL Configuration Manager, what connection types have you allowed?
- 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
November 1, 2011 at 10:29 am
Verify that named pipes is enabled and that the firewall is either disabled or allowing port 1433
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply