MS SQL Server security - Access linked server

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Access linked server

Amit

2005-11-14, 8:23 pm

I am new to SQL. I am trying to setup a linked server but whenever I try to
view the tables it gives me an error saying
error 7399 : OLEDB provider 'microsoft.jet.oledb. 4.0' reported an error
OLEDB Error Trace

Thanks

Andy Davis

2005-11-18, 3:23 am

Hi,
have you linked a server using
sp_addlinkedserver and after that have you map logins for and from both
server in order to access it properly using
sp_addlinkedsrvlogin

read BOL for more on this .

--
Andy Davis
Active Crypt Team
--------------------------------------------
SQL Server Encryption Decryption Software
http://www.activecrypt.com
activecrypt@gmail.com

"Amit" wrote:

> I am new to SQL. I am trying to setup a linked server but whenever I try to
> view the tables it gives me an error saying
> error 7399 : OLEDB provider 'microsoft.jet.oledb. 4.0' reported an error
> OLEDB Error Trace
>
> Thanks

Sponsored Links