Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

Upgrade SQL Express to Standard

I have come upon a server that has SQL Server Express 2008 R2. This should never have been used since they have a fully licensed copy of SQL Server 2008 R2 Standard. Is it possible to upgrade this instance to SQL Server 2008 R2 Standard? I would prefer to see the SQLEXPRESS instance completely gone and returned to MSSQLSERVER. I also would prefer to retain all the users and security and databases that have been created under the SQLEXPRESS instance.
Avatar of davorin
davorin
Flag of Slovenia image

Avatar of rwheeler23

ASKER

I had found these two articles. I am still not sure if I will see only the MSSQLSERVER instance or will it remain SVRNAME\SQLEXPRESS. My biggest concern are all the users that have been added and the roles assigned to them. I also have a third party product that has reports in SSRS and I know they will not deploy with any SQL express edition. I hope after the upgrade that it really will appear to everything that it is SQL Stadnard.
ASKER CERTIFIED SOLUTION
Avatar of davorin
davorin
Flag of Slovenia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am just hoping I can deploy the SSRS Reports after the upgrade. The software is from Microsoft and you know how picky that can be. Unfortunately it is not a virtual server so I have one chance to get it right.
Be sure that you have a valid backup.
I think i will treat this as a server move. I will capture all the logins, backup and then detach the databases, re-install the application to the new instance of SQL so it can set up its own security within SQL and then attach the database to the new MSSQLSERVER instance.
Thank you