Questions tagged [mdf]

Master Database File (.MDF) is the starting point of a SQL Server database. It is the primary data file and also points to the other files in the database.

See the Wikipedia article on Microsoft SQL Server.

Related Tags:

429 questions
0
votes
0 answers

Can't access data in mdf database file on other computers

I'm developing an app in wpf and I created an .mdf database to store my data. The problem comes when I compress the release .exe with their .mdf database and try to execute it in another computer. It seems that the application can't access to the…
0
votes
0 answers

How to access a mdf file without Sql Server

I'm working on one Windows forms application using one .mdf file. And I have Sql Server 2008 installed in my machine , it is working fine in my machine. Now I need to install this application in Client's machine, Client's machine don't have Sql…
0
votes
2 answers

Cannot connect to MDF file using VS 2008 Server explorer

as mentioned in title. Another details: file is in on my hard drive in App_Data directory I have Microsoft SQL Server 2005 on my localhost installed (full, not Express edition) When I try to connect to file using Server explorer Microsoft SQL…
dragonfly
  • 17,407
  • 30
  • 110
  • 219
0
votes
1 answer

ASP.NET MVC 2 Membership users table mdf file

I have an MVC 2 project where I have my own *.mdf file in the App_Data directory. The *.mdf file contains my normal tables but not a users table. Is it possible to add a Users table to my *.mdf file and work with that instead of the simple register…
juFo
  • 17,849
  • 10
  • 105
  • 142
0
votes
1 answer

SQL Server Database Primary Data File got lost

SQL Server 2008 R2 stopped all of a sudden due to (maybe) Power Fluctuation. I tried all the possible ways to restart the it but every time it is failing with the error The request failed or the service did not respond in a timely fashion. Some of…
abbas
  • 238
  • 2
  • 18
0
votes
0 answers

Get content from mdf file / Import to Excel

I have a .mdf file (some GB) that contains data from an old application. However I need to work with some information that is stored in this database. Different to similar questions I have not developed this application, I do not have a SQL Server…
AUTxRemoteC
  • 23
  • 1
  • 2
  • 5
0
votes
0 answers

ASP.net auto complete works in local, but not working in live server

We have an ASP website that has the auto complete function for textbox. When we test on local, the function able to work. After we host the website on live server, we found that the auto complete function is not working anymore. We need to make that…
Mohamad Arafat
  • 573
  • 1
  • 5
  • 24
0
votes
2 answers

How to make a published app run on other computers using a LocalDB (.MDF)?

I'm having trouble making an application developed to run on other computers. This application uses a local database ( .mdf ) that is in the same project directory. When I publish the application and install on another computer , it installs…
Diego Lima
  • 27
  • 5
0
votes
1 answer

SQL Server Database not working due to server version issue on testing machine

My development PC has SQL Server 2008. I have a database which is created and running on SQL Server 2008. Instance name of SQL Server 2008 is SQLEXPRESS that is default one. My connection string is something like:
aru
  • 413
  • 4
  • 14
0
votes
1 answer

Cannot attach file as database in multiple projects

I have two projects which are targeting the same database. One of them is an MVC web application and the other is a Web API project. However, when I initialize an instance of the context in any of the projects I get the following exception: Cannot…
luisgepeto
  • 763
  • 1
  • 11
  • 36
0
votes
0 answers

Deleted .mdf file under App_Data in Visual Studio 2013. Now what?

I'm working on a small tutorial app using ASP.NET and MVC 5. I was finding that the database wasn't updating when I changed my seed data. Also, I put a breakpoint in the initializer class, and never hit it. I figured, well if I delete the database,…
abalter
  • 9,663
  • 17
  • 90
  • 145
0
votes
1 answer

.NET Can't connect to MDF on another machine

I have a simple Windows Forms project, which is linked to another project, a class library called "Model". This Model project uses LINQ-to-SQL to connect to a MDF database. When I test it locally, it works just fine, but when I try it on another…
gosukiwi
  • 1,569
  • 1
  • 27
  • 44
0
votes
1 answer

Entity Framwork Model First - After update login faild

I wrote a small application with entity Framework 6 model first Approach and SQL Server Express 2012 It worked well the last 6 month. Today, I deployed an update of the application with new Features, but no changes on the data layer. After…
cykone
  • 113
  • 8
0
votes
1 answer

Can I connect to LocalDB MDF file on computer from a web app that is being run on a web server?

In development, i.e., when using Visual Studio and its built-in IIS Express instance, I have set up my web app to use LocalDB, with the data MDF file located in a directory on my computer but not inside the project directory, e.g.,…
Gerry
  • 628
  • 6
  • 16
0
votes
1 answer

Cant backup sql database with c#

I tried this code samples SqlCommand cmd = new SqlCommand(); SqlConnection con2 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\schoolmate.mdf;Integrated Security=True;User Instance=True"); string sql = "BACKUP…