INF: Backup of Logins with Integrated and Mixed Security

 Last reviewed: April 30, 1997
Article ID: Q131012

The information in this article applies to:
  • Microsoft SQL Server, versions 4.2, 4.21, and 4.21a

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 : kbtool SSrvWinNT
Version : 4.2 4.21 4.21a
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.