Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

2143

April 18th, 2018 09:00

Access is denied

Hello experts.

Are there members who use Microsoft SQL Server? There's a .mdf extension file that I could open in Dell Inspiron i7559-2512BLK on Windows 8.1. However, after the Windows 10 update, I suddenly can't open it anymore. It gives the following message, Access is denied.

I googled for this, i get many solutions for all other databases except .mdf file issue. Can someone help me?

TY for you time and attention

1 Message

April 23rd, 2018 04:00

You’d need to install some version of SQL Server, then re-attach the MDF file. However, if you don’t have the matching LDF file (the log file), you don’t have the whole database. Because of this, an MDF file is not the correct way to transfer databases between servers. Instead, you need to make a backup using SQL Server Manager, then restore the backup on the other server. If you need more information take a look here: how to open mdf file?

Moderator

 • 

17.6K Posts

April 19th, 2018 10:00

mmarten,

You will need to contact Microsoft for more information. Without the program installed I know of no other way to open the SQL File.

No Events found!

Top