Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 0 subscribers
  • Views 24480 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

    Hi,

    That version of SQL should be fine for all current version of SEC.

    I know that the installer connects to the instance and runs the stored procedure

    sp_server_info

    Looking for the SYS_SPROC_VERSION attribute.

    As long as the major version is greater to equal to 9 it's valid (MSDE and SQL 2000 have version less than 9, which is what it's looking for.

    So I would expecute sp_server_info as the same account you're running the SEC installer as to see what value you get back for the SYS_SPROC_VERSION attribute.  If you don't have SQL Server Management Studio handy you could run:

    sqlcmd -E -S .\sophos -Q "sp_server_info" | find "SYS_SPROC_VERSION"

    Mine reports as 10.50.2500, which according to http://sqlserverbuilds.blogspot.co.uk/ is SQL 2008 R2 which is what I'm running and the same version as listed in SQL Management Studio next to the instance name at the top of the tree.

    Hope this helps.

    Regards,

    Jak

    :52108
Reply
  • 0

    Hi,

    That version of SQL should be fine for all current version of SEC.

    I know that the installer connects to the instance and runs the stored procedure

    sp_server_info

    Looking for the SYS_SPROC_VERSION attribute.

    As long as the major version is greater to equal to 9 it's valid (MSDE and SQL 2000 have version less than 9, which is what it's looking for.

    So I would expecute sp_server_info as the same account you're running the SEC installer as to see what value you get back for the SYS_SPROC_VERSION attribute.  If you don't have SQL Server Management Studio handy you could run:

    sqlcmd -E -S .\sophos -Q "sp_server_info" | find "SYS_SPROC_VERSION"

    Mine reports as 10.50.2500, which according to http://sqlserverbuilds.blogspot.co.uk/ is SQL 2008 R2 which is what I'm running and the same version as listed in SQL Management Studio next to the instance name at the top of the tree.

    Hope this helps.

    Regards,

    Jak

    :52108
Children
No Data
Unfiltered HTML