FQDN - SQL cannot connect when the server name has backslash

  • Hi

    I need to connect to a SQL server via FQDN -  that is named 'ABC\ABC'

    If I try to connect to [ABC\ABC].mydomainfullyqualified.com it does not work. Tried many other combinations also. ABC.mydomainfullyqualified.com, all sorts of combinations. Nothing works..

    If I change to a different server that does not have the back slash in the name server 'EDF.mydomainfullyqualified.com' it works just fine.

    It seems that I am not referencing the SQL servers that are named with ABC\ABC a backsplash correctly.

    What am I missing? Been trying everything....

    • This topic was modified 1 month, 3 weeks ago by krypto69.
  • In case this helps someone else someday:

     

    this works

    ABC.mydomainfullyqualified.com\ABC

     

  • I think that is expected behavior. Naming a computer with a \ is not a supported configuration in Windows (server or desktop). BUT I think that isn't quite what is going on. I think your SQL Instance is named ABC and your  Server is named ABC in your above example. The FQDN applies to the server name, not the instance name. so you get FQDN\INSTANCE.

    With the example of EDF, you likely only have 1 SQL instance on there that is the default instance instead of a named instance, which is why that one works for you.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • should be yourserver.yourdomain\yourinstance or yourserver.yourdomain,portnumber

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply