Server remembers old name?

#1

I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From BASH.MainDB.dbo.Accounts".

Is there anything still lingering on this server that might make it still
think it is named BASH?

--
--Zorpie

#2

Check out the local option of sp_addserver
http://msdn.microsoft.com/en-us/library/ms174411.aspx

--
Rick Byham, MSFT
(Implies no warranty or rights)

"Zorpiedoman" <nowheremane (AT) beatles (DOT) com> wrote

Quote:

I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I
set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From
BASH.MainDB.dbo.Accounts".

Is there anything still lingering on this server that might make it still
think it is named BASH?

--
--Zorpie

#3

No luck. Still the same behavior. It is still looking at itself..

--
--Zorpie

"Rick Byham, MSFT" wrote:

Quote:

Check out the local option of sp_addserver
http://msdn.microsoft.com/en-us/library/ms174411.aspx

--
Rick Byham, MSFT
(Implies no warranty or rights)

"Zorpiedoman" <nowheremane (AT) beatles (DOT) com> wrote in message
news:2B626097-F858-4D0F-B38A-477C7010FF96 (AT) microsoft (DOT) com...
I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I
set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From
BASH.MainDB.dbo.Accounts".

Is there anything still lingering on this server that might make it still
think it is named BASH?

--
--Zorpie

#4

Further evidence of self-referencing behavior - I can run:

Select count(*) From BASH.MainDB.dbo.OldUsers

and get results. The production database on BASH does not have a table
'OldUsers'

--
--Zorpie

"Rick Byham, MSFT" wrote:

Quote:

Check out the local option of sp_addserver
http://msdn.microsoft.com/en-us/library/ms174411.aspx

--
Rick Byham, MSFT
(Implies no warranty or rights)

"Zorpiedoman" <nowheremane (AT) beatles (DOT) com> wrote in message
news:2B626097-F858-4D0F-B38A-477C7010FF96 (AT) microsoft (DOT) com...
I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I
set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From
BASH.MainDB.dbo.Accounts".

Is there anything still lingering on this server that might make it still
think it is named BASH?

--
--Zorpie

#5

Quote:

I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From BASH.MainDB.dbo.Accounts".

What does this yield:

SELECT * FROM sys.servers;

Also do you have any aliases set up in the client network utility?

#6

What is this? [client network utility]

Is that something in SQL server or something I need to ask the IT team about
our network?

The sys.servers show just the one BASH server, as expected.

--
--Zorpie

"Aaron Bertrand [SQL Server MVP]" wrote:

Quote:

I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From BASH.MainDB.dbo.Accounts".

What does this yield:

SELECT * FROM sys.servers;

Also do you have any aliases set up in the client network utility?

#7

"Native Client Configuration" tool for SQL server shows no aliases if that is
what you are talking about.
--
--Zorpie

"Aaron Bertrand [SQL Server MVP]" wrote:

Quote:

I have a SQL Server 2005 box that got demoted from a production server to a
test server. The original name of the box was 'BASH' and has been renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I set
it up and do a query on a table, I am seeing data from the BASHDEV server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems to
return data from itself when I say "Select * From BASH.MainDB.dbo.Accounts".

What does this yield:

SELECT * FROM sys.servers;

Also do you have any aliases set up in the client network utility?

#8

sys.servers should show BASHDEV. You need to rename the local server using
the stored procedures 'sp_dropserver' and 'sp_addserver' as in:

Execute sp_dropserver 'BASH';
Go

Execute sp_addserver 'BASHDEV', 'local';

Also, check the hosts file and see if you have any entries in there for
BASH.

Jeff

"Zorpiedoman" <nowheremane (AT) beatles (DOT) com> wrote

Quote:

What is this? [client network utility]

Is that something in SQL server or something I need to ask the IT team
about
our network?

The sys.servers show just the one BASH server, as expected.

--
--Zorpie

"Aaron Bertrand [SQL Server MVP]" wrote:

I have a SQL Server 2005 box that got demoted from a production server
to a
test server. The original name of the box was 'BASH' and has been
renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I
set
it up and do a query on a table, I am seeing data from the BASHDEV
server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems
to
return data from itself when I say "Select * From
BASH.MainDB.dbo.Accounts".

What does this yield:

SELECT * FROM sys.servers;

Also do you have any aliases set up in the client network utility?

#9

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.

What is the 'hosts file'?
--
--Zorpie

"Jeffrey Williams" wrote:

Quote:

sys.servers should show BASHDEV. You need to rename the local server using
the stored procedures 'sp_dropserver' and 'sp_addserver' as in:

Execute sp_dropserver 'BASH';
Go

Execute sp_addserver 'BASHDEV', 'local';

Also, check the hosts file and see if you have any entries in there for
BASH.

Jeff

"Zorpiedoman" <nowheremane (AT) beatles (DOT) com> wrote in message
news:8F803025-6411-4F24-A2F0-998A3AA10D79 (AT) microsoft (DOT) com...
What is this? [client network utility]

Is that something in SQL server or something I need to ask the IT team
about
our network?

The sys.servers show just the one BASH server, as expected.

--
--Zorpie

"Aaron Bertrand [SQL Server MVP]" wrote:

I have a SQL Server 2005 box that got demoted from a production server
to a
test server. The original name of the box was 'BASH' and has been
renamed
'BASHDEV'. The new production server is now named 'BASH'

I created a Linked Server on BASHDEV server to the BASH server. When I
set
it up and do a query on a table, I am seeing data from the BASHDEV
server.
No matter if I use a SQL Server link, or an OLEDB link, it still seems
to
return data from itself when I say "Select * From
BASH.MainDB.dbo.Accounts".

What does this yield:

SELECT * FROM sys.servers;

Also do you have any aliases set up in the client network utility?

#10

Quote:

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

So you dropped server BASH, added server BASHDEV, and still BASH is the only
server listed in sys.servers? If so, either you didn't hit EXECUTE, or you
are on the wrong server when you are checking. At this point I would
suggest you hire some help, as I don't think you are able to really describe
your environment, what you've done, and what is currently happening.

Quote:

What is the 'hosts file'?

Google is your friend.

http://en.wikipedia.org/wiki/Hosts_file