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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

From novice to tech pro — start learning today.