Pls make sure that you have set authentication to 'Windows and SQL authentication' under the properties.

This might be the case!

Hi,

U can have multiple 'steps' for one Job.

(In SQL Server Agent, there is a tab named 'steps' where u can add multiple steps each consisting of a different query)

When u...