Server remembers old name?

#11

Zorpiedoman (nowheremane (AT) beatles (DOT) com) writes:

Quote:

First of all, thank you for your help.

However, I have done #1 and #2 already in every possible configuration
there is and still get the same results.

Did you restart SQL Server after sp_addserver, sp_dropserver?

What does SELECT @@hostname report?

Quote:

What is the 'hosts file'?

c:\Windows\System32\drivers\etc\hosts

gives local mappings between name and IP-address.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Server remembers old name?

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: Server remembers old name? - 07-25-2009 , 04:04 PM