Re: transfer user login name and pswd to a new server?

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

From: Michael (ruihuiwen_at_hotmail.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 08:33:12 +0800

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
>
>
>
>
>
>
>

Relevant Pages

  • Re: SBS2003, NTBackup-Fehler
    ... Falls das Problem noch verhandeln ist,werde ich vorschalgen nächste Schritte durchzuführen. ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: SBS Backup problems
    ... search for *SQL* there a Microsoft SQL Server folder located under C:\Program ... > From the backup log, I find the following error message. ... > - You back up data from a volume that contains a Microsoft SQL Server ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Recover records from ldf file.
    ... Tibor Karaszi, SQL Server MVP ... through exactly how this adds up in the old architecture, but methinks that there wouldn't be much of a difference (although we had database devices, database fragmented, syslogs and all that jazz in old architecture - instead of mdf and ldf files). ... predating the database, then when the log restore is done, it will skip log records until it gets to the first one after the backup you restored? ... does this still work if the 1st log record in the .ldf file is from after the good backup and not before? ...
    (microsoft.public.sqlserver.server)
  • Re: Disk Management Strategies...? (here we go again!)
    ... SQL Server best practices would dictate at least three ... Copies and backup strategies to the mix, ... the impact of Shadow Copies and backup strategies. ... like the idea of organizing backups by partition. ...
    (microsoft.public.windows.server.sbs)