linked server 7399 error when login with sa user

Question

hi 

I have an access mdb file in a pc that named "FT-PC" . i tried to connect to this database with sql server 2008 r2 throught this script :

EXEC sp_addlinkedserver @server = 'Ft_link',
 @provider = 'Microsoft.Jet.OLEDB.4.0',
  @srvproduct = 'OLE DB Provider for Jet',
   @datasrc = '\\FT-PC\database\ft.mdb'

when i connecting to the server with windows authentication mode , i have access to the data of my created link server but when i connecting with sql server authentication mode (with sa user) , i can't access to the linked server with 7399 error .

Answer 1

Hi,

Have you checked http://support.microsoft.com/kb/2450479?

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me