Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unable to connect using sp_addlinkedserver
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01183230
Message ID:
01183301
Vues:
17
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform