Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Incompatible SQL Server Version error when Restoring I/NET Database in DBCreate

Issue

When restoring database, an error will show up, saying that version is incompatible with this server.

Product Line

EcoStruxure Building Operation, TAC INET

Environment

I/NET

Cause

This is usually caused by restoring new SQL database to older version or under different kind of Operation Systems (like restoring a 64 bit database to a 32bit SQL server). Microsoft doesn't like to do this.

Resolution

There is build number matrix for each SQL server version:

 

  RTM (Gold, no SP) SP1 SP2 SP3 SP4
SQL Server 2012 11.00.2100.60 11.00.3000      
SQL Server 2008 R2 10.50.1600.1 10.50.2500 10.50.4000    
SQL Server 2008 10.00.1600.22 10.00.2531 10.00.4000 10.00.5500  
SQL Server 2005 9.00.1399.06 9.00.2047 9.00.3042 9.00.4035 9.00.5000

So check the build number in the error message and download the corresponding version of SQL to restore and be used for I/NET. 

Refer to How to Troubleshoot on DBCreate for more issues about DBCreate.

Tags (1)
No ratings
Contributors