InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 04:34:47 GMT20http://www.sqlservercentral.com/Forums/Topic1403994-1550-1.aspxI stopped the browser serice and connected to the server.Then I started the browser service.It worked for me.Thanks for your helpTue, 08 Jan 2013 02:51:11 GMTKnowledge Hunterhttp://www.sqlservercentral.com/Forums/Topic1403994-1550-1.aspxI 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:[i]Failed to retrieve data for this requestFailed 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]I have confirmed that all the protocols are enabled.Tue, 08 Jan 2013 02:14:08 GMTKnowledge Hunterhttp://www.sqlservercentral.com/Forums/Topic1403994-1550-1.aspxTry 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.Tue, 08 Jan 2013 01:50:49 GMTVegard Hagenhttp://www.sqlservercentral.com/Forums/Topic1403994-1550-1.aspxThere 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.Tue, 08 Jan 2013 00:18:17 GMTKnowledge Hunter