August 29, 2007 at 8:12 am
Our IT Dept, want to change the hostname of our database server (they're moving it to a shared host box), so I could do with knowing what needs to be updated. I did it once ages ago and recall having to call some system procs to update the system databases or similar. However I can't for the devil of me remember now.
To make matter worse, this server is a published in a replicated setup and is also running SQL2005 for the reporting services. What over knock on effects will we get and what other setting need tweaking?
So to sum up, this box has:
SQL2K - main database.
SQL2005 + Reporting Services
Its a replication publisher for SQL2K (snapshot and merge) with a middle man distribution server in place.
Apache, PHP, MySQL (off topic, but you may have pointers for these too).
Its being cloned, given a new hostname and we can't really afford the downtime to hit each issue as we come to it. Any help would be greatly appreciated.
Arthur.
August 29, 2007 at 8:26 am
for the SQL Server you need:
sp_dropserver 'OldServerName'
GO
sp_addserver 'NewServerName','local'
GO
Andras
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply