Not able to connect to sql server remotely from management studio

  • 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

  • is it a named instance? is the sql browser service started? can you connect by specifing the port on ssms

    eg server\instance,1433

  • Thanks

    somehow the port is not 1433 that it is listening to

    Got the probelm solved i needed to openup the sql browser port

  • 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