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

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
yrcdba7Asked:
Who is Participating?
 
Ephraim WangoyaConnect With a Mentor Commented:

Please take a look at this article

http://support.microsoft.com/kb/246133
0
 
tigin44Commented:
this link will guide you about transfering logins...

http://support.microsoft.com/kb/246133
0
 
Ephraim WangoyaCommented:

@tigin44

Thats the same article I already provided above
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
yrcdba7Author Commented:
above links are for all security login, I only need one database users
security login in sql 2008 match sql 2005
0
 
yrcdba7Author Commented:
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
 
tigin44Commented:
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
 
Anthony PerkinsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.