SQL Server and VS Express 2013 – Troubleshooting Common Issues

sql serversql server 2014sql-server-2012

I recently reinstalled Windows and am trying to set up SQL Server again with an existing database. I've tried installing SQL Server 2012 and 2014, and continuously get the same error. The error says that the database is version 782 and this version of SQL Server is only compatible with 706 and below. I get this error with both SQL Server 2012 and 2014. I thought 2014 was compatible with 782+.

How can I attach the database?

Best Answer

Sql Server DB verion 782 is for SQL Server 2014 and 706 is for SQL Server 2012.

and SQL Server 2014 will support all the previous version, but SQL Server 2012 will not support DB version 782(SQL Server 2014 version)

Probably something wrong with installation of SQL server 2014 and you still have SQL server 2012 version, Please check the SQL server version

SELECT @@version