Link to home
Start Free TrialLog in
Avatar of dba2dba
dba2dba

asked on

SSIS service not getting stsrted

I have installed integration services on 64 bit machine with sql 2005 64 bit sp2

even installed bi studio

the Sql sevrer integration services service not started and when tried to start it manually throws an error

service did not respond in timely fashion
looked at event log tells error 7000

any one have idea pls help
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Event ID 7000 might indicate that the logon information for the service account is invalid. See if this article seems to apply to the problem: http://support.microsoft.com/kb/314357
Avatar of Reza Rad
check if the user which ssis runned under that account has administrative rights on that machine?
Hopefully not, if you are talking about the service account. I don't think it needs or should have admin rights. I run it as the default "Network Service."

If you mean the user running the SSIS package, not the SSIS service itself, the yes, the user would need admin rights if specific rights had not been granted in MSDB. But the error here seems to be that the service itself is not starting.

If the SSIS service (called "SQL Server Integration Services xx.x") is not running as "Network Service" then you could switch it to that user and see if that fixes the problem. Once you have it working, you could try switching to another user if you really need to.

Always make SQL Server service account changes using SQL Server Configuration Manager.
Avatar of dba2dba
dba2dba

ASKER

I find the packages run successfully on 32 bit ssis but throw error on 64 bit

what settings need to be configured for 32 bit packages to be run on 64 bit machine

pls help
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dba2dba

ASKER

Thanks