Linked Server Problem

[charlise]

Hi,
I'm trying to add a linked server and when I add it using Enterprise Manager, it adds okay, but there are no tables are views listed under the server. Does anyone know how to correct this?

 

[SQLBill]

Do you have permissions on the tables/views/databases on the linked server?

-SQLBill

Posting advice: FAQ481-4875

 

[charlise]

I do have permissions, and I'm getting an Error: 7399

 

[SQLBill]

Is that error in the SQL Server logs or the Event Viewer logs?

Is there anything more about that error?

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

What username and password are you using to connect to the access database?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[charlise]

Well, it's not an access database, but another SQL Server and I am logged in as myself with System Administrator permissions. I can add the linked server with no problem, but there are no tables and views and when I try to query that server from the one I'm linking it to (using the correct syntax) it says SQL Server does not exist or access is denied. It's like it's not recognizing it. Help .

 

[mrdenny]

Sounds like you left the provider as the default in the GUI when you created the link. The error message you provided is a Jet error message. Check your linked server config, and make sure that you have the SQL driver not the Jet driver (or some other driver) selected.

If you do you'll need to drop and recreate the linked server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com