Multiple SQL Server Express Instances

• adzymcfadzy

  Right there with Babe

  Points: 794

  More actions

  January 13, 2009 at 4:13 pm

  #203962

  Hi all,

  We want to use SQL Server Express as a subscriber to our main database for clients to use as a lookup rather than hitting our main database server.

  However i believe there is a 5 concurrent connections limit on SQL Server Express.

  If we installed multiple Sql Server Express Instances onto one computer, and then having subscriptions to each instance, and as long as we point the clients to different instances, would this work?

  Our ideal is to actually purchase a full license of SQL, however due to budgetry constraints this is not possible this year.

  Could i have some feedback on whether this is a viable solution?

• FFalcon1961

  SSC-Addicted

  Points: 491

  More actions

  January 15, 2009 at 8:21 am

  #927367

  As long as you are not hitting the database with a lot of hits. I have had as many as 20 users connected to our SQLX databases.