SP3 and Trusted Connection

• Bunmi

  SSC Enthusiast

  Points: 184

  More actions

  November 5, 2001 at 11:13 am

  #157524

  I've just applied SP3 to our SQL Server 7 on NT 4 (SP5), during the process I selected NT Authentication. Since then none of my DTS packages that has "Executes the cn.Open command" is able to run. I get the error msg

  "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.". I have since changed the authentication mode to mixed with no luck.

  Any help would be appreciated.

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  November 5, 2001 at 12:44 pm

  #419671

  Don't use sa in DTS!!!!!

  You might need to re'save your DTS packages. I see them sometimes flip out with changes like this.

  Steve Jones

  steve@dkranch.net