Home » Blog » Topic » How to view an MDF file for archive purposes?

How to view an MDF file for archive purposes?

Stephen West ~ Modified: August 12th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to view an MDF file for archive purposes?

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • August 12, 2015 at 12:33 pm #457 Score: 0
    Stephen West
    Moderator
    4 pts

    Hi,

    I have an MDF file I really would like to be able to view. It has a lot of legacy office data on it that would just be handy to access.

    I have tried to install SQL Server 2008 r2 on a 32bit window 10 computer but I do not seem to be able to connect to ./SQLEXPRESS

    Could someone please advise me of the best way to try and view the data?

    August 13, 2015 at 12:19 pm #464 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    First things first. Let’s get you connected. When you installed SQL Server, did you name the instance <your computer name>\SQLExpress ? I would try and choose Windows Authentication as your authentication and then simply place a period (.) in the servername and hit connect.

    If that does not work, go to Control Panel/Administrative Tools/Services and make sure the SQL Server Service is running.

    September 3, 2015 at 12:30 pm #560 Score: 0
    Stephen West
    Moderator
    4 pts

    That’s right the SQL Server is not shown as a running service.

    Now how do I overcome this?

    September 4, 2015 at 7:46 am #561 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    If you see a service but it is stopped, start it by right hitting start,

    If you do not see a SQL Server service, it is likely you did not install the Server Tools during the install. In this case you need to reinstall with the server tools.  

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.