SQL7.0 SP1 - script 1 failing to run

• barrettjc

  SSC Rookie

  Points: 43

  More actions

  August 15, 2001 at 6:48 am

  #63789

  Upgrade running as username sa and password but script won't run.

  It can be run manually from query analyser as the same user and password.

  Re-running causes the upgrade to auto-detect the steps we've already been through so deosn't give us a chance to re-try with a different user name.

  Any ideas why running the script would fail to connect even though the username and password are okay? Or is there a way of stoppping the upgrade auto-detecting the username on retry?

  Help please!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738327

  More actions

  August 15, 2001 at 9:33 am

  #417649

  I had a similar problem. I rebooted the server, then stopped the SQL services and was able to get the script to run.

  Steve Jones

  steve@dkranch.net