Database missing,won't connect

Posted on 2011-05-06
Last Modified: 2012-08-13
I have a client that has lost the connection to his database. When you pull up the odbc the only databases that it see are the master, model, msdb, and tempdb. I have a clear connection to the server but cannot get the database to show up in any connections.
When I route through programs /Micorosoft SQL Server/MSSQL?data it shows a bunch of mdf and ldf files but I can't connect to those either.

It is on a Windows XP machinne with SQL server installed.
Question by:BSAS_ITGuy
    LVL 76

    Expert Comment

    When you use SSMS/SSMSE with administrator/sa account do you see the database in any condition?
    If not someone else may have detached/deleted it.
    LVL 1

    Author Comment

    Sorry a little new to the acronyms what is ssme/ssmse . how can I reattached the database. Also when I go to the folder that has the mdf and ldf files they are set to open with microsoft access.
    LVL 76

    Accepted Solution

    SQL Server Management Studio (SSMS) E stands for the express free/limited version that one uses when they download the express version of the SQL server.

    This suggest that the SQL server had a linked Database which was to an Access MDB file?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
    Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now