Category: SQL Server

26 Sep 2016 04:01

Joined:	07/10/2008
Level:	Silver
Points:	160

Points:	3

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

26 Sep 2016 05:03

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	4

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

02 Oct 2016 18:41

Joined:	17/09/2016
Level:	Bronze
Points:	38

Points:	1

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

Microsoft Sql Server R2 Remote Connection

About dotnetspider.com

Quick Links

General

Services