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 |
|
MediaPirate
Yak Posting Veteran
52 Posts |
 Posted - 2006-02-10 : 19:47:25
|
| I can't seem to find a good answer to this question, which is prob has a simple answer. I had an old SQL 2000 server Machinename "TESTING" with a SQL instance "TESTING" so it was TESTING\TESTING. I have replaced the new server with with a machine called "TESTING2" but there's no extra instance name it's default. The DNS has been updated so TESTING now points to TESTING2 but how to I alias the SQL instance name? So all my old URLS using SERVERNAME\INSTANCE still work? BTW: Both 2003 SERVERs, Both SQL2K SP4 .. Thanks a Million, Jim |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-10 : 19:58:56
|
| no simple way to do this via DNS.You could add an alias to every machine that connects to your database using that SQL Client configuration tool. But if you are going to visit every box, you might as well point them to the real name instead.-ec |
 |
|
|
|
|
|
ALIASing a SQL Instance