Yesterday I had to stop the SQL Server Analysis Services (POWERPIVOT) service on SQL Server Configuration Manager (the idea was to restart the service). After this, I was getting the below error when I tried to open the SQL Server Configuration Manager.
---------------------------
SQL Server Configuration Manager
---------------------------
Connection to target machine could not be made in a timely fashion.
---------------------------
OK
---------------------------
I waited for 30 minutes and the error was not going off. After 30 minutes, the status showed Stopped (Pending Changes) in SQL Server Configuration Manager. But when I opened Service page (services.msc) ,the same service SQL Server Analysis Services (POWERPIVOT) was still in Stopping state
Resolution
I restarted the server and things changed back to normal
No comments:
Post a Comment