Tuesday, October 29, 2013

SQL Server Configuration Manager - Connection to target machine could not be made in a timely fashion

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