Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 SQL Server 2005 Express multi-user access

Author  Topic 

clu82
Starting Member

4 Posts

Posted - 2009-11-19 : 10:46:04
This is my current scenario: I have a program that currently runs as a single-user application connecting to a 2005 Express database (both on the same machine).

This is what I am tasked to create:
I have 3 physically separate locations that need to connect to a SQL Server 2005 Express database (Windows Server name: Server2003, database name: myDB) in real-time. Basically just your ordinary every-day multi-user program.

While reading the book "Programming SQL Server 2005", I came across this section in the "SQL Server Express" section: "Databases running on a user instance are opened in single-user mode only, and multiple users cannot connect to databases running on a user instance."

This seems to contradict the testing I have already completed: I created a test program that allows record creation in my test database. I ran 2 instances of this program from the same computer, and was able to create records in the test database. I could then refresh the DataGridView of each program to show the newly created records of both program instances.

Is the book wrong or am I not reading something correctly?

During installation of 2005 Express, I selected the "Named instance" of "SQLExpres", which is the default name provided.

My other questions are:

1. Will my program be able to allow 15 users to connect to 2005 Express, all in real-time, accessing the same database, creating/updating records in that database?

2. Given the machine specs below, what would be a practical maximum user limitation? Users will mostly be viewing data, with the occasional record insert/update.

3. Does "Named instance" = "user instance"?

4. Assuming the database server is a Core2 Duo Dual-Processor with 4GB of memory and knowing the limitations of Express (1 proc, 1GB ram, 4GB database), are there any items I'm overlooking as I push forward with this project?

I am assuming that I will need to enable TCP to allow the remote clients to connect over TCP/IP, using a connection similar to this:
Data Source=10.94.40.33\\SQLExpress,13579;Network Library=DBMSSOCN;Initial Catalog=myDB;User ID=sa;Password=MySecurePassword_81

Thanks in advance for any and all comments,
clu
   

- Advertisement -