Connecting Tech Pros Worldwide Forums | Help | Site Map

SQL server name mismatch

Newbie
 
Join Date: Nov 2008
Posts: 1
#1: Nov 20 '08
Our prod SQL server name from Query Analyzer shows as "prodsql6" by command "select @@servername, @@servicename" where as on enterprise manager it shows as "prodsql1". The host name is prodsql1. The registry entry (regedit) key of HKEY_LOCAL_MACHINE....MSSQLSERVER\DefaultDomain is "prodsql6".

Also query from WMI (Windows Management Instrumentation" Tester as "select name, clustered, package, versionstring from mssql_sqlserver" shows sqlserver name "prodsql1".

The SQL server is running fine on host prodsql1. How can I change the servername in the SQLSERVER so that query analyzer show the correct name.
Reply