Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 0 subscribers
  • Views 24475 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SEC 5.2 and SQL SERVER 2008 R2

donkers

Dear all,

I have SEC 5.0.0.8 installed with SQL 2008 R2 SP2 as the back-end. 

When I attempt to upgrade the database, I get "The version of SQL Server instance ... is not supported" in the UI; "The version of the sql instance selected is not valid" in the bootstrapper log.  SQL 2008 support is available on the system requirements page, but I notice there's no mention of SQL 2008 R2.  It must have worked at some point, because I'm using SQL 2008 R2 right now with SEC 5.0.0.8...

Is it possible to upgrade the database with this version of SQL, or do I need to create an instance of SQL 2008 Express?

many thanks!

:52106


This thread was automatically locked due to age.
Parents
  • 0

    My SYS_SPROC_VERSION is 10.50.4000.  The difference is that you're on SP1, I'm on SP2.

    This is a named SQL instance "MSSQLSERVER2008".  The dropdown to choose the SQL instance has only one entry, "MSSQLSERVER2008". 

    However, the default SQL instance on the server is SQL 2000.  Could the installer be checking the wrong instance?

    Muchly appreciate your help Jak!

    -ben

    :52114
Reply
  • 0

    My SYS_SPROC_VERSION is 10.50.4000.  The difference is that you're on SP1, I'm on SP2.

    This is a named SQL instance "MSSQLSERVER2008".  The dropdown to choose the SQL instance has only one entry, "MSSQLSERVER2008". 

    However, the default SQL instance on the server is SQL 2000.  Could the installer be checking the wrong instance?

    Muchly appreciate your help Jak!

    -ben

    :52114
Children
No Data
Unfiltered HTML