dbTalk Databases Forums  

Run As Local System or Domain User

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Run As Local System or Domain User in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mick Anderson
 
Posts: n/a

Default Run As Local System or Domain User - 12-11-2006 , 01:19 AM






Hi,

I needed to change the Services of SQL Server 2005 to run as a specific
domain user rather then local system (Organisation Standard for SQL Server).
After changing to the new user I could connect to SQL Server without any
problems but had problems connecting Analysis Services

The error:

TITLE: Connect to Server
------------------------------

Cannot connect to DSS64\DSS_ALT.

------------------------------
ADDITIONAL INFORMATION:

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
(System)

------------------------------
BUTTONS:

OK
------------------------------


I tracked this down to the Analysis Services Instance and the SQL Browser
services. I found that while these 2 services were still run as local system
everything seems to work still.

If I want to run everything as my domain user, can anyone suggest how to get
this working?

Thanks
Mick


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.