Results 1 to 5 of 5

Thread: Connecting to Sql Server without Sql Server instance running

  1. #1
    Join Date
    Nov 2004
    Location
    us
    Posts
    14

    Connecting to Sql Server without Sql Server instance running

    Hi, I would like to know if an application that I wrote on my local computer can connect to an Sql Server database (.MDF) remotely by loading Sql Driver from my local computer so I don't need Sql Server instance running neither locally nor remotely

    I hope my question is clear

    Thanks in advance for your reply

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can't do, need sql engine to make db online.

  3. #3
    Join Date
    Nov 2004
    Location
    us
    Posts
    14
    Quote Originally Posted by rmiao View Post
    Can't do, need sql engine to make db online.
    This is Intranet setting. What I am trying to do is put the MDF file on a disk in a Network Attached Storage (NAS) so evryone on the intranet can access the database from their Desktop or Laptop. So the question is what do I need in the User computers to access the MDF stored in the NAS

    Thanks

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can't open MDF file from a user computer. Only SQL Server engine can open this file. You can put the file in NAS as long as SQL Server service account can read it, the clients will use SQL Query tool or driver to connect to the SQL Server engine and read data.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Sql server works different from Access completely.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •