• Replies 5 replies
  • Subscribers 583 subscribers
  • Views 281 views
  • Users 0 members are here
Options
Related

Citect Historian 2016 Creating database

Nizami

Good day everyone.

I'm trying to create Historian server using Historian Server wizard. I have 2 SQL Server Instances on my PC. 1st of them is Default instance (MSSQL Server 2008), other one is SQLSERVER2014 Instance. When I select 2008 instance the Historian server is created without any error. The next steps comes normally. But when I select 2014 version instance I get "Creating Historian database failed, executenonquery failed for database 'master' " error.

Thank you all for any help that can offer.

Parents
  • Hi Nizami,

    It might be worth checking the following:

    If you are using an existing installation of SQL Server, you need to check that
    Microsoft SQL Server Backward Compatibility Components are installed. This can
    be confirmed in the Windows Add/Remove Programs tool.

    Also check the SQL Server security authentication mode is set to mixed mode (SQL Server and Windows Authentication).

    Kind regards
    Olivier
Reply
  • Hi Nizami,

    It might be worth checking the following:

    If you are using an existing installation of SQL Server, you need to check that
    Microsoft SQL Server Backward Compatibility Components are installed. This can
    be confirmed in the Windows Add/Remove Programs tool.

    Also check the SQL Server security authentication mode is set to mixed mode (SQL Server and Windows Authentication).

    Kind regards
    Olivier
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.