Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-02-16
7
Medium Priority
?
578 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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 2000 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

886 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