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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-08 : 09:07:03
|
| Kavita writes "Hello,I am having Windows 2000 server Operating Server and Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I Changed my machines name from 'Chakravarthy' To 'Kavita'.Then I registerd 'Kavita' in SQL Server Group. But I was not getting in Sysservers Table, So I deleted 'Chakravarthy' using SP_DropServer and Added 'kavita' thru sp_AddServerName 'Kavita','Local'. I stoped SQl Server and then again restarted it. Again 'Kavita' in SQL Server Group. Now if I am firing sql statment in Query analyser 'select * from Sysservers', still I am not getting the name 'Kavita' and 'Chakravarthy' is still there. I am not getting what is going on and How to handle this problem ?My Top level group is still 'Chakravarthy' But it doesn't work and shows connection failed.Thanks and regardsKavita" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 11:49:28
|
| When you say top level group, do you mean inside Enterprise Manager? The registered groups and servers? If so, that doesn't have anything to do with the internals of SQL Server. You have to manually unregister that server, then register your new server.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-08 : 12:49:32
|
| If Tara didn't solve your problem which it sounds like she did, run SELECT @@SERVERNAME and tell us what it say.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Problem in adding Server name