Connect to Aliased Cluster Named Instance
-
I wonder if anyone has seen this problem and know of a SERVER side fix:
The app uses the DNSAlias\NamedInstance to point to the IP
address of a clustered SQL virtual server that has the instance we need to use. If we specify DNSAlias\Instancename as the connect string it
fails with the error 'specified sql server not found'. If we use the
virtualsqlservername\instancename it works fine.
Your help is greatly appreciated.
-
having the same issue
It will work for the default instance, but not for the others.
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
-
I'm not sure if it's a bug, or has been designed that way, but it does not work.
We spent a good 3 weeks attempting to get it to work at my previous company with no joy. We were attempting to introduce a 3dns solution and found that it would not work as we could not get it to connect to a named instance of sql using an alias.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply