0

I have a server with 2 SQL Server instances, I can connect to the default instance remotely, however I am not able to connect to the named instance.

enter image description here

enter image description here

enter image description here

When I try to connect remotely, I get this error, SQL Server is configured to allow remote connection and the name is correct

enter image description here

  • Does DNS for 311SQLI01 resolve correctly on your client? – Jim G. Nov 6 '15 at 17:43
  • 1
    I think that are like thousands of questions like this here. – Racer SQL Nov 6 '15 at 17:43
  • @JimG. yes it is resolved correctly – sebeid Nov 6 '15 at 17:45
  • @RafaelPiccinelli .. can you give me 5 links for these thousands of questions – sebeid Nov 6 '15 at 17:46
  • 2
    @sebeid - see the "related" links to the right of your question. – Max Vernon Nov 6 '15 at 18:27
4

Try connecting to 311SQLI01,1430. If that works, turn on the SQL Browser service.

SQL Browser needs to be turned on for port number translation ( it's off in your screenshot ) and you don't seem to be referencing the specific port in your connection attempts.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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