This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
installing_the_parameter_database_-_advanced_topics [2021/11/05 10:59] mina |
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 | ||
Line 8: | Line 8: | ||
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 of) the line R//EM sqlcmd -b -S SERVER\INSTANCE -i CreateFaciliaDBTemplate.sql -o log.txt// | ||
- | Substitute SERVER to // | + | Substitute SERVER to // |
For example: //sqlcmd -b -S localhost\SQLEXPRESS -i CreateFaciliaDBTemplate.sql -o log.txt// | For example: //sqlcmd -b -S localhost\SQLEXPRESS -i CreateFaciliaDBTemplate.sql -o log.txt// | ||
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. |