Renamed Machine--Sysservers kept old name?? 2

[jsteph]

Hi all,
I have ver 2005 64-bit, and we renamed the machine. One of our vendors was installing a product and is having a problem apparently becauase our sysservers table lists the oldname, and nowhere in the sysservers table is the new machine's name. Further, the oldname has the IsRemote flag set to 1.

Can I use some system sp to change the servers table? The vendor said I might have to uninstall-reinstall sql server, but I'd very much like to avoid that.

Thanks,
--Jim

 

[ptheriault]

look up sp_dropserver\sp_addserver in BOL

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

After renameing SQL Server you have to tell the SQL Server what it's new name is.

exec sp_dropserver '[i]OldServerName[/i]'
go
exec sp_addserver '[i]NewServerName[/i]', 'local'
go

Then restart the SQL Services.

You should probably tell your vendor that if they are going to support SQL Server they should probably learn how to do little stuff like this without telling you to reinstall SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jsteph]

Thank you both!

I ran that and it worked fine. I emailed an .sql file to the vendor's installer and suggested they update their global support site, which was the site this installer used to come up with the 'uninstall/reinstall' suggestion.
--Jim