Ssis login timeout expired 0*80004005 error
Hi ,
Recently my database file was corrupted and i had to reinstall the sql server.
I am now able to run the ssis packages through visual studio as i have a copy of old projects. But when i try to go in to c:documents and setting and to my project, when i run the file i get the following erroe
0*80004005 login timeout error.
Please help me.
regards
raghu
March 22nd, 2011 1:12pm
This error could be your Database is exclusively opened by another user or Database files may be corrupted.
Can you able to access your database from SQL Management studio?
please check here for more info
http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html
http://support.microsoft.com/kb/306269
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2011 1:19pm
Hi Mr.Ram,
Previously the data files were corrupted and i replaced them with backup files.
I am able to access the datbase from sql management studio.
When i try to run the ssis package from the location c:documents and settings and......package.dtsx i am getting the error.
When i run the same package through the visual studio it is succesful.
regards
raghu
March 22nd, 2011 1:24pm
Raghu,
Then it might be deployment error. could you please re-deploy your package to server.
Let us know your observation.
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2011 1:33pm
Hi,
I am well aware of the packages.
Can u assist me on hw to deploy the package as i havent done it earliar?
regards
raghu
March 22nd, 2011 1:54pm
Raghu,
here is steps to deploy package
http://shujaatsiddiqi.blogspot.com/2008/09/ssis-package-deployment-utility.html
Free Windows Admin Tool Kit Click here and download it now
March 24th, 2011 1:14am