- Mar 1, 2000
- 30,859
- 4,976
- 126
Not really sure this is "programming" per se, but there seems to be a lot of knowledge in this subforum about SQL, so figured I'd give it a shot.
I have an old server named: SQL
I have a new server named : SQL2
I have mountains of reports that query SQL.
I need to migrate the data from SQL to SQL2 (not a problem),
Once migration is done, I need to "rename" SQL2 to SQL rather than update the mountains of reports themselves.
Upon reading through some google links, it seems you can't do a rename, short of re-installing.
However, it seems that aliases may allow me to reroute the traffic properly.
from what I can tell, I've pretty much followed the directions here:
http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
to the letter, but can not connect the new alias "SQLTEST" (the alias I was attempting to use)
Any help?
I've tried the IP address (192.168.1.7), I've tried localhost in the alias.... nothing works.
Thanks in advance.
I have an old server named: SQL
I have a new server named : SQL2
I have mountains of reports that query SQL.
I need to migrate the data from SQL to SQL2 (not a problem),
Once migration is done, I need to "rename" SQL2 to SQL rather than update the mountains of reports themselves.
Upon reading through some google links, it seems you can't do a rename, short of re-installing.
However, it seems that aliases may allow me to reroute the traffic properly.
from what I can tell, I've pretty much followed the directions here:
http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
to the letter, but can not connect the new alias "SQLTEST" (the alias I was attempting to use)
Any help?
I've tried the IP address (192.168.1.7), I've tried localhost in the alias.... nothing works.
Thanks in advance.