+ Reply to Thread
Results 1 to 6 of 6

Thread: Remotly access Sql Express mdf database

  1. #1
    Shemeer is offline VB.NET Forum Newbie Shemeer is on a distinguished programming path ahead
    .NET Framework
    .NET 3.5 (VS 2008)
    Join Date
    Apr 2009
    Posts
    17
    Reputation
    19

    Question Remotly access Sql Express mdf database

    Help me to connect Sql Express 2005 mdf file to connect remotely.

  2. #2
    jmcilhinney's Avatar
    jmcilhinney is offline VB.NET Forum Moderator jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute
    .NET Framework
    .NET 3.5 (VS 2008)
    Join Date
    Aug 2004
    Location
    Sydney, Australia
    Age
    41
    Posts
    6,907
    Reputation
    670

    Default

    Please do us the courtesy of posting in the most appropriate forum for the topic and not just the first one you come to. Thread moved.

    There are two ways to connect to a SQL Server Express database:

    1. You can deploy the MDF file with your application and then attach it to SQL Server on demand. This would only be done for single user apps with a local server.

    2. You build a new database or attach an existing database permanently to the server using SQL Server Management Studio Express. This database can then be accessed by any user and any application on the network, assuming that the instance has been setup to support remote connections.

    If you can specify which of those scenarios matches your situation then we can provide more information if required. That said, as far as the application is concerned it doesn't really matter. The only thing that is different from the application's point of view is the connection string. You can find all the connections strings you might need at ConnectionStrings.com - Forgot that connection string? Get it here!.

  3. #3
    Shemeer is offline VB.NET Forum Newbie Shemeer is on a distinguished programming path ahead
    .NET Framework
    .NET 3.5 (VS 2008)
    Join Date
    Apr 2009
    Posts
    17
    Reputation
    19

    Smile Sql Express Remote access

    Hi,

    Am using only Sql Express 2005. i want to create a server client like atmosphere with mdf file.

    mdf file will be in the server system and no mdf files in client systems.
    the clients and server should work from the mdf file.

    that is one database for all systems.

    is it possible ?

    i will be glad to hear from u ........

    Thanks in advance.

  4. #4
    jmcilhinney's Avatar
    jmcilhinney is offline VB.NET Forum Moderator jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute
    .NET Framework
    .NET 3.5 (VS 2008)
    Join Date
    Aug 2004
    Location
    Sydney, Australia
    Age
    41
    Posts
    6,907
    Reputation
    670

    Default

    SQL Server Express can handle multi-user networked apps no problem, although the databases can only be 4GB and it won't handle the same load as the full SQL Server. What you want to do is no different than it would be with the full SQL Server. You need to install SQL Server Express on your server and make sure you enable remote connections. You use Management Studio Express to create the database and then your application simply needs to specify the appropriate connection string, the format for which you can find using the link in my last post.

  5. #5
    t_jcruise is offline VB.NET Forum Newbie t_jcruise is on a distinguished programming path ahead
    .NET Framework
    .NET 3.0
    Join Date
    Jul 2010
    Posts
    5
    Reputation
    0

    Default

    Is there any installation procedure on how to install the Server and Client of SQL Server 2005 Express? Because i'm having proble in accessing the Server Remotely?

    I've already checked the server if it has Remote access, Also configured the Surface Area Configuration.

    what do i need to have a server / client database? help please....

  6. #6
    cjard's Avatar
    cjard is offline VB.NET Forum All-Mighty cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute cjard has a reputation beyond repute
    .NET Framework
    .NET 2.0 (VS 2005)
    Join Date
    Apr 2006
    Age
    66
    Posts
    6,752
    Reputation
    937

    Default

    Ensure the SQL browser service is started

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Bookmarks

Posting Permissions

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