cancel
Showing results for 
Search instead for 
Did you mean: 

Interesting SQL Issue

Bruce_Cranksh1
Level 6
Partner Accredited

Hi All

I'm busy with a new EV 9.0 sp1 installation

Anyway Deployment scanner is failing ,there is Red Warning on one of the SQL options and it says "SQL Incompatibility"

Ï have investigated this and the SQL DBA came back and said that the base install of EV is SQL 2000 but the SQL Instance he created is SQL 2005 SP3

I never thought you could have different versions of SQL running on the same server  but the DBA said this can be done ?

I am connecting to the SQL server with the Instance name ..so its name is redcrown\redcrown1,  so redcrown1 is the  SQL Instance  name

So even though I am  using the SQL Instance to connect would EV use the redcrown name to check the  version ...so is  that  why it is failing ?

Also another point ,I know the SQL instance was created is 2005 SP3 ..is there a way to bypass this possible error and just force EV to install ?Or is this not advisable as EV may use something on the  SQL server outside the provided Instance and the "normal " install of EV is SQL 2000 which is not supported

2 REPLIES 2

SK
Level 4
Partner Accredited

Does the install succeed if you set the database to be SQL 2000 compatible?

SK.

Bruce_Cranksh1
Level 6
Partner Accredited

I'll ask the custometr to try that and see if Deployement Scanner works

I havent even attempted the install as I am of the opinion it will fail ?