Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

sql server express 2005

Is it possible to install sql server express 2005 on server 2012 r2
if so how please
0
doctorbill
Asked:
doctorbill
4 Solutions
 
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
 
doctorbillAuthor Commented:
Any way round this apart from using a VM on the server 2012 and compatible OS?
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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
 
doctorbillAuthor 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
 
doctorbillAuthor 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
 
doctorbillAuthor Commented:
Thanks all
0
 
doctorbillAuthor Commented:
solution
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now