Solved

how to copy usrers ( ID, Passwords ) and the rights from one server to the other server SQL server 2000?

Posted on 2007-04-10
3
229 Views
Last Modified: 2010-04-20
how to copy usrers ( ID, Passwords ) and the rights from one server to the other server in SQL SERVER 2000?
0
Comment
Question by:yanci1179
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Sham Haque earned 500 total points
ID: 18881950
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
0
 
LVL 18

Expert Comment

by:Sham Haque
ID: 18881961
this might help too:

Migrating Logins from One SQL Server to Another
http://www.databasejournal.com/features/mssql/article.php/2228611
0
 

Author Comment

by:yanci1179
ID: 18884410
thank you so much!!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now