January 18, 2010 at 9:49 am
I'm trying to fix an issue connecting to an Analysis-Services 2008 instance from SSMS.
The error I am getting is as follows:
Cannot connect to <server\instance>.
Additional information:
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 127.0.0.1:2382 (System)
In http://msdn.microsoft.com/en-us/library/cc917670.aspx it is stated that:
Note You should not run the SQL Server Browser service under the Local Service or Network Services accounts.
My SQL Browser service is running under Local Service.
When I attempt to switch it to Local System, I get the following error:
WMI Provider Error: The group name could not be found.
Anyone know what the problem might be?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 18, 2010 at 10:21 pm
Hopefully it's not a problem with Windows.
Two things: can you change another services ( like SSIS) to Local System?
If that works, can you reboot and see if something is just acting flaky?
January 19, 2010 at 4:01 am
Steve Jones - Editor (1/18/2010)
Hopefully it's not a problem with Windows.Two things: can you change another services ( like SSIS) to Local System?
If that works, can you reboot and see if something is just acting flaky?
I was trying to do it using SQL Config Manager (per MS best practice).
Doing it through Windows Services instead - services.msc - worked.
So there is something flaky about my SQL Configuration Manager (sql 2008 sp1).
While on the subject, I wonder why SQL Browser service needs to be running under an admin account for connectivity to the SSAS instance to work. I always thought Local Service account was enough for the SQL Browser....
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply