8

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

surendra Kandira
  • 587
  • 2
  • 5
  • 22
  • 1
    Read. The log. SQL Server writes a lotfile, you know. It will tell you why it shuts down. – TomTom Jan 29 '16 at 08:53
  • This question may be better suited for http://serverfault.com/ – Paul Hunt Jan 29 '16 at 08:59
  • This [link](https://support.microsoft.com/en-us/help/955494/error-message-when-you-use-sql-server-configuration-manager-to-restart) from Microsoft recognizes the issue and has a workaround. – nam Sep 29 '20 at 03:51

4 Answers4

11

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

Himanshu
  • 31,810
  • 31
  • 111
  • 133
surendra Kandira
  • 587
  • 2
  • 5
  • 22
  • 4
    "I had found solution of this problem" - only if we define the problem as "I cannot get Node to connect to SQL Server" which was only mentioned in passing as the first sentence of your question. It's not a solution to the "problem" that the rest of your question related to. – Damien_The_Unbeliever Mar 07 '16 at 08:22
  • 1
    awesome. this worked for me after hours of troubleshooting. upvoted. – George Jun 04 '17 at 13:30
  • 2
    also restart SQL Server service before trying to start SQL Server Agent. – Jurgen Cuschieri Jun 13 '19 at 09:20
3

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

enter image description here

MAFAIZ
  • 681
  • 6
  • 13
2

SQL Server is running, as shown in your screen shots:

SQL Server is running

If Node is failing to connect to it, it's probably a flaw in your connection string.

What isn't running is SQL Server Agent. Which is a system for running scheduled tasks in SQL Server. It is bizarrely installed but not runnable when the SQL Server instance you're dealing with is SQL Server Express. Which, again, your screenshots confirm is the case here.

Damien_The_Unbeliever
  • 234,701
  • 27
  • 340
  • 448
0

In my case just needs to disable VIA protocol.

Go to Sql Server Configuration Manager-> Protocols for MSSQLSERVER then right click on VIA and select disable.

Alert me if that's it!

Alireza Abdollahnejad
  • 921
  • 8
  • 9