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 |