| Author |
Topic |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2004-10-02 : 14:36:11
|
| Hi,We renamed our NT4.0 (SP6a) server in which SQL Server 2000 is residing (sp3).The SQL Server recognized the new name immediately but it was recognizing the old name also.We ran the following command in the QA:sp_dropserver 'old server name'sp_addserver 'new server name', 'local'Still old and new registration to the server exists.We are having replication issues (transactional replication) where the record modifications are not synchronized from subscriber to the publisher (subscriber is the renamed server)Thanks in advance,Rushdi |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-03 : 23:21:37
|
| what does select @@servername show you? |
 |
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-10-04 : 08:38:00
|
| the old server name. I can sign on using both names. |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2004-10-04 : 08:44:56
|
| After you change the server name you need to reboot SQL Server.Then connect to the new server name in Query Analyzer and run the following command: sp_dropserver 'old server name' sp_addserver 'new server name', 'local'Delete the entry in Enterprise Manager for the old server name.You also need to stop and start the SQL Server service to complete the process.HTH.Franco |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-10-04 : 08:53:41
|
| we did all that. We just found out that we can ping the NT server and getting replies from both names. So it looks like a network issue. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-04 : 23:56:57
|
quote:
Originally posted by rushdib
we did all that. We just found out that we can ping the NT server and getting replies from both names. So it looks like a network issue.
if you're still seeing the old name then dropping the server name was not successful, you should see the new name on @@servername.repeat the process:1. change the machinename2. restart the machine3. issue the sp_dropserver and addserver4. restart the sql service5. check for @@servername |
|
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-10-05 : 02:00:03
|
quote:
Originally posted by rushdib
we did all that. We just found out that we can ping the NT server and getting replies from both names. So it looks like a network issue.
It is. NATing might have been done on the servers ip with the old server name. Contact your local network group and have it changed to the new server anme.Hemanth GorijalaBI Architect / DBA... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-05 : 02:04:19
|
quote:
Originally posted by hgorijal
quote:
Originally posted by rushdib
we did all that. We just found out that we can ping the NT server and getting replies from both names. So it looks like a network issue.
It is. NATing might have been done on the servers ip with the old server name. Contact your local network group and have it changed to the new server anme.Hemanth GorijalaBI Architect / DBA...
just couldn't resist... hey rushdib,by any chance, are you with the same company as elwoos?just asking... |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-10-05 : 08:50:00
|
| ok guys, the renamed machine is a primary domain controller. So the network admin is saying that the old name going to be in the DNS until October 26th 2004(expiry date). |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-05 : 23:07:06
|
| is it advisable to have your sql on a primary domain controller?just curious... |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-10-06 : 14:39:03
|
| jen, we didn't have any issues for the past four years. Rushdi |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-06 : 14:40:31
|
| You would see better performance if the server running SQL Server was just a member server of the domain. It is highly recommended that this server be dedicated to SQL Server. But I guess dedicating a server to SQL Server just depends on the size of your organization and your needs.Tara |
|
|
|
Pooja
Starting Member
2 Posts |
Posted - 2004-10-25 : 08:19:16
|
| Hi,I have a similar problem. But, select @@servername shows new servername. Still I am able to register using both old and new names.Any suggestions.Thanks in advance.Pooja |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-10-25 : 10:10:50
|
| We have discontinued use of that SQL Server and moved the data to a different server. It maybe the old server name still exisit in the DNS. |
|
|
|
Pooja
Starting Member
2 Posts |
Posted - 2004-10-26 : 01:25:35
|
| Thanks for the solution. As rightly said by you, the old server name still existed in the DNS. |
|
|
|
|
Renaming a server