SQL Users Ids - Mutiple Servers

Question

SQL Users Ids - Mutiple Servers

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

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

Eric Peterson Hall of Fame Points: 3192 More actions · Answer 1

ids can be transfered between machines using the following script

http://support.microsoft.com/kb/246133

Also if using Log Shipping or Mirroring for your backups, it saves lots of security issues having all of the SQL services running under a single Windows ID.

Good luck

Eric

mybid2003 SSCertifiable Points: 6620 More actions · Answer 2

I have tried that script (http://support.microsoft.com/kb/246133) in SQL2005, but I was getting the below error:

Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12

Invalid object name 'master..sysxlogins'.

.

nc-ghost Grasshopper Points: 19 More actions · Answer 3

Does this type of process require them to be on a domain? Can it be just in a workgroup?