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)
 Renaming SQL 2005 Server

Author  Topic 

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2006-12-08 : 15:31:12
We had to rename a server "XYZ" to "ABC".
I followed the process of sp_dropserver and add server.
But the Reporting Service still sees xyz and not abc.
Has anybody come across a similar problem.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-12-08 : 16:03:13
http://msdn2.microsoft.com/en-us/library/ms345235.aspx
Go to Top of Page

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2006-12-08 : 16:16:54
Thank you, this was somehow not reachable through innumerable searches....this was a great help and it worked.
Go to Top of Page
   

- Advertisement -