User Tools

Site Tools


installing_the_parameter_database_-_advanced_topics

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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]] and edit the inst.bat file:
  
 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 //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//+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// 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.
installing_the_parameter_database_-_advanced_topics.1636106345.txt.gz · Last modified: 2021/11/05 10:59 by mina