Linked server OH NOES

So you might find yourself creating a linked server…might find yourself getting the below error:

There is no remote user ‘YOURUSERNAME’ mapped to local user ‘NT AUTHORITYSYSTEM’ from the remote server

That means you might be elite enough to know how to move sql from system to system using drive mappings…

So then you might be elite enough to know to run:

use master
Alter Service Master Key Force Regenerate

Leave a Reply

Your email address will not be published. Required fields are marked *