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 |
|
rezrocket
Starting Member
4 Posts |
 Posted - 2010-01-22 : 13:16:29
|
| We recently upgraded our ERP software and migrated data in the process. To make the story short, the test system for the migration was successful.The SysAdmin renamed the test box and recommissioned for final upgrade and we imported data successfully, again.However, I am faced with following issue:My third party database monitoring software connects successfully to the server and is able to pull wmi data for the server, but it will not pull any database monitoring data and produces an error "Unknown server hostname". The database seems to be holding on to the old hostname.I have done the following:1. nslookup shows new server on domain with correct ip2. nslookup shows old server: "can't find old server: non-existent domain"3. Mgmt Studio: select @@SERVERNAME -> new server name4. Mgmt Studio: select HOST_NAME() -> new server name5. databse monitor continues to pull old server name when it tries to connect to database and fails.6. I have read on the following: sp_dropserver, sp_addserver, sp_renamedb but I do not see anything relevant to my situation.How do I change the hostname so I can pull monitoring data?Your help is greatly appreciated,rezrocket |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-22 : 14:12:21
|
| Are all other clients able to access data remotely?Off the top of my head, 3 things to check:- select * from sys.servers. is the new name there and is_remote_login_enabled?- Does it work if you change the connection to use the IP address? What about ServerName.Domain.com?If these last 2 work, have domain admin set SPN for the sqlserver service on newly named box |
 |
|
|
rezrocket
Starting Member
4 Posts |
Posted - 2010-01-25 : 10:50:27
|
| Thanks Russell,Yes to all of your questions, except that the server is in .local domain.I have forwarded the SPN information to the SysAdmin. and he is now working on it. Will let you know if that fixes it. |
|
|
|
|
|
|
incorrect hostname