RBG IT
asked on
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
Thanks
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes I agreed with ashilo "Sql Server Upgrade Advisor" is the best way you should do.
http://blogs.msdn.com/b/sqlserverfaq/archive/2008/07/31/upgrade-of-sql-server-2000-instance-to-sql-server-2005-fails-with-error-similar-to-enforce-password-policy.aspx