Connecting to MSSQL Database

[riprod]

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

 

[Gris@]

you should attach that database to your MSSQL server

 

[Traged1]

How do you attach the database? Do you use SQL manager?

 

[Gris@]

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.