how many connection sqlexpress supports

I see this question a lot, so I thought I would go ahead and post the answer here.

Q: How many connections does SQL Server Express support?

A: Unlike MSDE, SQL Server Express does not limit connections. SQL Server Express supports:

1 gb RAM (note the machine can have more memory, but 1gb will be used by SQL Express) 1 processor (again, the machine can have more, but just 1 proc will be used by SQL Express) 4 gb database size (note, there can be multiple databases, but none of them individually can be more than 4 gb)

Hope this helps,

Thanks< MJ

Is it right that only 5 database users can connect to SQL Server express 2005 engine at the same time?

How find WHICH HW requirement that is not met?

Dear All,

I get a warning from the SQLExpress 2005 installation that a hardware requirement is not met. The error printout gives absolutely NO info about which requirement that is not met.

So far I have manually scrutinized the HW req's and compared with my machine and found no errors.

Is there a test program somewhere that can tell exactly which requirement that is not met?

How can this error message have passed system test? I reminds me of a Zilog compiler/linker ca 1980 that bailed out with the highly informative error printout: "link error" and nothing more. That was 25+ years ago...

/:o( wabo

This warning message may indicate that your box (for example, memory size) doesn't meet recomendations but not requirements (so system test was successfully passed).

WBR, Evergray
--
Words mean nothing...

|||

Thanks!

But I'd still prefer a more elaborate message, like "Your memory is to low".

Just issuing the message "Warning" is of no help and requires me to do lots of debugging without knowing what I'm looking for...

Best / Bo W