Mar 5, 2017 7:30:24 PM by Pinal Dave
Today’s blog is originated from a blog interaction. After hardening a server, my friend was not able to start SQL Browser service. When we try to start from services, we get below standard error, which is not very helpful. Let us fix the error related to SQL Configuration.
The SQL Server Browser service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.
Then we looked into Event Logs and found below messages in application event log.
The SQL Server Browser is closing. There are no instances of SQL Server or SQL Server Analysis Services.
The SQL configuration for SQL is inaccessible or invalid.
Initially we thought that our SQL configuration is corrupted so we thought that we need to uninstall SQL Server. But NO, it was something else.
We started SQLBrowser from command line and found error there also. Later, we found below registry key which is needed to start the SQL Browser.
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftMicrosoft SQL ServerSQL Browser
In our case, due to hardening, the key was deleted, so we created key and added two values under that.
They keys are AnalysisServiceListener and SsrpListener and value should be 1.
Have you ever seen issues due to server level hardening by Windows team?
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Tags: SQL Server
Written by Pinal Dave
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 1700 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect who specializes in SQL Server Performance Tuning and has 7+ years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.