You must Sign In to post a response.
  • Category: SQL Server

    Microsoft Sql Server R2 Remote Connection

    Hi,

    I had a dotnet desktop application with database is sql server r2 express edition.I want to connect my system through LAN,in order to running my application through Client System.I need what all the requirements needed for sql server R2 express edition connecting through server computer to Client.
  • #767956
    If you use a SQL Server database to persist your data in your application you need

    1. client-server infrastructure where your client connect to a central SQL Server via LAN

    2. or use a client installed sql server edition (which is what you want I guess). For this you can use SQL Server Express edition or just a MSDE (Desktop Edition).


    http://searchsqlserver.techtarget.com/tip/SQL-Server-2005-Express-vs-Desktop-Engine-MSDE


    Since 2012 there is no more MSDE, but SQL Server 2012 Express brings a mode like MSDE did.

    http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

    Thanks,
    Mani

  • #768002
    Hey Marleedharan,

    I sent you one link about this config to your server as soon like you prefered.

    http://akawn.com/blog/2012/01/configuring-sql-server-2008-r2-express-edition-for-remote-access/


    Hope It helps,

    Thanks,
    Vaibhav shah


Sign In to post your comments