We had to reinstall MSSQL on one of our servers now when I set up a linked
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
Showing posts with label associate. Show all posts
Showing posts with label associate. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
Linked Server Error
We had to reinstall MSSQL on one of our servers now when I set up a linked
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.
I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.
I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
Linked Server Error
We had to reinstall MSSQL on one of our servers now when I set up a linked
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
Subscribe to:
Posts (Atom)