Solved

copy database users from one sql server 2005 to another sql server 2008

Posted on 2011-02-16
7
574 Views
Last Modified: 2012-05-11
expert,

I copied one database name FKDB from sql 2005 server to another server SQL 2008,
how can I copy FKDB database all users to SQL server 2008?
I use this command:
SELECT *  FROM sys.syslogins a join
   Roomtracker..sysusers b on a.sid = b.sid
In server sql 2005, how can I copy sid to sever 2008?

Thanks,
Lynn
0
Comment
Question by:yrcdba7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 500 total points
ID: 34911538

Please take a look at this article

http://support.microsoft.com/kb/246133
0
 
LVL 26

Expert Comment

by:tigin44
ID: 34911557
this link will guide you about transfering logins...

http://support.microsoft.com/kb/246133
0
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 34911581

@tigin44

Thats the same article I already provided above
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:yrcdba7
ID: 34911679
above links are for all security login, I only need one database users
security login in sql 2008 match sql 2005
0
 

Author Comment

by:yrcdba7
ID: 34911694
should I run this in SQl server 2008

create login login_name with password = 'pass2' , sid = 0x4A0F0AD9A3901D4EB7AE45849D30A8D1

I know sid, and login_name, but I don't have password,

0
 
LVL 26

Expert Comment

by:tigin44
ID: 34911754
ewangoya
I have seen your answer when I posted mine... You were quick...

you should transfer user account along with the logins... You cant use just the user accounts without logins...
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34912955
Once you have transferred your Logins you can re-sync the users by using the system stored procedure sp_change_users_login, see here:
http://msdn.microsoft.com/en-us/library/ms174378.aspx
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

729 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