July 11, 2025 at 12:01 pm
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....
July 11, 2025 at 12:17 pm
In case this helps someone else someday:
this works
ABC.mydomainfullyqualified.com\ABC
July 11, 2025 at 7:53 pm
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.
July 13, 2025 at 1:00 pm
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