Max memory usage for SQL Server 2K on Windows 2K3

What is the max memory (RAM) SQL Server 2000 SP3 can use
when installed on a Windows 2K3 Enterprise Edition with 16
Gb of memory?
On the properties of the server it only displays 3,5 Gb!!
Thanks
CaioStandard edition can use 2GB. Enterprise Edition can use up to 64GB, depending on the limitations of
the OS. For SQL Server to use more than 2GB (or 3GB, depending on whether boot.ini has the /3GB
switch), then you need to PAE and AWE memory addressing.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Caio" <anonymous@.discussions.microsoft.com> wrote in message
news:030601c398ea$18301780$a601280a@.phx.gbl...
> What is the max memory (RAM) SQL Server 2000 SP3 can use
> when installed on a Windows 2K3 Enterprise Edition with 16
> Gb of memory?
> On the properties of the server it only displays 3,5 Gb!!
> Thanks
> Caio|||Hi Caio,
If you want to use large memory configurations with SQL(>3gb) you will need
to use /PAE in the boot.ini file, and enable AWE within SQL, then set a Max
Server Memory to the memory that you want to allocate to SQL, but there are
some things to note
1) You could also use /3GB to limit the kernel space to 1GB and give you an
extra 1GB, but this only works up to 16GB, your server is right on that
limit and running with these settings can cause problems as you aproach
this limit. So I would let the kernel have its 2GB
2) AWE is not dynamic so SQL will take that memory and it won't give it
back, if AWE is not used SQL will release memory as the OS comes under
pressure. So if you have other applications running on the server you may
want to set the max server memory a little lower.
3) If this server is clustered how many instances of SQL are running ?
Hope this helps
Regards
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am confused: why do I need the PAE switch on if Windows
2003 Enterprise Edition by default recognize 32GB of RAM?
Shouldn't SQL Server Enterprise Edition automatically
recognize all available memory?
Thanks
Caio
>--Original Message--
>Standard edition can use 2GB. Enterprise Edition can use
up to 64GB, depending on the limitations of
>the OS. For SQL Server to use more than 2GB (or 3GB,
depending on whether boot.ini has the /3GB
>switch), then you need to PAE and AWE memory addressing.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Caio" <anonymous@.discussions.microsoft.com> wrote in
message
>news:030601c398ea$18301780$a601280a@.phx.gbl...
>> What is the max memory (RAM) SQL Server 2000 SP3 can use
>> when installed on a Windows 2K3 Enterprise Edition with
16
>> Gb of memory?
>> On the properties of the server it only displays 3,5
Gb!!
>> Thanks
>> Caio
>
>.
>|||Hi Clive, thanks for the reply.
To answer your question: this server is not clustered so
we only have one instance of SQL Server.
Why do I need the PAE switch if Win 2003 Enterprise
Edition by default recognizes up to 32 GB of memory?
Shouldn't SQL SErver automatically see that the operating
system can provide more memory than the 2 or 3 GB?
Thanks again
Caio
>--Original Message--
>Hi Caio,
>If you want to use large memory configurations with SQL
(>3gb) you will need
>to use /PAE in the boot.ini file, and enable AWE within
SQL, then set a Max
>Server Memory to the memory that you want to allocate to
SQL, but there are
>some things to note
>1) You could also use /3GB to limit the kernel space to
1GB and give you an
>extra 1GB, but this only works up to 16GB, your server is
right on that
>limit and running with these settings can cause problems
as you aproach
>this limit. So I would let the kernel have its 2GB
>2) AWE is not dynamic so SQL will take that memory and it
won't give it
>back, if AWE is not used SQL will release memory as the
OS comes under
>pressure. So if you have other applications running on
the server you may
>want to set the max server memory a little lower.
>3) If this server is clustered how many instances of SQL
are running ?
>Hope this helps
>Regards
>Clive Challinor [MSFT]
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>|||See my other reply.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
<anonymous@.discussions.microsoft.com> wrote in message
news:0b3b01c3997c$7f1d58d0$a601280a@.phx.gbl...
> Hi Clive, thanks for the reply.
> To answer your question: this server is not clustered so
> we only have one instance of SQL Server.
> Why do I need the PAE switch if Win 2003 Enterprise
> Edition by default recognizes up to 32 GB of memory?
> Shouldn't SQL SErver automatically see that the operating
> system can provide more memory than the 2 or 3 GB?
> Thanks again
> Caio
> >--Original Message--
> >Hi Caio,
> >If you want to use large memory configurations with SQL
> (>3gb) you will need
> >to use /PAE in the boot.ini file, and enable AWE within
> SQL, then set a Max
> >Server Memory to the memory that you want to allocate to
> SQL, but there are
> >some things to note
> >
> >1) You could also use /3GB to limit the kernel space to
> 1GB and give you an
> >extra 1GB, but this only works up to 16GB, your server is
> right on that
> >limit and running with these settings can cause problems
> as you aproach
> >this limit. So I would let the kernel have its 2GB
> >
> >2) AWE is not dynamic so SQL will take that memory and it
> won't give it
> >back, if AWE is not used SQL will release memory as the
> OS comes under
> >pressure. So if you have other applications running on
> the server you may
> >want to set the max server memory a little lower.
> >
> >3) If this server is clustered how many instances of SQL
> are running ?
> >
> >Hope this helps
> >
> >Regards
> >Clive Challinor [MSFT]
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> >.
> >|||> I am confused: why do I need the PAE switch on if Windows
> 2003 Enterprise Edition by default recognize 32GB of RAM?
> Shouldn't SQL Server Enterprise Edition automatically
> recognize all available memory?
If you have 64 bit SQL Server, yes. Remember that "ordinary" SQL Server is a 32 bit app, and the
address space for a 32 bit app is 4GB. Of these 4GB either 2 or 3 GB are reserved for the system
(depends on the 3GB switch in boot.ini). So, to get to more then 2 or 3 GB, you need the windowing
technique that PAE gives you.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Caio" <anonymous@.discussions.microsoft.com> wrote in message
news:0be801c39978$694dd6a0$a401280a@.phx.gbl...
> I am confused: why do I need the PAE switch on if Windows
> 2003 Enterprise Edition by default recognize 32GB of RAM?
> Shouldn't SQL Server Enterprise Edition automatically
> recognize all available memory?
> Thanks
> Caio
> >--Original Message--
> >Standard edition can use 2GB. Enterprise Edition can use
> up to 64GB, depending on the limitations of
> >the OS. For SQL Server to use more than 2GB (or 3GB,
> depending on whether boot.ini has the /3GB
> >switch), then you need to PAE and AWE memory addressing.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Caio" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:030601c398ea$18301780$a601280a@.phx.gbl...
> >> What is the max memory (RAM) SQL Server 2000 SP3 can use
> >> when installed on a Windows 2K3 Enterprise Edition with
> 16
> >> Gb of memory?
> >>
> >> On the properties of the server it only displays 3,5
> Gb!!
> >>
> >> Thanks
> >>
> >> Caio
> >
> >
> >.
> >

Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri

Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!
32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:

>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>
|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:

> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...[vbcol=seagreen]
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
|||Thanks guys!
"Marks70" wrote:

> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!

Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri

Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!This is a multi-part message in MIME format.
--090006090404030906000503
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
--
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>
--090006090404030906000503
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>32GB on Win 2003 Enterprise<br>
64GB on Win 2003 Datacenter<br>
<br>
(I think.)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Marks70 wrote:
<blockquote cite="mid91F52420-72D3-4203-BE73-5C9A3AD9783A@.microsoft.com"
type="cite">
<pre wrap="">Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!
</pre>
</blockquote>
</body>
</html>
--090006090404030906000503--|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
>> Pretty simple question, what is the maximum amount of memory SQL 2000
>> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>> refering to the 32-bit versions). Thanks!|||Correction :) =>
The maximum amount of memory that can be supported on Windows Server 2003
is 4 GB. However, Windows Server 2003 Enterprise Edition supports 32 GB of
physical RAM.
Thanks,
Sree
"Sreejith G" wrote:
> The maximum amount of memory that can be supported on Windows Server 2003 is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
> > Pretty simple question, what is the maximum amount of memory SQL 2000
> > Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> > refering to the 32-bit versions). Thanks!|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!sql

Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri

Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:

>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:

> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...[vbcol=seagreen]
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
>|||Thanks guys!
"Marks70" wrote:

> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!

max memory for SSIS?

If we have a SQL Server 2005 standard edition/Windows 2003 Standard
Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the
maximum size of the memory we could possibly have?
Thank you,
ShivaAnswered in microsoft.public.sqlserver.integrationsvcs
*mike hodgson*
http://sqlnerd.blogspot.com
Shiva wrote:

>If we have a SQL Server 2005 standard edition/Windows 2003 Standard
>Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the
>maximum size of the memory we could possibly have?
>Thank you,
>Shiva
>
>
>

Max memory for SSIS

If we have a SQL Server 2005 standard edition/Windows 2003 Standard Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the maximum size of the memory we could possibly have?

Thank you,

Shiva

SQL 2005 standard doesn't have a maximum memory, you are constrained by your OS and hardware. I think it's around 4 gigs for 2003 standard 32bit.|||

yosonu wrote:

If we have a SQL Server 2005 standard edition/Windows 2003 Standard Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the maximum size of the memory we could possibly have?

Thank you,

Shiva

Is this a question about SSIS? If so, read this: http://blogs.conchango.com/jamiethomson/archive/2005/05/29/1486.aspx

If not, try a different forum.

-Jamie

|||

The 32bit Windows limit is 2GB per process. You can increase this to 3GB, using the boot.ini switch, /3GB.

A classic tip around this is to use several packages and Execute Process Tasks to combine them, but set the out of process option on, as this means each package then gets 2GB as each is it's own process. For small packages this may be detrimental though.

sql

max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AW
E
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM
.
http://www.microsoft.com/windowsser...es.msp
x
--
MG
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsser...es.msp
x
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/d...br />
8dbn.asp
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AWE
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM.
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

Max connections for SQl 2000 on Win XP Pro

Hi,
I'm a teacher in VB and use SQL 2000 on a laptop with Windows XP Pro.
My class has 20 students, can they connect to the sql database on my laptop?
Thanks inadvanced.
Danny
Greetings from BelgiumYes they can. I guess the students will be running very
small test queries against the sql server on your laptop.
>--Original Message--
>Hi,
>I'm a teacher in VB and use SQL 2000 on a laptop with
Windows XP Pro.
>My class has 20 students, can they connect to the sql
database on my laptop?
>Thanks inadvanced.
>Danny
>Greetings from Belgium
>
>.
>|||Why Not?
Scenario 1: If students want to work on SQL Server .
You all must be within the same network/domain.
Install SQL Server client in their PC and then configure
the client if needed. Usually SQLServer Client identifies
the other Servers in the same domain automatically. If the
server is in different domain, then you have to configure
the client(Use Named Piped Protocol/TCPIP).
Scenario 2: Just if the students want to connect and query
the SQL Server database from VB applications, then use
ODBC connectivity in your application.
Hope this helps. If not, please reply with your questions
in detail.
-SQLVarad (MCDBA-1999, MCSE-1999)
Greetings from USA
>--Original Message--
>Hi,
>I'm a teacher in VB and use SQL 2000 on a laptop with
Windows XP Pro.
>My class has 20 students, can they connect to the sql
database on my laptop?
>Thanks inadvanced.
>Danny
>Greetings from Belgium
>
>.
>|||<anonymous@.discussions.microsoft.com> schreef in bericht
news:02f901c398c2$79845960$a101280a@.phx.gbl...
> Yes they can. I guess the students will be running very
> small test queries against the sql server on your laptop.
>
Thanks for the quick answer.
Yes, its for learning ADO
What are the max connection for SQL server on XP Pro or Win 2000 Pro?
Is there a difference must I install Windows 2000 or Windows 2003 server on
the laptop for te connections to te SQL database?
Greetings
Danny
> >--Original Message--
> >Hi,
> >
> >I'm a teacher in VB and use SQL 2000 on a laptop with
> Windows XP Pro.
> >My class has 20 students, can they connect to the sql
> database on my laptop?
> >
> >Thanks inadvanced.
> >
> >Danny
> >Greetings from Belgium
> >
> >
> >.
> >|||"SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> Why Not?
> Scenario 1: If students want to work on SQL Server .
> You all must be within the same network/domain.
> Install SQL Server client in their PC and then configure
> the client if needed. Usually SQLServer Client identifies
> the other Servers in the same domain automatically. If the
> server is in different domain, then you have to configure
> the client(Use Named Piped Protocol/TCPIP).
> Scenario 2: Just if the students want to connect and query
> the SQL Server database from VB applications, then use
> ODBC connectivity in your application.
> Hope this helps. If not, please reply with your questions
> in detail.
> -SQLVarad (MCDBA-1999, MCSE-1999)
> Greetings from USA
>
All the students must connect to the same sql database on the laptop. The
students use ADO for the connection.
But my question was, can all the students (20) connect the same time on the
sql database.
Thanks for your answer
Greetings form Belgium
Danny
> >--Original Message--
> >Hi,
> >
> >I'm a teacher in VB and use SQL 2000 on a laptop with
> Windows XP Pro.
> >My class has 20 students, can they connect to the sql
> database on my laptop?
> >
> >Thanks inadvanced.
> >
> >Danny
> >Greetings from Belgium
> >
> >
> >.
> >|||The answer is yes...they may all connect at the same time...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Redder In Nood" <redderinnood@.hotmail-brolinpakjes.com> wrote in message
news:YAzlb.98327$FX6.4638829@.phobos.telenet-ops.be...
> "SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
> news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> > Why Not?
> >
> > Scenario 1: If students want to work on SQL Server .
> >
> > You all must be within the same network/domain.
> > Install SQL Server client in their PC and then configure
> > the client if needed. Usually SQLServer Client identifies
> > the other Servers in the same domain automatically. If the
> > server is in different domain, then you have to configure
> > the client(Use Named Piped Protocol/TCPIP).
> >
> > Scenario 2: Just if the students want to connect and query
> > the SQL Server database from VB applications, then use
> > ODBC connectivity in your application.
> >
> > Hope this helps. If not, please reply with your questions
> > in detail.
> >
> > -SQLVarad (MCDBA-1999, MCSE-1999)
> > Greetings from USA
> >
> All the students must connect to the same sql database on the laptop. The
> students use ADO for the connection.
> But my question was, can all the students (20) connect the same time on
the
> sql database.
> Thanks for your answer
> Greetings form Belgium
> Danny
> > >--Original Message--
> > >Hi,
> > >
> > >I'm a teacher in VB and use SQL 2000 on a laptop with
> > Windows XP Pro.
> > >My class has 20 students, can they connect to the sql
> > database on my laptop?
> > >
> > >Thanks inadvanced.
> > >
> > >Danny
> > >Greetings from Belgium
> > >
> > >
> > >.
> > >
>|||1. The actual number of user connections allowed also
depends on the version of SQL Server you are using and the
limits of your application(s) and hardware. SQL Server
allows a maximum of 32,767 user connections.
Because user connections is dynamic (self-configuring
option), SQL Server adjusts the maximum number of user
connections automatically as needed, up to the maximum
value allowable. For example, if only 10 users are logged
in, 10 user connection objects are allocated. In most
cases, you should not need to change the value for this
option. By default , it allows maximum users.
2. Sorry. Your questions is not clear to me. Can you
expalin in detail?
Thanks,
SQLVarad (MCDBA-1999,MCSE1999)
>--Original Message--
><anonymous@.discussions.microsoft.com> schreef in bericht
>news:02f901c398c2$79845960$a101280a@.phx.gbl...
>> Yes they can. I guess the students will be running very
>> small test queries against the sql server on your
laptop.
>Thanks for the quick answer.
>Yes, its for learning ADO
>What are the max connection for SQL server on XP Pro or
Win 2000 Pro?
>Is there a difference must I install Windows 2000 or
Windows 2003 server on
>the laptop for te connections to te SQL database?
>Greetings
>Danny
>
>> >--Original Message--
>> >Hi,
>> >
>> >I'm a teacher in VB and use SQL 2000 on a laptop with
>> Windows XP Pro.
>> >My class has 20 students, can they connect to the sql
>> database on my laptop?
>> >
>> >Thanks inadvanced.
>> >
>> >Danny
>> >Greetings from Belgium
>> >
>> >
>> >.
>> >
>
>.
>|||"Wayne Snyder" <wsnyder@.computeredservices.com> schreef in bericht
news:OgB%23MdMmDHA.2776@.tk2msftngp13.phx.gbl...
> The answer is yes...they may all connect at the same time...
>
Thanks for teh quich anwer.
Danny
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Redder In Nood" <redderinnood@.hotmail-brolinpakjes.com> wrote in message
> news:YAzlb.98327$FX6.4638829@.phobos.telenet-ops.be...
> >
> > "SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
> > news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> > > Why Not?
> > >
> > > Scenario 1: If students want to work on SQL Server .
> > >
> > > You all must be within the same network/domain.
> > > Install SQL Server client in their PC and then configure
> > > the client if needed. Usually SQLServer Client identifies
> > > the other Servers in the same domain automatically. If the
> > > server is in different domain, then you have to configure
> > > the client(Use Named Piped Protocol/TCPIP).
> > >
> > > Scenario 2: Just if the students want to connect and query
> > > the SQL Server database from VB applications, then use
> > > ODBC connectivity in your application.
> > >
> > > Hope this helps. If not, please reply with your questions
> > > in detail.
> > >
> > > -SQLVarad (MCDBA-1999, MCSE-1999)
> > > Greetings from USA
> > >
> > All the students must connect to the same sql database on the laptop.
The
> > students use ADO for the connection.
> > But my question was, can all the students (20) connect the same time on
> the
> > sql database.
> >
> > Thanks for your answer
> > Greetings form Belgium
> > Danny
> >
> > > >--Original Message--
> > > >Hi,
> > > >
> > > >I'm a teacher in VB and use SQL 2000 on a laptop with
> > > Windows XP Pro.
> > > >My class has 20 students, can they connect to the sql
> > > database on my laptop?
> > > >
> > > >Thanks inadvanced.
> > > >
> > > >Danny
> > > >Greetings from Belgium
> > > >
> > > >
> > > >.
> > > >
> >
> >
>|||Hi Wayne!
I thought that a non-server OS has connection limitations. I surely had then years ago when students
tried to run against my machine. However, this might be IPC sessions (redirector/workstation) and
only apply to Named Pipes, whereas TCP/IP Winsockets is fine...?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OgB%23MdMmDHA.2776@.tk2msftngp13.phx.gbl...
> The answer is yes...they may all connect at the same time...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Redder In Nood" <redderinnood@.hotmail-brolinpakjes.com> wrote in message
> news:YAzlb.98327$FX6.4638829@.phobos.telenet-ops.be...
> >
> > "SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
> > news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> > > Why Not?
> > >
> > > Scenario 1: If students want to work on SQL Server .
> > >
> > > You all must be within the same network/domain.
> > > Install SQL Server client in their PC and then configure
> > > the client if needed. Usually SQLServer Client identifies
> > > the other Servers in the same domain automatically. If the
> > > server is in different domain, then you have to configure
> > > the client(Use Named Piped Protocol/TCPIP).
> > >
> > > Scenario 2: Just if the students want to connect and query
> > > the SQL Server database from VB applications, then use
> > > ODBC connectivity in your application.
> > >
> > > Hope this helps. If not, please reply with your questions
> > > in detail.
> > >
> > > -SQLVarad (MCDBA-1999, MCSE-1999)
> > > Greetings from USA
> > >
> > All the students must connect to the same sql database on the laptop. The
> > students use ADO for the connection.
> > But my question was, can all the students (20) connect the same time on
> the
> > sql database.
> >
> > Thanks for your answer
> > Greetings form Belgium
> > Danny
> >
> > > >--Original Message--
> > > >Hi,
> > > >
> > > >I'm a teacher in VB and use SQL 2000 on a laptop with
> > > Windows XP Pro.
> > > >My class has 20 students, can they connect to the sql
> > > database on my laptop?
> > > >
> > > >Thanks inadvanced.
> > > >
> > > >Danny
> > > >Greetings from Belgium
> > > >
> > > >
> > > >.
> > > >
> >
> >
>