There is no remote user 'sa'mapped tp local user '(null)' from the remote server 'SQLServer2000'.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

Check if executing this query on the source server helps

ALTER SERVICE MASTER KEY FORCE REGENERATE

More information on this command here

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

YTZ SSCommitted Points: 1707 More actions · Answer 2

Adiga:

Thanks for the reply.

I setup the linked server by,

1) Right click "Linked Servers" - New Linked Server

2) Linked Server: SQLServer2000

3) Server Type: Select SQL Server

4) Security:

click Add

Local Login: LS (under sysadmin role)

Remote User: LKS (under sysadmin role

Remote password: YYYYYYYY

5) OK

There is no error and SQLServer2000 is appeared on Linked Server.

Then I run SELECT * FROM SQLServer2000.msbd.dbo.backupfile, and got error:

OLE DB provider "SQLNCLI" for linked server "SQLServer2000" returned message "Invalid authorization specification".

Msg 7399, Level 16, State 1, Line 5

The OLE DB provider "SQLNCLI" for linked server "SQLServer2000" reported an error. Authentication failed.

Msg 7303, Level 16, State 1, Line 5

Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SQLServer2000".

Any suggestion?

Thanks

Adiga One Orange Chip Points: 27284 More actions · Answer 3

Try adding the Linked Server using the below query.

EXEC sp_addlinkedserver 'RemoteServer\InstanceName', 'FALSE', 'locallogin','remotelogin','remotepassword'

GO

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Cookies on SQLServerCentral