Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2012-01-16 : 12:30:00
|
| Analysis Services was working on both DWAS1 and DWAS2 instances. I had to restart the machine and now none of them are working. I get the following:A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running (Microsoft.AnalysisServices.AdomdClient)No Connection could be made because the target machine actively refused it xxx.xx.xx.xx:xxxx (System)The SQL Browser is using local Network account. Changed that to use a Domain account and restarted the service but still no luck. Cannot connect to neither of the AS instances. But the error message has changed:A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)No Connection could be made because the target machine actively refused it xxx.xx.xx.xx:xxxx (System)Could you advice what should I do?Canada DBA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-16 : 12:31:20
|
| is ANalysis services service running? check it first in services.msc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2012-01-16 : 12:44:40
|
Yes, Both instances service are running. :(quote:
Originally posted by visakh16
is ANalysis services service running? check it first in services.msc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2012-01-26 : 13:10:55
|
| For the record, I had to uninstall Analysis Services and reinstall to resolve the issue.Canada DBA |
|
|
|
|
|
|
Cannot connect to Analysis Services