February 21, 2012 at 8:30 am
A network-related or instance-specific error ocured while establishing a connection to sql server. the server was not found or was inaccesible. varify that the instance name is correct and that sql server is configured to allow remote connections. (Provider Named pipes provider , error 40 - could not open a connection to sql server) (micriosoft sql server , error:35)
My instance name is correct, allow remote connection is checked , the listening port is open.
TCP/IP and named pipes and shared memory are enabled
What else I am missing,
Your help is appreciated.
Thanks
February 21, 2012 at 8:35 am
is it a named instance? is the sql browser service started? can you connect by specifing the port on ssms
eg server\instance,1433
February 21, 2012 at 8:50 am
Thanks
somehow the port is not 1433 that it is listening to
Got the probelm solved i needed to openup the sql browser port
February 21, 2012 at 8:55 am
if its not 1433 then it must be a named instance, so you will need to enable browser or use the named instance port number to connect
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply