Solved

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

Posted on 2011-02-16
7
569 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:
ewangoya 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:ewangoya
ID: 34911581

@tigin44

Thats the same article I already provided above
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

910 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

20 Experts available now in Live!

Get 1:1 Help Now