MSSQL SERVER 7.0 - SQL Server Forums

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)

MSSQL SERVER 7.0

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-17 : 13:13:45

Narayanan writes "We Have SAP Installed on NT 4.0 svp 6 .- RDBMS - MSSQL 7.0 SP3- SAP 4.5b
Existing server name was PRODN with 20.1.1.10 ip address
We have got new server where we initially installed & used as a DISASTER SERVER - hostname = DRSPRODN with 20.1.1.11 ip address

since the DRSPRODN had more capacity ,we wanted to rename
DRSPRODN as PRODN & ipaddress was also changed to 20.1.1.10
so that the front users need not changed their hostname or ip address.
when we started the server again - NT 4.0 started but SQL Enterprise manager did not start ,saying SQL has been tampered & you have to run setup again.
checked regedit entries & changed occurences of DRSPRODN with PRODN & tried but with same result . i tried to re register but does not allow -saying cannot connect. WHAT CHANGES TO BE DONE TO MAKE IT EFFECTIVE.
so i have reverted back to original & back to square one.
CAN U PL HELP & mail me to narayananr@mclusa.com the solution as soon as possible.
thank you
Narayanan"

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-09-17 : 13:52:14

Well I hope you backed up the registry before hacking it !!
1) Restore the registry settins to their previous settings

2)Rerun setup - it does not actually run setup, it merely updates the requires system tables . Then in Query Analyzer run

use master
go

sp_dropserver 'PRODN'
go
sp_addserver 'DRSPRODN','local'
go

This is all documented in BOL. Look for renaming servers

Note If you change the computer name of the server, you cannot start Microsoft® SQL Server™ until you run SQL Server Setup. You will be prompted to upgrade, and the necessary SQL Server options will be reset with the new computer name. After you’ve upgraded, you can exit Setup. Your databases will not be affected by this procedure.

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources