Access to the remote server is denied because no login-mapping exists

Access to the remote server is denied because no login-mapping exists

Script the linked server and check the @provstr parameter. It must specify a user ID. Even if the userid and password is specified elsewhere, the user id must also be in @provstr.

Example

Change this: @provstr=N’PROVIDER=SQLOLEDB;SERVER=xxxxxx’

into

This: @provstr=N’PROVIDER=SQLOLEDB;SERVER=xxxxxx;User ID=yyyyyyyy’

no need to specify the password here, that comes in the @rmtpassword parameter which you will have elsewhere in your script

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: