1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Connecting to MSSQL Database

Discussion in 'Plesk for Windows - 8.x and Older' started by riprod, Sep 23, 2005.

  1. riprod

    riprod Guest

    Sorry, I poseted this in the wrong place, here goes again...

    I'm on a dedicated server with plesk and have setup my domain. I can create a new MSSQL database and users from Pleask but how do I connect to an exisiting MSSQL database. I have copied the .MDF file into the Databases\MSDE\MSSQL\DATA folder but it does not show up in enterprise manager.

    I have even tried creating a database with the same name and then going to the server and overwriting it with my database. That doesn't work.

    Please help. Thanks
  2. Gris@

    Gris@ Guest

    you should attach that database to your MSSQL server:)
  3. Traged1

    Traged1 Guest

    How do you attach the database? Do you use SQL manager?
  4. Gris@

    Gris@ Guest

    You can use MSSQL Enterprise Manager or you can use stored procedure sp_attach_db for it.
    But to connect it to Plesk at first you should create it via it then drop directly via Enterprise Manager or osql and then attach the original one.