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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error when renaming computer SQL 7.0 will not start

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-31 : 08:41:57
John writes "I know that renaming the computer requires you to "reinstall" sql 7.0 in order to re-authenticate the installation. Is there ANY other way around this? ( registry edit / smaller amount of files to send / etc... ) I have many computers in the field that will be hard to get a CD too, some dont even have cdroms..
and I need to rename them all !
thanks,
John

Any help is greatly appreciated..."

CanadaDBA

583 Posts

Posted - 2005-03-31 : 09:24:57
I had to change my SQL box machine name and I used the following script. Note that I have SQL 2000.

USE MASTER
GO

sp_dropserver OldMachineName -- Old Machine Name
GO

sp_addserver NewMachineName, LOCAL -- New Machine Name
GO
--allow updates to system catalogs
exec sp_configure 'allow updates', 1
reconfigure with override

--update sysjobs
USE msdb
GO

update sysjobs set originating_server = 'OldMachineName' -- Old Machine Name
where originating_server = 'NewMachineName' -- New Machine Name

--disallow updates to system catalogs
exec sp_configure 'allow updates', 0
reconfigure with override
GO



Canada DBA
Go to Top of Page
   

- Advertisement -