Menu
I am trying to make an application, which uses a local .mdf database file (not attached to a sql server). Visual Studio says I have to install SQL Server Express before doing that. I was wondering how I can deploy the application to clients' box. Do they also need SQL Server Express installed?
Thanks a lot
454
Right-click your MDF file and select “Open with.” Select Daemon tools from the options and the image will mount as a DVD. Windows Explorer will pick it up and you will be able to run or explore the disk just as you would if it were a real DVD.
Run SQL Server management studio as an administrator and attach the database. Explicitly grant full control access to the MDF file and LDF file of the database. To do that, Right-click the database files Select the security tab select the appropriate user and grant full control to the user.
They need SQL Server Express installed. Once installed, you need to attach the database file (.mdf) to the server.
130
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
