Hello

I am running the mdse version of SQL for our main business
application. we are a small business with 15 users, and because of
cost and expertise we have always remained on a workgroup. We run the
SQL server on a windows 7 PC. We have had no major issue with this in
3 years.

I am now getting connection limits on that PC being met, so users do
not have access to the database/application.

I have been trialling the SBS 2011 essentials O/S, where the
connection limit is met, but fundamentally I am concerned that this
adds a great deal of complexity to my simple workgroup, by enforcing a
domain architecture, and for the first time a single point of failure
that is expensive to mitigate.

So, getting to the point, does anyone know of a reasonably priced O/S
that will allow for 20 to 30 user connections, that won't enforce a
major over haul of my network?

Paddy (padmullaney (AT) gmail (DOT) com) writes:
Are the messages on connection limit from Windows or from SQL Server?

If the messages are from Windows, and you need a different operating
system, I guess you could use a Windows 2008 Server, and still use a
workgroup. But this is not really the right newsgroup for Windows
questions.

If the message is from SQL Server, I would recommend that you upgrade
your application to SQL 2008 Express Editions. Since you say MSDE,
I assume that you have SQL 2000, and I seem to recall that there
were some sort of a connection limitation there, albeit not a hard
one.

Express Edition is free, but does not have the same throttle as SQL
2000. There is a limit on the database size, which is 10 GB in
SQL 2008 R2.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Paddy (padmullaney (AT) gmail (DOT) com) writes:
Are the messages on connection limit from Windows or from SQL Server?

If the messages are from Windows, and you need a different operating
system, I guess you could use a Windows 2008 Server, and still use a
workgroup. But this is not really the right newsgroup for Windows
questions.

If the message is from SQL Server, I would recommend that you upgrade
your application to SQL 2008 Express Editions. Since you say MSDE,
I assume that you have SQL 2000, and I seem to recall that there
were some sort of a connection limitation there, albeit not a hard
one.

Express Edition is free, but does not have the same throttle as SQL
2000. There is a limit on the database size, which is 10 GB in
SQL 2008 R2.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

It is a windows message, but I thought asking the question here might
be appropriate as other SQL users may have had to resolve the problem.
Also I have tried some windows user groups, but have no luck.

It is 2000, but there is an upgrade to 2008 express being rolled out
at the moment, though I do not think that makes too much difference,
as it is a windows message.

Thanks for the reply, if anyone else has had to get round this problem
I would appreciate your thoughts.

It is a windows message, but I thought asking the question here might
be appropriate as other SQL users may have had to resolve the problem.
Also I have tried some windows user groups, but have no luck.

It is 2000, but there is an upgrade to 2008 express being rolled out
at the moment, though I do not think that makes too much difference,
as it is a windows message.

Thanks for the reply, if anyone else has had to get round this problem
I would appreciate your thoughts.

On Sep 16, 7:45*am, Paddy <padmulla... (AT) gmail (DOT) com> wrote: