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

Where are MSSQL Login Settings

Discussion in 'Plesk for Windows - 8.x and Older' started by knocx, May 5, 2005.

  1. knocx

    knocx Guest

    0
     
    Does anyone know where MSSQL remote server address / login setings are stored?

    i can not find them in PSA database... i have to add some manual entries

    thanks
    knocx
     
  2. Mr.Incredible

    Mr.Incredible Guest

    0
     
    MSSQL settings placed in table 'MISC' of Plesk database 'PSA', looks like mssql_bla_bla_bla.
    Good luck.
     
  3. knocx

    knocx Guest

    0
     
    :) why misc

    thanks this was the only table that i never looked in

    --knocx
     
  4. knocx

    knocx Guest

    0
     
    Well ..... misc table does not contain MSSQL login informations for databases created by the client. it only contains sa login /adress information....

    where are MSSQL logins for the clients?

    they are all lost after the restore! None of our clients MSSQL settings colud be restored, i want to enter the login data, manually but there are no tables present in the psa database containing client MSSQL database login information...


    plesk....plesk...plesk...


    knocx
     
  5. Mr.Incredible

    Mr.Incredible Guest

    0
     
    Hey!
    You can find databases users with passwords in 'db_users' table of plesk database 'psa', where db_id = id from table 'data_bases', in 'data_bases' dom_id = id from 'domains' table.
    Hope it will ll help you,
    good luck!
     
  6. knocx

    knocx Guest

    0
     
    yes i had successfully recovered it yesterday

    the interesting thing was that all mssql information was lost after the restore?

    knocx
     
Loading...