RE: Run a ssis package on SQL Server 2005 Error

#**151**

Hi Peter,

Thank you for your reply.
Actually we fixed the issue. I think the issue is damin/user related.
We have to retype the damin/user password to restart the SQL Server. The
issue was fixed after the server/agent started.

It seems like if you changed damin/user password which runs SQL/Agent, and
restart SQL server, it will start succesfully, but you have to type the new
password to start agent. If you are here, then you may face the issue which I
posted.

If you restart the server, it will force you to retype password. after you
give the correct password, the server will start, and the issue was fixed.

To be honest, I don't understand either, but it does fix the issue I have.
Please do a test on your own and let us know the result if you are interested.

Thanks
Kevin

""Peter Yang[MSFT]"" wrote:

Quote:

Hello,

Based on the symptom, since the issue only occurs on this specific server,
I suggest that you try the following:

1. Temporarily change SQL agent service and SQL Server service start
account to a different user account with local admin rights to test.

2. Double check if the issue is package related by using your package on
different sql server/msdb.

If you have any update, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

#**152**

Hi Peter,

Thank you for your reply.
Actually we fixed the issue. I think the issue is damin/user related.
We have to retype the damin/user password to restart the SQL Server. The
issue was fixed after the server/agent started.

It seems like if you changed damin/user password which runs SQL/Agent, and
restart SQL server, it will start succesfully, but you have to type the new
password to start agent. If you are here, then you may face the issue which I
posted.

If you restart the server, it will force you to retype password. after you
give the correct password, the server will start, and the issue was fixed.

To be honest, I don't understand either, but it does fix the issue I have.
Please do a test on your own and let us know the result if you are interested.

Thanks
Kevin

""Peter Yang[MSFT]"" wrote:

Quote:

Hello,

Based on the symptom, since the issue only occurs on this specific server,
I suggest that you try the following:

1. Temporarily change SQL agent service and SQL Server service start
account to a different user account with local admin rights to test.

2. Double check if the issue is package related by using your package on
different sql server/msdb.

If you have any update, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Run a ssis package on SQL Server 2005 Error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

RE: Run a ssis package on SQL Server 2005 Error - 04-21-2008 , 03:51 PM

RE: Run a ssis package on SQL Server 2005 Error - 04-21-2008 , 03:51 PM