Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenchee
Starting Member
49 Posts |
 Posted - 2008-06-02 : 02:41:51
|
| Hi All, I've just installed an active/active sql cluster. Both are named instance hence if i need to connect to it, I need to use NODE1\SQLINST1 and NODE2\SQLINST2. Is there a way to just use NODE1 or any other single name to connect to the sql instance? I was looking at Alias but I can't get it working. Anyone has any ideas or suggestion for me? Reason why i want to do this is in an odbc connection, instead of using NODE1\SQLINST1, I can use NODE1.ThanksRegardsKen |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 21:50:45
|
| You have to create alias on every client machines. |
 |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2008-06-03 : 21:25:02
|
| yeah... i thought so as well. is there any other way? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 21:31:09
|
| May try add alais in dns with same ip address of sql instance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-04 : 13:30:21
|
| Well you shouldn't be using NODE1 or NODE2, but instead use the virtual name. You do not need to reference an instance name though, you could simply use VirtualName,PortNumberOfInstance.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
kenchee
Starting Member
49 Posts |
Posted - 2008-06-04 : 22:17:36
|
| Reason why I was asking this is becuase most of our db are connected through ODBC connections using CNAMES. I was hoping of just going into the DNS and change the mapping of the CNAME from the old sql instance (default named instance hence, able to use the host name) to the new sql cluster instance (a named instance). I was hoping not to have to change every odbc connection to add the instance name but it seems like I have to. :( Tara, yes, i'm using the virtual name. sorry for the misleading names. With portnumbers of the instance, I will still have to add that in to every odbc connection. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-04 : 23:09:05
|
| Don't have to specify instance name if you map cname to virtual name's ip address. |
|
|
|
|
|
|
Alias