5

I have a server called SQLDWDEV01, with 2 instances: default and UAT.

To the default instance that uses port 1433, everything works fine.

However, the UAT instace, which I configured according to the pictures below, I cannot connect from my local machine.

I have access, and remote connections are enabled.

What is it that I miss doing so that I could connect to this instance?

If this question is somehow not complete, please ask and I will reply.

there are no firewall(s).

enter image description here

enter image description here

enter image description here

The error message that I am currently having is:

Cannot connect to sqldwdev01\UAT.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

1
  • 3
    (1) Why is named pipes disabled? (2) Is the SQL Server Browser service enabled and running? Jul 22, 2015 at 13:26

1 Answer 1

9

have fixed sqldwdev01 the reason I couldn't connect to UAT instance is because of a couple of reasons

  1. there was a dynamic port specified for the instance under SSNetworkConfig\Protocols for UAT, so had to remove that and specify 1435 (as 1434 is in use) then restart the service
  2. still cant connect remotely to the instance name but can connect using the port name eg sqldwdev01,1435 so it needed sql browser service to be running to direct the port for connecting with instance name

i started sql browser and now can connect using sqldwdev01\uat

enter image description here

1
  • 2
    Thanks for taking the time to post your findings! It helped me to quickly solve a similar issue today! :)
    – Claes Park
    May 3, 2018 at 16:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.