Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically

I have created one sample of node js . But when I start the application is going to connection of sql server then not give response by sql server.

When i going in service panel and start sql server agent then give blow error....

This service on local computer started and then stopped. some service stop automatically if then are not in use by other service or programs enter image description here

OR.........

When i am going in the sql server config and start of sql server agent then show error

The request failed or the service did not respond in a timely fashion. Consult the event log log or other application error for details. enter image description here

like image 212
surendra Kandira Avatar asked Jan 29 '16 08:01

surendra Kandira


People also ask

What does the service on local computer started and then stopped mean?

“The Service on local computer started and then stopped ,Some services stop automatically if there are not in use by other services or programs.” Now I will explain how to solve the Service on local computer started and then stopped, some services stop automatically if there are not in use by other services or programs.

Why does my MySQL service stop automatically?

Some services stop automatically if they are not in use by other services or programs. The solution varies depending on your version of MySQL. Attempt the solutions in the order of the following sections. Restart the MySQL service by running the following command:

How to stop SQL Server Agent from running automatically?

The SQL Server Agent (VILLBE_SQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs. Last, I right click SQL Server Agent, choose Properties, set Start up type is Automatic and reboot my PC. When reboot is done, SQL Server Agent still is stopped

Why do some services stop automatically?

Some services stop automatically if they have no work to do This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. Thank you for posting your query on Microsoft Community.


2 Answers

I had found the solution to this problem. I have added the TCP Port 1433 in SQL set the TCP Port=1433

Configuration => Protocols for SQLEXPRESS => TCP/IP Then right click and go to property enter image description here

After that show screen and go to Ip Address enter image description here

After that show screen and go to IPALL enter image description here

After that set the TCP Ip: 1433 enter image description here

And click on apply and ok enter image description here

like image 184
surendra Kandira Avatar answered Sep 18 '22 22:09

surendra Kandira


Worked for me after changing the appropriate user and credential for the instance.

enter image description here

like image 30
MAFAIZ Avatar answered Sep 20 '22 22:09

MAFAIZ