Scheduled DTS Package.

• kwbonin

  SSC Enthusiast

  Points: 109

  More actions

  June 11, 2003 at 2:23 pm

  #59676

  Hello All,

  I have a DTS package on a SQL 7 box. I can create the package and run it manually but when I try to schedule the package I get a message that Tells me:

  "Microsoft SQL-DMO (ODBC SQLState 42000)

  (Microsoft)(ODBC SQL Server Driver)(SQL Server)Login failed for user '(null)'. reason: Not associated with a trusted SQL Server connection."

  Can anyone tell me how I can fix this? I know that "(ODBC SQLState 42000)" tells me that Its either a syntax error or an access violation. But beyond this, I am drawing a blank. I am pretty sure its a security issue, but I can't figure out how to fix it.

  Any help would be apprciated!

  Thanks,

  Keith

• tonymend

  Old Hand

  Points: 319

  More actions

  June 11, 2003 at 2:38 pm

  #460882

  change authentication to mixed(sql and windows)

• kwbonin

  SSC Enthusiast

  Points: 109

  More actions

  June 11, 2003 at 2:51 pm

  #460884

  Tony,

  Thanks for the reply, but the server is already set to mixed mode.

• tonymend

  Old Hand

  Points: 319

  More actions

  June 11, 2003 at 3:04 pm

  #460889

  check this link out:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q169/3/77.asp&NoWebContent=1