w2k image w/ sql

[Rasslor]

I am trying to create an image for some Windows 2000 client machines at work, but each machine has SQL on it. The problem is after I create the original image (that works fine) when I change the machine names after using the image SQL no longer works and gives me an error that my SQL server installation is either corrupt or has been tampered with. Is this a registry problem after changing the machine name that can be fixed, or will I have to install SQL on each machine? Any help with this is GREATLY appreciated.

Thanks
Brendan

 

[fluteplr]

You can run the sql install after you change the machine name, which will not actually reinstall SQL but will recognise the name problem and fix it. You did not mention what version of SQL. I know this works for 2000 I am not sure about 7.

 

[chrislarkin]

Run the setup program and confirm when it tells you that it found a
corruption in the registry. This procedure will run for a very short time,
and then you'll be able to start SQL Server. Once SQL Server is up, issue:

EXEC sp_dropserver <old_server_name>
EXEC sp_addserver <new_server_name>, local

Stop and restart your server.