connect to SQL Server Express remotly

Hi,

I'm planning to develop asoftware working over SQL Server Express Edition, And I was wondering how would different users connect to sql server xe remotly from their machines? and is there a limitation to the number of users who could connect at same time? Is there a client app to installed on their machines, or its just the main db on the server?

Note: all users should be connected using LAN

thanks in advance

hi,

SQLExpress grant you the ability to connect from remote clients as long as you enable network protocols..

remote clients will connect to the desired server as specified in the connection string, where you can pass the "SERVER=ServerInstanceName;" setting (see some connection string samples at http://www.connectionstrings.com/)..

there's no built in limit in the number of concurrent users but 32767, the overall limit of SQL Server... obviously this only is a theoretical limit, as each connection consumes resources on the server, and SQLExpress only allow you to address up to 1gb of ram and only 1 physical processor... depending on the actual database design, data load, access method, concurrency on data and the like, you'll get out of resources with very fewer users... it has been usualy sayd you can serve up to 25 concurrent users with MSDE, the predecessor of SQLExpress (which has a physical limitation, a "Governor Workload" that kicks in when 8 specified batches are running simultaneusly, slowing down all workloads)... SQLExpress does not present the same "scaling-down" technology, but this kind of magic number, based on detached database access (default with Ado.Net, but not with the older ADO data access model), with short queries and transactions can probably be still correct.. perhaps something more then this is eventually possible as well... anyway, remember to spare on resources :D

remote clients only need to install database connectivity binaries... MDAC if you use ADO/Ado.Net using the the OLE DB provider (which now is usually installed and upgraded by Windows Update as well), the SQL Native Client in current develop mode, as everyone is passing to this provider, which offers lots of new interesting features...

regards

|||

In Addition to the above post...

Have a look at the following article that will show you how to enable the remote connections to the Database Engine.