February 8, 2010 at 7:13 am
Are they created automatically for 2008 cluster?
May 12, 2010 at 9:20 am
I am having the same issue. I've tried/set all the options as oulined, but still am not able to connect to the server directly (eg:dbservername), only by using servername\dbserversname, or by setting up a local alias (dbservername=servername\dbservername), or a third way (using dbartisan for example, servername:port number).
Is there anything else that could be an issue?
July 9, 2013 at 2:33 pm
I know this is an old discussion, but it came up when I was googling the interwebs for info on this.
1. You need to understand DNS.
2. You need to configure your server's network config correctly; i.e. do not register automatically with DNS Server
3. Delete all A records from DNS and re-enter as static
4. Disable listen all in your nework protocols
5. Set ip's accordingly
6. Set dynamic ports to nothing; i.e. delete anything there. Otherwise it will use it. 0 is not blank, it is "find something"
Should all work.
Jared
CE - Microsoft
August 1, 2013 at 8:42 am
We have a server with 3 instances of SQL Server running, each running on it's own IP and port 1433.
I've created a blog post outlining how it was done.
http://kevine323.blogspot.com/2013/08/setting-up-aliases-on-sql-server-with.html
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply