Migrating databases from sql 2000 to 2005

Question

Migrating databases from sql 2000 to 2005

sureshdeenu

Right there with Babe

Points: 796
More actions
December 4, 2009 at 9:27 am

#218310

I have Moved the databases from sql 2000 to 2005 using detach and attach method, and transfered logins using the script available in Microsoft. After doing that the logins are not available at Server level. Can somebody help me on this..

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736557 More actions · Answer 1

What scirpt did you use? If you ran the sp_help_revlogin script, the logins are there. Logins are only at the server level. Users are at the database level.

sureshdeenu Right there with Babe Points: 796 More actions · Answer 2

How can i check whether all the logins are moved from 2000 to 2005 or not

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

use the sp_help_revlogin script - execute from the Master database.

You need to execute it from the 2000 server, copy the results to the 2005 server and then execute that.

To verify that the logins were transferred, do the following from ssms (Management Studio)

1. Connect to your database server

2. Expand security

3. Expand Logins

You should be able to see your transferred logins from there.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Run this two (2) stored procedures on each of your servers and database(s)

sp_Helplogins

sp_helpuser

Compare the results from each server and each database. This should allow you to determine which have been successfully transferred and which have not been successfully transferred.

Or

Proceed as directed by CirquedeSQLeil

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

sureshdeenu Right there with Babe Points: 796 More actions · Answer 5

Thankyou all guys, This is all new to me, Please help me out with the issues. I will keep posting

sureshdeenu Right there with Babe Points: 796 More actions · Answer 6

How do we refresh schema and data in a database? and move to test server to UAT Server?

Ron McCullough SSC Guru Points: 63877 More actions · Answer 7

Before making the transfer to the User Acceptance Testing (UAT) server may I suggest you read the following, if you have not already done so.

SQL Server 2005 Books Online (September 2007)

Backward Compatibility

and read each of the additional links in that document.

This information may cause you to test and possible alter code on your development server before moving to UAT.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]