<p>I was wondering if anyone knew of any limitations to using Windows XP as a File and SQL server. I am asking because one of the applications we sell, requires the customer to setup a server for filesharing and as a SQL Server. We already allow them to use SQL Express, but we wanted to see if we can suggest Windows XP as a low cost alternative to Windows Server. The only potential problem that I could see if there were limits on the number of concurrent connections to either the files or the database. We are only thinking of recommending this for smaller sized companies who would have 10-15 users.</p>

[{'answer_id': 52641, 'author': 'Rob Walker', 'author_id': 3631, 'author_profile': 'https://Stackoverflow.com/users/3631', 'pm_score': 4, 'selected': True, 'text': '<p>There is a <a href="http://support.microsoft.com/default.aspx?kbid=314882" rel="nofollow noreferrer">limit of 10 inbound connections</a> on XP professional, and 5 on XP Home. So it would only be practicable for a very small company.</p>\n'}, {'answer_id': 52647, 'author': 'Gulzar Nazim', 'author_id': 4337, 'author_profile': 'https://Stackoverflow.com/users/4337', 'pm_score': 0, 'selected': False, 'text': '<p>One cost effective alternative is <a href="http://en.wikipedia.org/wiki/Small_Business_Server" rel="nofollow noreferrer">Windows Small Business Server</a>.\n<a href="http://www.microsoft.com/windowsserver2003/sbs/evaluation/features/default.mspx" rel="nofollow noreferrer">SBS 2003 R2: Features at a Glance</a></p>\n'}, {'answer_id': 52648, 'author': 'Jared', 'author_id': 1980, 'author_profile': 'https://Stackoverflow.com/users/1980', 'pm_score': 2, 'selected': False, 'text': '<p>From this MS KB Article:</p>\n\n<blockquote>\n  <p>Note For Windows XP Professional, the\n  maximum number of other computers that\n  are permitted to simultaneously\n  connect over the network is ten. This\n  limit includes all transports and\n  resource sharing protocols combined.\n  For Windows XP Home Edition, the\n  maximum number of other computers that\n  are permitted to simultaneously\n  connect over the network is five. This\n  limit is the number of simultaneous\n  sessions from other computers the\n  system is permitted to host. This\n  limit does not apply to the use of\n  administrative tools that attach from\n  a remote computer.</p>\n  \n  <p>Per development: The connection limit\n  refers to the number of\n  redirector-based connections and is\n  enforced for any file, print, named\n  pipe, or mail slot session. The TCP\n  connection limit is not enforced, but\n  it may be bound by legal agreement to\n  not permit more than 10 clients.</p>\n</blockquote>\n\n<p>I suggest reading <a href="http://support.microsoft.com/kb/314882" rel="nofollow noreferrer">the kb article</a> for more information.</p>\n'}, {'answer_id': 52650, 'author': 'Simon Johnson', 'author_id': 854, 'author_profile': 'https://Stackoverflow.com/users/854', 'pm_score': 0, 'selected': False, 'text': '<p>This will break the EULA. </p>\n\n<p>Here is the relevant knowledge base <a href="http://support.microsoft.com/default.aspx?kbid=314882" rel="nofollow noreferrer">article</a>. Note that while TCP connection limits are <em>not</em> enforced for XP, legally they are limited to 10 connections.</p>\n\n<p>Small business server seems like a better fit, and is cost effective if you shop around.</p>\n'}, {'answer_id': 151633, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': "<p>The problem with Small Business Server is all the frill it comes with that is unnecessary for a simple file and sql server; like exchange server, sharepoint, etc. I've used Windows XP as a small business SQL/File server, but as others have pointed out, you are limited to 10 connections legally speaking.</p>\n"}, {'answer_id': 186852, 'author': 'nicodemus13', 'author_id': 26463, 'author_profile': 'https://Stackoverflow.com/users/26463', 'pm_score': -1, 'selected': False, 'text': "<p>Presumably you are meaning SQL Express, as you can't run SQL Server on XP, it's a server product.</p>\n\n<p>If the customer can afford your product, they can afford a copy of Server 2003, or whatever, the file sharing's built-in.  Admittedly SQL Server's fairly expensive, but if your product needs it, that's the way it goes.  If cost were an issue, you shouldn't be using SQL Server as the database platform.  There's no point in trying to force a server-based solution into a client OS.  You'll end up with all sorts of problems before long.  </p>\n\n<p>Doesn't the client have a domain-based infrastructure already?</p>\n\n<p>The upshot being being if the client has 5-10 users of the software, they should be on SBS anyway for a variety of other reasons.  You don't get SQL Server with it though.</p>\n\n<p>(Samba would be an option for file-sharing, but doubtless more expensive than simply buying Server 2003 in this instance).</p>\n"}, {'answer_id': 332682, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 1, 'selected': False, 'text': '<p>Actually, you can run SQL Server Standard or Workgroup Edition on Windows XP Pro. It is not limited to the express version ... </p>\n'}, {'answer_id': 459946, 'author': 'K. Brian Kelley', 'author_id': 29084, 'author_profile': 'https://Stackoverflow.com/users/29084', 'pm_score': 0, 'selected': False, 'text': "<p>Another issue with Small Business Server is it can't be installed on an existing domain. Your best bet would be to package the SQL Server portion around a normal Windows server installation. If you're looking at 10-15 users, there's no guarantee that they have a domain. But if they don't, likely they are already dealing with the file server problem using accounts with same usernames/passwords on the file server(s) as on their individual workstations.</p>\n"}, {'answer_id': 20070780, 'author': 'Mrutyunjayya', 'author_id': 3008645, 'author_profile': 'https://Stackoverflow.com/users/3008645', 'pm_score': -1, 'selected': False, 'text': '<p>The number of connections is not related to SQL Server edition, but to the operating system. For example, Windows XP allows only 10 concurrent connections, Windows 7 20. For Windows Server OS [no need to purchase any new server machine ], the number of connections is unlimited (but you can limit is using Terminal Services).\nThe error message shown in case of connection limit reached is something like "the security limit reached...the number of concurrent connect attempts"</p>\n'}]
['https://Stackoverflow.com/questions/52621', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4779/']