[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

Database missing,won't connect

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.
0
BSAS_ITGuy
Asked:
BSAS_ITGuy
  • 2
1 Solution
 
arnoldCommented:
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.
0
 
BSAS_ITGuyAuthor Commented:
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.
0
 
arnoldCommented:
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?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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