none
SQL 2000 linked server to sybase

    Question

  • Hi,

    I created a linked server from SQL 2000 to sybase client. On our dev, SQL is running on a local account and when with sa user I'm able to pull the records from sybase. On our prod, SQL service is running on a domain account, I'm able to pull records from sybase with a domain account, but not with the sa user. Please help

    Thanks

    Manju

    Friday, April 05, 2013 5:37 PM

Answers

  • You need to set up login mapping with sp_addlinkedsrvlogin:

    sp_addlinkedsrvlogin SYBASE, 'false', 'sa', 'sa', 'PASSWORD over there'


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Friday, April 05, 2013 9:44 PM