SQL 2000 instance upgrade to 2005

I have a server running an instance of SQL 2000 and I wish to upgrade this to SQL 2005. I can find loads of information regarding importing databases etc but I wish to simple upgrade the software so that I don't lose all the SQL user info, permissions and settings.

Thanks
John
RBG ITAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
hi

bassically 9 out of 10 times a simple upgrade will work for you.
just slid the dvd in and run the sql server installer.

i would recommend just before you upgrade use the "Sql Server Upgrade Advisor"
to learn about possible problems and issued your current system could have with the upgrade.

BTW: the sql server upgrade advisor is on the install dvd .
0
 
Kalpesh ChhatralaSoftware ConsultantCommented:
0
 
shalabhsharmaCommented:
Yes I agreed with ashilo  "Sql Server Upgrade Advisor" is the best way you should do.
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.