• Replies 3 replies
  • Subscribers 584 subscribers
  • Views 135 views
  • Users 0 members are here
Options
Related

Database connection string when running as a service

Bas

Does anyone have experience with connecting a database when running as a service? One of my customers has a MS SQL Server and Citect V2018R2 with the October update. When not running as a service a defined SQL Server user is able to connect to the database, when running in service mode it fails. The Cicode is triggered from the Alarm Server process.

I did some tests with for instance the following connection string:

"Driver={SQL Server};Server=Server\SQLEXPRESS;Database=Test;User Id=Citect;Password=Citect;"

Thanks in advance

Parents

  • Hi Bas,

    Chances are that your SQL server is communicating via the "shared memory" / or "named pipes" protocol, which might not work when running as a service. Yoy could try to enable one of the other Server Network Protocols or change the configuration of the protocols that are in use by running the SQL Server Configuration Manager -> SQL Server Network Configuration.

    Groet,
    Patrick

Reply

  • Hi Bas,

    Chances are that your SQL server is communicating via the "shared memory" / or "named pipes" protocol, which might not work when running as a service. Yoy could try to enable one of the other Server Network Protocols or change the configuration of the protocols that are in use by running the SQL Server Configuration Manager -> SQL Server Network Configuration.

    Groet,
    Patrick

Children
No Data
© 2024 AVEVA Group Limited or its subsidiaries. All Rights Reserved.