Re: recovering logins

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 23:32:20 +0200

Search KB for sp_help_revlogins. It will generate a script for you where the script includes
sp_addlogins and sp_grantlogin for your logins. The SQL Server logins will be created using the
original SID and passwords. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cinderella" <Cinderella@discussions.microsoft.com> wrote in message 
news:F0314D8C-305E-4B2A-AAA6-01B9DCAD12BA@microsoft.com...
> what is the best way to recover logins.
> Let's say I need to rebuild a server or if my server crashes and I need to
> reinstall sql server.  What can I do so that I have a file or something that
> saved my logins so that I can get them back on the server?
>
> I'm used to sybase where you can just bcp the syslogins table.

Relevant Pages

  • Re: help :Deploying a preconfigured database
    ... Transfer Logins and Passwords Between Instances of SQL Server ... You will want to make sure that you create appropriate script files to set ... lets say that your config requires the SQL Server login 'user.' ...
    (microsoft.public.sqlserver.setup)
  • Re: A script to capture Orphan userids
    ... to create logins on "downstream" servers. ... Transfer Logins and Passwords Between Instances of SQL Server ... So I'd like to set up an automation using a script to catch orphan ids. ...
    (microsoft.public.sqlserver.server)
  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • No Application Logins Allowed - SOX
    ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
    (microsoft.public.sqlserver.security)