Unable to change account under which SQL Server 2008 Browser service is running from Local Service to Local System

  • 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]

  • 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?

  • 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