Could not find server 'dbo' in sys.servers

Question

I have a lot of services which query the database. All of them work fine but one service calling a stored procedure gives me following error:

Could not find server 'dbo' 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.

I have not idea why all the other stored procedures work fine and this one not...

By the way, I use SubSonic as data access layer.

Answer 1

Please run select name from sys.servers from the server which you mentioned as default server in configuration file.

Here in name column values should match with your server names used in the report query.

e.g serverXXX.databasename.schema.tablename

serverXXX should be there in the result of select name from sys.servers otherwise it gives error as got.