Post reply

Linked Servers: SS2K / A2K

  • December 10, 2002 at 2:41 pm

    #159305

    Actually, I've got two questions.

    #1: I create a new linked server to another SS2K db instance. But servers are started with the same account. I click on tables of the new linked server and get "Error 18456:Login failed for user." Which security context should I use ?

    #2: I created a linked server to a test copy of an Access 2000 mdb that I put on the same server sql server is on. No problem. When I try using the production A2K mdb on a different server, I get "Error 7399: Ole DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error'.

    Any thoughts?

  • December 13, 2002 at 8:00 am

    This was removed by the editor as SPAM

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply