Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I want to install Sinergia using a different SQL Server 2005 instance than .SQLEXPRESS What should I do?

April 26, 2017different install instance sinergia SQL Server

0

Posted

I want to install Sinergia using a different SQL Server 2005 instance than .SQLEXPRESS What should I do?

1 Answer

0

Posted

To modify the SQL Server instance used by Sinergia you must: 1. Find and replace all the ocurrences of .\sqlexpress in the *.bat files of the installation folder (C:\Program Files\GLR\Sinergia) 2. Find and replace all the ocurrences of .\sqlexpress in the web.config file in the folder of the website C:\Inetpub\wwwroot\Sinergia\Web 3. Find and replace all the ocurrences of .\sqlexpress in the config file, C:\Program Files\GLR\Sinergia\workflow\Sinergia.WWF.Host.exe.config 4. Edit all enumerations, with data source type SQL, and modify the connection string defined updating it to the new SQL Server instance.