Table of Contents
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 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 REM 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 - 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. Try Step 4 first and return to this step if something does not work.
