Re: transfer user login name and pswd to a new server?
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/30/04
- Next message: t s: "Re: How do I merge NDF files into the MDF ??"
- Previous message: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Sep 2004 12:26:11 +0200
You need to understand what logins and users are in SQL Server and the difference. Take an hour or
so to read up on this if you don't feel 100% certain about it. This includes things like the user
name might be different from the login name, syslogins, sysxlogins, sysusers, the SID column in
sysusers and the mapping to syslogins etc.
>From there you should be able to determine what is best to use:
sp_help_revlogins (from KB)
sp_change_users_login
There's a GUI for sp_change_users_logins available at www.dbmaint.com (the free utilities section)
which can map several users at one go.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Michael" <ruihuiwen@hotmail.com> wrote in message news:e7H10TopEHA.3708@TK2MSFTNGP10.phx.gbl... > is there any script can fix my problem, I need it urgently ... > thanks again. > > > > > "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message > news:eozFcXlpEHA.3668@TK2MSFTNGP15.phx.gbl... > > See if this helps: > > > > How to move SQL Server from one computer to another > > http://vyaskn.tripod.com/moving_sql_server.htm > > > > How to troubleshoot orphan users in SQL Server databases > > http://vyaskn.tripod.com/troubleshooting_orphan_users.htm > > > > -- > > HTH, > > Vyas, MVP (SQL Server) > > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > > > > "Michael" <ruihuiwen@hotmail.com> wrote in message > > news:%23RNjJBlpEHA.1988@TK2MSFTNGP09.phx.gbl... > > Hi, > > > > Window2000 server +SQL server 2000 > > I am trying to migrate my current SQL server application to a new setup, > > my setup procedure is as below procedure: > > 1.Install OS win2000 + SP4 > > 2. Install SQL server 2000 +SP2 > > 3. backup MASTER db and MyDB on the old server, then copy these backup to > > new server > > 4. Restore MASTER db from the backup copied > > 5. Restore MyDB db from the backup too. > > 6. I can see all the logins are in MASTER db, and MyDB now, > > 7. I got problem, the login can not be used, always login failed. > > 8. I searched MS web, tried KB246133, but problem still the same, > > 9. the nI tried run sp_users_change_login, but failed again... > > > > Can anyone tell me how to make all the logins and pswd working the now > > server? > > I have around 1000 users, I can not simply recreate them all. > > > > Thank you very much!!! > > > > Michael > > > > > > > > > > > > > > > >
- Next message: t s: "Re: How do I merge NDF files into the MDF ??"
- Previous message: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
