installing_the_parameter_database_-_advanced_topics
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
installing_the_parameter_database_-_advanced_topics [2021/11/05 10:56] mina created |
installing_the_parameter_database_-_advanced_topics [2021/11/05 11:00] (current) mina |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| =====To Step 3:===== | =====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: | + | 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]] |
| - | Comment (put REM before) the line sqlcmd -b -i CreateFaciliaDBTemplate.sql -o log.txt | + | 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// | ||
| - | Uncomment (Remove REM from the beginning | + | Substitute SERVER to // |
| - | Substitute SERVER to localhost and INSTANCE to the name of your SQL Server determined by List instances of SQL Server installed | + | For example: // |
| - | 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, |
| - | + | ||
| - | 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, | + | |
| Comments in the inst.bat will help you. | Comments in the inst.bat will help you. | ||
| Line 23: | Line 23: | ||
| 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 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-> | + | 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 |
| - | 2)In Configuration manager - select **SQL Server Network Configuration**. | + | 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** | + | 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** | + | 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 | 5) In the dialog which will appear - set **Enabled** to **Yes** (or verify that it is in Yes state) and click OK | ||
| Line 35: | Line 35: | ||
| 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’** | 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. | + | 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. |
installing_the_parameter_database_-_advanced_topics.1636106203.txt.gz · Last modified: 2021/11/05 10:56 by mina
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
