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

sql-server sql-server-agent
surendra Kandira picture surendra Kandira · Jan 29, 2016 · Viewed 66.8k times · Source

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

Answer

surendra Kandira picture surendra Kandira · Mar 7, 2016

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

Related questions

Cannot bulk load because the file could not be opened. Operating System Error Code 3

I'm trying to set up a Stored Procedure as a SQL Server Agent Job and it's giving me the following error, Cannot bulk load because the file "P:\file.csv" could not be opened. Operating system error code 3(failed to …

Read More
How do I execute a stored procedure in a SQL Agent job?

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server Job and I want to execute a stored procedure regularly from a SQL Server Job. But I …

Read More
Could not obtain information about Windows NT group user

I am creating a SQL Server Replication using a script. When I try to execute The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about …

Read More