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
LVL 8
dba2dbaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Megan BrooksSQL Server ConsultantCommented:
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
0
Reza RadConsultant, TrainerCommented:
check if the user which ssis runned under that account has administrative rights on that machine?
0
Megan BrooksSQL Server ConsultantCommented:
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.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

dba2dbaAuthor Commented:
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
0
Megan BrooksSQL Server ConsultantCommented:
The packages themselves are XML files. I wouldn't expect the platform to matter unless the package attempts to run something that is platform-dependent. I run everyting on x64 now and the only incompatibility that I have encountered so far is that the Excel Source component won't run on x64 because there is no version of the component for it. I haven't had to make any SSIS-related settings changes to run on x64.
If I read your original question correctly, the SSIS service is not even starting, so the settings to look at are those for SSIS startup. With that in mind, what account is the SQL Server Integration Services service configured to start as? Is it "Network Service?" If not, was the alternate account specified during the install or was it changed using SQL Server Configuration Manager?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dba2dbaAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.