SQL Problem!Help!!

[littledemeo]

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

 

[chumpywumpy]

That is a problem with the linked server.

To view the content, you need to sign in or register

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.

To view the content, you need to sign in or register

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.