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


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.

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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. <br />
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.<br />
<br />
It is on a Windows XP machinne with SQL server installed.
</div>
</div>


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.

Database missing,won't connect

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).