How to attach my sql mdf database to a sever

Posted on 2012-09-19
Last Modified: 2012-09-21
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
Question by:JCWEBHOST
    LVL 26

    Accepted Solution

    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.

    Author Comment

    iis 7 is installed

    Author Comment

    do you have screen shots?
    LVL 3

    Expert Comment

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
    Learn about cloud computing and its benefits for small business owners.
    This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
    This tutorial will show how to inventory, catalog, and restore media from legacy versions of Backup Exec into both 2012 and 2014 versions of the software. Select Storage from the tabs along the ribbon bar as the top: Ensure the proper storage devi…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now