SQL Problem!Help!!

[littledemeo]

How can I fix this pro?
Help me please!Thx!

[MentaL]

[chumpywumpy]

That is a problem with the linked server.

http://support.microsoft.com/kb/814398

That may help but if not check your linked server settings. If you open the linked server item and click on Tables you should see some tables but i think you will get an error if you try clicking it. Bring up the properties of your linked server and check against my settings:

Linked server: GAMESERVER
Product name: gameserver
Provider name: Microsoft OLE DB Provider for ODBC Driver
Provider string: DRIVER={SQL Server};SERVER=<servername>;UID=;PWD=";

> Security tab - set to "Be made without using a security context"

> Server options tab - Tick all tickboxes.

Also, with the provider string do not change anything except the <servername> but, do not add UID/PWD or anything, leave it just as it is after putting your servername in ;)

[littledemeo]

That is a problem with the linked server.

http://support.microsoft.com/kb/814398

That may help but if not check your linked server settings. If you open the linked server item and click on Tables you should see some tables but i think you will get an error if you try clicking it. Bring up the properties of your linked server and check against my settings:

Linked server: GAMESERVER
Product name: gameserver
Provider name: Microsoft OLE DB Provider for ODBC Driver
Provider string: DRIVER={SQL Server};SERVER=<servername>;UID=;PWD=";

> Security tab - set to "Be made without using a security context"

> Server options tab - Tick all tickboxes.

Also, with the provider string do not change anything except the <servername> but, do not add UID/PWD or anything, leave it just as it is after putting your servername in ;)

sir:
Where am I found my sever name?
Could you tell me please?
Thx bro!

[chumpywumpy]

Open a command prompt and type "hostname" or check the Computer name panel in System in the control panel.