Microsoft KB Archive/131012

= INF: Backup of Logins with Integrated and Mixed Security =

Article ID: 131012

Article Last Modified on 2/22/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q131012



SUMMARY
In order to backup SQL Server logins, when SQL Server is running Integrated or Mixed Security mode, the NTBackup utility must be used to create a current backup of the Windows NT Registry after new logins are added.



MORE INFORMATION
When Windows NT Groups are granted permissions to connect to SQL Server by either the xp_grantlogin extended stored procedure or the SQL Security Manager, the Windows NT Group is granted security permissions in the Windows NT Registry.

To backup the Windows NT Registry with NTBackup, choose to backup the drive that Windows NT is installed on, and select the Backup Registry checkbox on the Backup Information dialog window.

To restore the Windows NT Registry with NTBackup, choose a tape that has the Windows NT Registry on it, restore the drive that Windows NT is installed on, and select the Restore Local Registry check box on the Restore Information dialog window.

Additional query words: backup login Windows NT

Keywords: kbinfo KB131012

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.