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
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
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
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.
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.
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
what settings need to be configured for 32 bit packages to be run on 64 bit machine
pls help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks