Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

How to attach my sql mdf database to a sever

hey guys i have this sever and have remote access to and i need to store my database and get the connection string?

please hep

here is a screen shot when i remote in, it looks like iis6 is install but sql is not please help

screen shot
  • 2
1 Solution
Leon FesterIT Project Change ManagerCommented:
Check the services to see if you have the following services installed and running:
SQL Server
SQL Server Agent
SQL Serer Browser

This will confirm if SQL is installed on the server.
To attach your database you'll need to use SQL Management studio.
In order to do that, you'd need sysadmin or similar level permissions on the SQL server, as you essentially need to add a new database.

You don't mention anything about the .ldf file so check out the following instructions:

Check the installed Features to confirm if IIS is installed.
If not you will need to add the feature.
JCWEBHOSTAuthor Commented:
iis 7 is installed
JCWEBHOSTAuthor Commented:
do you have screen shots?
first, what version you want to install? you may check the services running by clicking Start > Run, then type services.msc. You must see SQL services or something that contains SQL in its name. You may also check services running in task manager.

dvt_localboy is correct. .ldf file is required.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now