Server Driver Error

[kkiedrowski]

We have an application that connects to a Windows SQL server 2005 using SQL server accounts.
Certain parts of the application throw this error

"-2147467259 [Microsoft][ODBC SQL Server Driver][SQL Server] could not find server 'server name' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers."

Now our application works fine in other SQL server 2k5 installations so I am not sure what may be different with this one.
I have also tried running teh application connected at the SA account and I still receive this error.

Any possible insight would be appreciated.
Also if more info is needed please let me know.

 

[SQLDenis]

it looks like that one server does not have one of the linked servers setup

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[kkiedrowski]

The name that is referenced is the machine name of the SQL server. I cannot link the local server.

 

[SQLDenis]

run this

select * from sys.servers


is there a row for server_id 0?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[kkiedrowski]

yes that is the only entry however the server name in the error message is totally different than what that server_id 0 has in the name. I assume this is an issue?

 

[SQLDenis]

I would say, so, did the server get renamed?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[kkiedrowski]

As by chance it did. You are a life saver. We were able to get it resolved because of this. Never would have thought to do that simple step...UGH.. now i know.
Once again Many thanks