News, links, downloads, tips and tricks on Microsoft Access and related
Does MSDE/SQL Express has a 5 concurrent user limit? Euan Garden clarifies this.
No Apparently you can have up to 16 concurrent instances
i'm seeing a limit of five. using either ASP or sqlcmd, same behavior... and if i run sql management studio, i can get only THREE other users logged in.
in sqlexpress 2005... sorry i didn't specify.
So what do you get if sixth user tried to connect? What in event log?
No Apparently you can have up to 16 concurrent instances
ReplyDeletei'm seeing a limit of five. using either ASP or sqlcmd, same behavior... and if i run sql management studio, i can get only THREE other users logged in.
ReplyDeletein sqlexpress 2005... sorry i didn't specify.
ReplyDeleteSo what do you get if sixth user tried to connect? What in event log?
ReplyDelete