January 3, 2006 at 8:01 am
I got the following error below after changing sql server service account on a sql server running analysis services.
Executed as user: DOMAIN\SQLServiceAccount. ...un OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= DSO Error Description: Cannot connect to the Analysis server on computer 'SQL 2000'. Connection to the server is lost Error on Line 17 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= DSO Error Description: Cannot connect to the Analysis server on computer 'SQL 2000'. Connection to the server is lost Error on Line 17 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution comp. The step failed.
Any response regarding the above error much appreciated...
Cheers
A
January 3, 2006 at 8:20 am
Does the DOMAIN\SQLServerAccount have the same permissions as the previous account did within Analysis Services?
K. Brian Kelley
@kbriankelley
January 3, 2006 at 8:24 am
Yes it does and it also belongs to olap admin. group
January 3, 2006 at 8:29 am
one more thing i noticed is the 1st step of the job (loading) succeeds and the user that owns the dts package belongs to domain A but the 2nd step (Process) fails because it tries to connect to analysis server and the user that owns the dts package belongs to domain b.
January 4, 2006 at 10:50 am
I've not heard of any cross domain issues like that with AS. If you log on as the Domain\SQLServerAccount are you able to establish a connection to AS manually?
K. Brian Kelley
@kbriankelley
January 5, 2006 at 6:00 am
Yes I'm able to connect to AS with the SQL Service acct. apparently SQL Server has not been restarted since the account change and its now working since a reboot of the server was done. Thanks all
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply