troubleshooting Question

How to open this database in Sql express?

Avatar of lapucca
lapucca asked on
Microsoft SQL Server
3 Comments1 Solution170 ViewsLast Modified:
Hi,
I'm given a sql mdf file and its log file.  I tried to right clicking on the "Database" in Sql Management Studio, selecting attach and selected to add the mdf file from my Drive.  The database and log file shows up in the lower window.  But when I click okay it gives me error.  Attached is a screen shot.  How can I fix this?

Looks like I was denied access to open this database.  Do I get user id or password from person who owns the database to open it?  How is that done?  I usually just restore database backup file.  This is the first time attaching to one.  I didn't know I need to be given access but the sql express is running on my local pc.  the database is on my local drive.  I'm not sure how to setup access for this.

I'm using sql express 2012
ASKER CERTIFIED SOLUTION
Peter Chan
System consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros