sql server express 2005

Is it possible to install sql server express 2005 on server 2012 r2
if so how please
doctorbillTechAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
Microsoft wont support SQL 2005; After all you are installing SQL Express, any particular reason why it has to be SQL 2005 ? If it is an existing sql 2005 database, you can still set the compatibility of the database to sql 2005
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
SQL2005 ????
You can install 2008R2 on 2012R2
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Per Microsoft KB article [http://support.microsoft.com/kb/2681562], SQL Server 2005 (and earlier releases of Microsoft SQL Server) are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 8.1 or Windows 8 detects an instance of SQL Server 2005.

You can install SQL Server 2005 on a Windows Server 2008 or 2008 R2.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
doctorbillTechAuthor Commented:
Any way round this apart from using a VM on the server 2012 and compatible OS?
0
 
doctorbillTechAuthor Commented:
Can you explain how to set the compatibility please
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
you still haven't provided the requirements ? Once you install sql server, you can restore the database from sql 2005; by default the restored database, retains its previous compatibility.
To change the compatibility, right click on the server -> properties -> Options ->  there you can see the option
0
 
doctorbillTechAuthor Commented:
I will try this and let you know
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
There are benefits to install the more recent version of SQL Server Express:
- Support
- New features
- Limitation for database size increased from 4GB to 10GB

And being a free tool I don't know why you should keep an old version of SQL Server Express.

Also as Aneesh said you can have a MSSQL 2005 database in a MSSQL 2012 instance by setting the compatibility mode to 9.0
0
 
doctorbillTechAuthor Commented:
Thanks all
0
 
doctorbillTechAuthor Commented:
solution
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.