March 4, 2002 at 11:43 am
We have SQL server 7 installed on a server. We rename the server. Do we have to re-register SQL server or does it automatically use the new name? Any help is appreciated.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 4, 2002 at 1:08 pm
You have to rename the sql server. use sp_dropserver, sp_addserver with the LOCAL option to do this.
Steve Jones
March 4, 2002 at 1:11 pm
Thanks Steve
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 5, 2002 at 10:15 am
This is a bit more complicated than drop server, add server. SQL 7 only supports 1 server. When I drop a server, I can't get to query analyzer to add the new server.
How is this accomplished?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 5, 2002 at 10:29 am
The following is from MS Knowledge Base article at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195759
Run SQL Server 7.0 Setup from the original product CD. Doing so will not reinstall SQL Server or any components; however, it will update SQL Server 7.0 internally to reflect the new Windows computer name. You also need to update SQL Server's internal servername by running the following two stored procedures:
sp_dropserver <old_name>
go
sp_addserver <newname>, local
go
If SQL Server is configured to listen on either the Multiprotocol or NWLink IPX/SPX network libraries, you'll need to remove them, and then add them back using the SQL Server Network Utility.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 5, 2002 at 1:59 pm
I installed the CD, rebooted the server and discovered the server names were case sensitive in the stored procedures. It worked perfectly! Thanks for all the help.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply