Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to connect using sp_addlinkedserver
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01183230
Message ID:
01183301
Views:
16
You have to specify login credentials for the linked server using sp_addlinkedsrvlogin. Otherwise the linked server uses users's login credentials.

>Yes, but notice I'm not trying to connect using 'sa', it is 'MyID' and 'MyPWD'. I'm connected to the local SQL server using 'sa', in QA, but trying to connect the remote using 'MyID' and 'MyPWD'. Why is it trying to connect using 'sa' and not 'MyID'
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform