Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
 Posted - 2007-10-25 : 14:51:27
|
| I am trying to use a linked server and it works as long as I do not specify the sp_addlinkedserver @provstr parameter. If I specify that parameter I always get a 7416 "Access to the remote server is denied because no login-mapping exists" error. I have tried adding the logins various ways but it's very specific to the @provstr parameter, and it doesn't even matter what I put in that parameter. As soon as I put something in there whether it is valid or invalid, I get the error.Anyone else seen this? There is an amazing lack of any discussion about the error when I search for it. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-25 : 22:14:41
|
| Did you try to create linked server with sp_addlinkedserver? What's your whole statement? |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-10-25 : 23:27:52
|
| Yes, I used sp_addlinkedserver absolutely standardEXEC sp_addlinkedserver @server= 'linkedname', @srvproduct='', @provider='SQLNCLI', @datasrc='servername', @catalog='mydatabase'EXEC sp_addlinkedsrvlogin 'linkedname', 'true', 'AppUser'If I do that it works fine, but like this I get the error, when I try to use linkedserverEXEC sp_addlinkedserver @server= 'linkedname', @srvproduct='', @provider='SQLNCLI', @datasrc='servername', @catalog='mydatabase', @provstr='Failover Partner=otherservername'EXEC sp_addlinkedsrvlogin @rmtsrvname='linkedname', @useself='true', @locallogin='AppUser'It doesn't make any difference what I put in the @provstr parameter - the sp_addlinkedserver statement always works fine (even if I put junk in there) but the error is always the same when I try to use the linked server - 7416: "Access to the remote server is denied because no login-mapping exists" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-25 : 23:55:05
|
| What's your purpose of @provstr? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-10-26 : 00:09:14
|
| On the one hand I guess I'd say, does it really matter? The purpose is to do any of the things that you can do with the @provstr. But, in my case I want to specify the Failover Partner, which the sp_addlinkedserver docs in BOL specifically mentions under @provstr. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 01:10:57
|
| Does the server have mirrored db? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-10-27 : 21:16:34
|
| Yes |
|
|
|
|
|
|
|
|
Linked Server Error 7416