You can easily attach local MDF database data file within Microsoft SQL Server Management Studio. But after you installed the SQL Server successfully and run the SQL Server Management Studio at first time to do attach your local MDF data file, you would experience the following issue.
It happened because you start the SQL Server Management Studio with your normal account, which usually don't have administration privilege.
Just simply open the SQL Server Management Studio under Administration, and you can attach the file without any problem.
No comments:
Post a Comment