How to open the. mdf file when there is no SQL Server database _mssql

If you are trying to open a. MDF database file, what do you do when you find that you don't have a SQL Server database installed? At this point, if you happen to have visual Studio 2005 or a higher version on your machine, you can open the. mdf database file without installing the SQL Server database. This article we mainly introduced the implementation of this method, and then we began to introduce.

Workaround:

When you open Visual Studio 2005, clicking tools → connecting to a database in your project will cause you to change the data source and choose

Point is determined, the following window appears:

Browse to your MDF database file:

Point Open

Then point the connection test, if it appears

So good, your database is ready to open; OK, OK, OK, look at your vs. the left window is not there?

The plus sign in front of the point data connection:

Note: This method is implemented if visual Studio 2005 or more versions are already installed.

About not having a SQL Server database installed also opens the. mdf database file method is introduced here, I hope this introduction can bring you some harvest it, thank you!