# DBAmp error: Access to the remote server is denied because no login mapping exists

**URL:** <https://community.cdata.com/t/dbamp-error-access-to-the-remote-server-is-denied-because-no-login-mapping-exists/270>\
**Category:** Editions\
**Tags:** article, salesforce, dbamp\
**Created:** [July 19, 2023, 7:16pm UTC](https://community.cdata.com/t/dbamp-error-access-to-the-remote-server-is-denied-because-no-login-mapping-exists/270 "2023-07-19T19:16:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dani\_Moran](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\
**Post date:** [July 19, 2023, 7:16pm UTC](https://community.cdata.com/t/dbamp-error-access-to-the-remote-server-is-denied-because-no-login-mapping-exists/270/1 "2023-07-19T19:16:52Z")

</div>

According to Microsoft, when using a local SQL Server non-admin or non-Windows account with their provider, if the Provider String option is used, it must also contain a User ID parameter. This article from Microsoft goes into those details: [Access to the remote server is denied because no login-mapping exists. | Microsoft Learn](https://docs.microsoft.com/en-us/archive/blogs/mdegre/access-to-the-remote-server-is-denied-because-no-login-mapping-exists)

DBAmp Linked Servers only need a provider string if you are connecting to a sandbox, or if your Salesforce org requires a MyDomain URL to log in. In that case, if you are getting this error, your Provider String should look like: ‘App=[https://test.salesforce.com](https://test.salesforce.com);User ID=\<local\_Sql\_Login\>’ or ‘App=\<your MyDomain URL\>;User ID=\<local\_Sql\_Login\>’