SQL Server service is not stopping

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Server service is not stopping

SQL Server service is not stopping

Rate Topic

Display Mode

Topic Options

Author

Message

Knowledge Hunter

Posted Tuesday, January 08, 2013 12:18 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 08, 2013 6:52 AM
Points: 82, Visits: 344

There was a bottleneck in a server.
In order to avoid that I have changed some configuration changes in the Server for Memory setting, Processor settings (Unchecked Automatically set processor affinity, Automatically set IO affinity) and connection settings.

When the services were restarted it went to a hung state.
The service is not starting or stopping.
The instance cannot be accessed.

The state in SQL Server Configuration Manager is "Change pending..."
Can you please help?

Thanks in advance.

Post #1403994

Vegard Hagen

Posted Tuesday, January 08, 2013 1:50 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:41 PM
Points: 494, Visits: 325

Try reading the errorlog - still accessible either by opening the errorlog file directly (it's a plain text file) or via the "Applications" tab in the windows event log. More often than not, this will provide useful information about what's going on.

Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1404051

Knowledge Hunter

Posted Tuesday, January 08, 2013 2:14 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 08, 2013 6:52 AM
Points: 82, Visits: 344

I have restrarted the server and the services has started now.
I connected to the instance.
But when I am trying to open Properties of the instance I am getting the following error:

Failed to retrieve data for this request
Failed to connect to server
A connection was successfully established with the server,
but then an error occured during login process.
(Provider: Shared Memory Provider error: 0-No process is on the other end of the pipe)

I have confirmed that all the protocols are enabled.

Post #1404062

Knowledge Hunter

Posted Tuesday, January 08, 2013 2:51 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 08, 2013 6:52 AM
Points: 82, Visits: 344

I stopped the browser serice and connected to the server.
Then I started the browser service.

It worked for me.

Thanks for your help

Post #1404079

« Prev Topic | Next Topic »

Permissions