KB IssueWhen connecting to a Linked Server within SQL Server 2005, you may experience the following error, if your SCHEME is not properly defined.

Issue DetailsWhen creating your SQL Script to connect to the Linked Server, you have to make sure that everything is not only spelled correctly, but that you also include the entire SCHEME name if you are using something other than, the dbo to connect with.

Recreate Issue

If you are using a different Scheme than the default [DBO].
select * from [Hosting].[MyLogin kb].[myscheme].[Users]

Copy

Search Site

Search Google

Resolve Issue

When you are connecting to an outside server, you have to add in your logon credentials to your SQL Code if you are using something other than the DBO.
For example:

If your login is: [MyLogin]
And your Scheme is: [MyScheme]
Then you would write it as: [MyLogin MyScheme]

select * from [Hosting].[MyLogin kb].[MyLogin myscheme].[Users]

Copy

Search Site

Search Google

Break it down:

[Hosting] = This is the Linked Server Name (Usually the name of the server you're connecting to)
[MyLogin.kb] = This is the Database.
[MyLogin MyScheme] This is the Scheme.
[Users] = This is the Table.