Rename a SQL server 2000 box
-
Hi,
I have been asked to find out if it is possible to rename an SQL server 2000.
Not just a database, the box needs to be renamed to comform with the company new naming convention.
Bare in mind, terminal servers (2), web servers (2) for accounting & timesheet applications are linked to the main SQL server. Also, ODBC drivers are configured to the SQL server box too. Is there a scientific process to rename the server without having to reconfigure each application/server manually? Can I rename the SQL server using a stored procedure & which one so that all linked servers update on a restart?
The server runs on Wnidows NT 4 and are the other server boxes.
There was an article a few weeks ago, on the SQL Central website but I can not find it.
Please advise as I am fairly new to SQL.
many thanks
Vas
-
http://www.databasejournal.com/scripts/article.php/1496451
-- Update Originating_Server sysjobs !! for SQLAgent
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
SQL7.0 http://ambrosoli.com/ambrosoli/how_to_rename_a_sql_server_7_0.htm
If you connect using ip there is no problem, if you connect using sqlservername, you'll have to modify the odbc-dsn or the connection-strings.
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
-
Can't you just setup a DNS alias for the new server name?
Joe Johnson
NETDIO,LLC.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply