Ecolego Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======Installing the Parameter Database - Advanced topics======

=====To Step 3:=====
In the case of errors the most frequent situation is that your SQL Server is not installed as default instance, in this case you need to determine its name [[List instances of SQL Server installed|List instances of SQL Server installed]] and edit the inst.bat file:

Comment (put REM before) the line //sqlcmd -b -i CreateFaciliaDBTemplate.sql -o log.txt
//
Uncomment (Remove //REM// from the beginning of) the line R//EM sqlcmd -b -S SERVER\INSTANCE -i CreateFaciliaDBTemplate.sql -o log.txt//

Substitute SERVER to //localhost// and INSTANCE to the name of your SQL Server determined by [[List instances of SQL Server installed|List instances of SQL Server installed]] - in most cases it will be either //SQLEXPRESS// or //MSSQLEXPRESS//

For example: //sqlcmd -b -S localhost\SQLEXPRESS -i CreateFaciliaDBTemplate.sql -o log.txt//

The other things which you can change by editing inst.bat are default database name (//facilia_db_template//) and way of authentication (by default - Windows authentication, can be chaged to SQL Server login+password)

Comments in the inst.bat will help you.

=====To Step 4=====
**Enable TCP/IP connection to the server**

1) Run **SQL Server Configuration Manager**

For Windows 10 - search for the “Computer management” tool and expand the node “Services and applications” to get the node “SQL Server Configuration Management”.

For other operation systems - SQL Server 2016 is located in the apps group //Microsoft SQL Server 2016//. If you are using SQL Server 2012, then it is located in the sub-folder //Microsoft SQL Server 2012->Configuration tools//.

2) In Configuration manager - select **SQL Server Network Configuration**.

3) Click on the **Protocols for //instance_name//**. In the case if only one SQL server is installed on your computer - the list will contain only one line **Protocols for MSSQLEXPRESS** or **Protocols for SQLEXPRESS**

4) Double-click on **TCP/IP**

5) In the dialog which will appear - set **Enabled** to **Yes** (or verify that it is in Yes state) and click OK

6) In Configuration manager - select **SQL Server Services* (first node in the list), right click on the ‘SQL Server (MSSQLEXPRESS)’ (or ‘SQL Server (SQLEXPRESS)’) and select ‘Restart’**

If you don’t have SQL Server as default instance you might need to make addtional settings following the **[[additional instructions|additional instructions]]**. Try Step 4 first and return to this step if something does not work.
Ecolego Wiki

User Tools

Site Tools

Page Tools
