467,915 Members | 1,272 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

SQL server name mismatch

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.
Nov 20 '08 #1
  • viewed: 1126
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by LJgrnl | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.