0

Is it possible to connect to an .mdf file (SQL Server) directly like we connect to msaccess db files, without a server installed? I want to do it for my web site because the webhost might not like me having more then 1 database.

Thanks.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Itay.B
  • 3,991
  • 14
  • 61
  • 96
  • SQL Server is a **server** (as the name already implies) - so **no**, you cannot use a .mdf file with having a **server** component available somewhere. You can always install and use the **free** SQL Server Express - even for commercial purposes. – marc_s Feb 08 '11 at 21:31

1 Answers1

1

There is no such a possibility as far as I know.. Maybe you should try with SQL Server Compact edition.

rsc
  • 4,234
  • 2
  • 30
  • 28
  • 1
    Yes, Compact would work - but it cannot handle .mdf files (it uses .sdf files which are incompatible) – marc_s Feb 08 '11 at 21:30
  • You're right. I didn't mean to use SQL Compact for accessing mdf files, but rather to use it instead of standard SQL Server. – rsc Feb 08 '11 at 21:43