Re: Max Connections

Tech-Archive recommends: Speed Up your PC by fixing your registry

I don't believe Win2000 is limited to 10 connections since it is a server OS vs. the workstations ones like XP. AFAIK you can not change these limits. If you need more than 10 simultaneous connections you should be running a server OS and SQL Express is probably not the correct edition either.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"kishor" <kishor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:55CBB500-1C29-47BF-A2B1-4CEEF36031EE@xxxxxxxxxxxxxxxx
Hi,
If SQL Server 2005 Express is running on Windows XP Home, it is limited to
five simultaneous connections. If it is running on Windows 2000 or Windows XP
Professional, it is limited to 10 simultaneous connections. However, these
are limitations of the operating system and not of SQL Server 2005 Express

Where are the setting of this ? can we modify this ?

TIA,
Kishor

.

Relevant Pages

  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
    (microsoft.public.sqlserver.clients)
  • RE: My Documents Redirection error
    ... We can upgrade the instance SharePoint ... >> is no need to manually migrate data from MSDE to SQL server and all dada ... >> How to back up and restore http://companyweb data in Windows Small ...
    (microsoft.public.windows.server.sbs)
  • Re: VB app connect THROUGH proxy to a remote SQL database
    ... The whole "HTTP proxy is way more secure than allowing outgoing ... the client app and the SQL server are on ... incoming connections to the SQL server are not the problem - it's ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... If I cut the maximum number of connections to for ... SQL Server simply blocks any further try to open another table until I close ... This doesn't happen with the SQL Server 2000 but with SQL Server ... No, I think ms-sql-s means that SQL 2000 is using port 1433, which is ...
    (microsoft.public.sqlserver.connect)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)