Avatar of lapucca
lapucca
 asked on

How to open this database in Sql express?

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
Microsoft SQL Server

Avatar of undefined
Last Comment
lapucca

8/22/2022 - Mon
lapucca

ASKER
Attached is the error message that says I have no access.
sqlErr.txt
ASKER CERTIFIED SOLUTION
Peter Chan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
lapucca

ASKER
Perfect!  That worked!  Thank you.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy