SQL 2000 linked server to sybase


  • 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



    Friday, April 05, 2013 5:37 PM


  • You need to set up login mapping with sp_addlinkedsrvlogin:

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

    Erland Sommarskog, SQL Server MVP,
    Friday, April 05, 2013 9:44 PM