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

SQL 2005 problems with 7.5.5 update

Discussion in 'Plesk for Windows - 8.x and Older' started by Redah, Nov 18, 2005.

  1. Redah

    Redah Guest

    0
     
    We recently migrated to Microsoft SQL Server 2005, and were glad to see that it worked like a charm in Plesk 7.5.4.

    Plesk recognised it as SQL Server 9.0, and when entering the sa password in the 'Server' > 'Databases' page, a connection was made.

    We then upgraded to Plesk 7.5.5 this night, and we found out that Plesk fails to connect to SQL Server 2005 with the following error:

    "Unable to update database parameters: Try to establish connection failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

    The password has definately not changed, how can this be?
     
  2. smach

    smach Guest

    0
     
    try to set connection in Plesk CP

    follow: CP->Server->Databases-> Microsoft SQL Server tab.
    Enter following information:
    1. Host
    2. Login (sa)
    3.Password
     
  3. kanchadales

    kanchadales Guest

    0
     
    Help me

    Hi,
    I am with this same problem,
    But I am not finding where to arrange that,
    Please, does anybody can me to help?
     
  4. Redah

    Redah Guest

    0
     
    The only way to fix this is to uninstall SQL Server 2005, and then re-install it. Ofcourse I had already entered the sa login and password, if I hadn't, it wouldn't have worked under 7.5.4 either :)

    After re-installing, Plesk will work fine with it. Somehow it messes something up with the dll files SQL Server uses... only way to get them back is to re-install SQL Server 2005.
     
Loading...