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
> > > >
> > > >
> > > >.
> > > >
> >
> >
>

mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
--
David Portas
SQL Server MVP
--|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
>> Whenever I back up my laptop, I get a series of messages that the files
>> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
>> folder such as mastlog.ldf are being used by another application. The
>> backup stalls until I manually tell it to skip these files.
>> Is there any way to identify what application is using these files?
>> I am running WIndows XP.
>> Thanks,
>> Dani
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>

mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani
<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegro ups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
David Portas
SQL Server MVP
|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegro ups.com...
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>

mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
David Portas
SQL Server MVP
--|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegroups.com...
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>