1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

upgrade to sitebuilder 3.1 problem

Discussion in 'Plesk for Windows - 8.x and Older' started by c001web, Oct 9, 2006.

  1. c001web

    c001web Guest

    I've already upgraded plesk 7.5.6 for windows to plesk 7.6.1, no much pain. the problem appears when i start to upgrade to sitebuilder 3.1 from 2.0.x.

    when i install it from add/remove plesk entry, i got error message "1:Cannot connect to the server. Please check your connection settings and verify that SQL server is in the correct state"

    and from event viewer "2:Error 1720. There is a problem with this Windows installer package. A script required for this installation to complete could not be run. Custom action CheckDB script error,
    MS OLE DB provider for sql server:login failed for user 'sa' line 931, column 2"

    My MS SQL 2000 server is running fine.

    So, what the reason is here?
    platform: windows 2003 server

    any hint or help, very appreciated!!;)
  2. c001web

    c001web Guest

    hi, it looks really wired, doesn't it?
    i did some study about this problem for couple of hours, i guess it is 'sa' password problem, ms sql 'sa' password was random set when psa was intalled, the i changed it from outside (sql manager), cause i got no ms sql server integrated with psa, so i can not change it from psa console, the problem manybe here, when psa doing sitebuilder upgrade, it will use that random given 'sa' password (i forgot it already) to connect database, so it just can not login!

    but how can i change this situation? let psa reset its saved password?

    any comments are welcomed!