Skip to main content
Solved

CommVault new implementation failed due to Could not start the service MSSQL$Commvault

  • September 22, 2022
  • 4 replies
  • 643 views

Forum|alt.badge.img+5

CommVault installation failed when preconfigure workflow engine and i check the log found that error 
​​​​​​Could not start the service MSSQL$Commvault

Best answer by Jos Meijer

Please take a look at this question at MS:

https://learn.microsoft.com/en-us/answers/questions/663579/sql-server-is-unable-to-start-in-a-timely-fashion.html

Seems that the SQL installer encountered an issue and did not change installer default modellog path to the path used by your server.

You can remove the SQL and CV install and try again to see if the problem persists, or try to fix it by following their suggestion. Never tested this my self though.. But seen multiple cases where this has fixed the issue as you are basically manually correcting the modellog path:

1.Start the instance of SQL Server in master-only recovery mode by entering one of the following commands at the command prompt. The parameters specified in these commands are case sensitive. The commands fail when the parameters are not specified as shown.

o For the default (MSSQLSERVER) instance, run the following command:

 
  1. NET START MSSQLSERVER /f /T3608

 

o For a named instance, run the following command:

 
  1. NET START MSSQL$instancename /f /T3608

 

2.For each file to be moved, use sqlcmd commands or SQL Server Management Studio to run the following statement.

 
  1. ALTER DATABASE database_name MODIFY FILE( NAME = logical_name , FILENAME = 'Real file_path\os_file_name' )

 

3.Exit the sqlcmd utility or SQL Server Management Studio.
4.Stop the instance of SQL Server. For example, run NET STOP MSSQLSERVER.
5.Start the instance of SQL Server. For example, run NET START MSSQLSERVER.
6.Verify the file change by running the following query.

 
  1. SELECT name, physical_name AS CurrentLocation, state_desc
  2. FROM sys.master_files
  3. WHERE database_id = DB_ID(N'<database_name>');

 

 

View original
Did this answer your question?

4 replies

Forum|alt.badge.img+5
  • Author
  • Byte
  • 9 replies
  • September 22, 2022

attached log 


Jos Meijer
Commvault Certified Expert
Forum|alt.badge.img+17
  • Commvault Certified Expert
  • 638 replies
  • September 22, 2022

@Ayman Seyam can you check windows system event logs at the time stamp mentioned in the logs to see what error is being generated by starting the SQL service?


Forum|alt.badge.img+5
  • Author
  • Byte
  • 9 replies
  • September 22, 2022

Jos Meijer
Commvault Certified Expert
Forum|alt.badge.img+17
  • Commvault Certified Expert
  • 638 replies
  • Answer
  • September 22, 2022

Please take a look at this question at MS:

https://learn.microsoft.com/en-us/answers/questions/663579/sql-server-is-unable-to-start-in-a-timely-fashion.html

Seems that the SQL installer encountered an issue and did not change installer default modellog path to the path used by your server.

You can remove the SQL and CV install and try again to see if the problem persists, or try to fix it by following their suggestion. Never tested this my self though.. But seen multiple cases where this has fixed the issue as you are basically manually correcting the modellog path:

1.Start the instance of SQL Server in master-only recovery mode by entering one of the following commands at the command prompt. The parameters specified in these commands are case sensitive. The commands fail when the parameters are not specified as shown.

o For the default (MSSQLSERVER) instance, run the following command:

 
  1. NET START MSSQLSERVER /f /T3608

 

o For a named instance, run the following command:

 
  1. NET START MSSQL$instancename /f /T3608

 

2.For each file to be moved, use sqlcmd commands or SQL Server Management Studio to run the following statement.

 
  1. ALTER DATABASE database_name MODIFY FILE( NAME = logical_name , FILENAME = 'Real file_path\os_file_name' )

 

3.Exit the sqlcmd utility or SQL Server Management Studio.
4.Stop the instance of SQL Server. For example, run NET STOP MSSQLSERVER.
5.Start the instance of SQL Server. For example, run NET START MSSQLSERVER.
6.Verify the file change by running the following query.

 
  1. SELECT name, physical_name AS CurrentLocation, state_desc
  2. FROM sys.master_files
  3. WHERE database_id = DB_ID(N'<database_name>');

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings