sql-serversql-server-agent

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

Solution

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

    1. Configuration => Protocols for SQLEXPRESS => TCP/IP

    2. Then right click and go to property

      enter image description here

    3. After that show screen and go to Ip Address

      enter image description here

    4. After that show screen and go to IPALL

      enter image description here

    5. After that set the TCP Ip: 1433

      enter image description here

    6. And click on Apply and OK

      enter image description here