Re: Max Connections
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Mon, 27 Aug 2007 11:11:32 -0400
They are small because of the fact that the OS is not optimized for that type of work and it they allowed more connections you wouldn't have to pay more for the server version:).
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"kishor" <kishor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8797B844-03B5-4E3B-8C31-7B1FD92FDF7A@xxxxxxxxxxxxxxxx
Yes thats true; SQL Express is not a right version and XP is also not a
Server operating system. but how come these limits are very small ?
Regards,
kishor
"Andrew J. Kelly" wrote:
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
.
- References:
- Re: Max Connections
- From: Andrew J. Kelly
- Re: Max Connections
- Prev by Date: Re: Max Connections
- Next by Date: Re: Max Connections
- Previous by thread: Re: Max Connections
- Index(es):
Relevant Pages
|
