By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

SQL server name mismatch

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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