by IT » Tue, 24 Jun 2003 23:01:02
I'm running SBS 4.5 (SQL 7 is integrated with SBS) with 25 licenses, as far
as I know, this should allowed me at least 25 machines connection at any
time to the SBS.
The question regarding SQL server 7,
We have a dozen of applications running agaisnt this database, would the 25
connections be exceeded if some of the machines using more than 1
application at the time. (Using ODBC, each application has 1 connection)
Thanks very much for your help
Tam
by Tibor Karasz » Tue, 24 Jun 2003 23:58:36
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> I'm running SBS 4.5 (SQL 7 is integrated with SBS) with 25 licenses, as far
> as I know, this should allowed me at least 25 machines connection at any
> time to the SBS.
> The question regarding SQL server 7,
> We have a dozen of applications running agaisnt this database, would the 25
> connections be exceeded if some of the machines using more than 1
> application at the time. (Using ODBC, each application has 1 connection)
> Thanks very much for your help
> Tam
1. SQL Server 2000 license overriding SQL Server 7.0 license on separate server
We have the following situation.
Server A is a W2K server (not domain controller) with SQL Server 7.0
installed. This SQL server has an Internet connector license.
Server B is a W2K domain controller with SQL Server 2000 Standard
Edition installed.
Server B has a web app that accesses SQL server on Server A. This web
app does not use the database on Server B.
Web clients accessing Server B have their SQL accesses rejected with the
message "Logon failed. The number of users on this 'Standard Edition'
exceeds the maximum of 10 allowed by the license."
Why does the license on B trump the license on A? How do I fix it?
Q153140 appears to be irrelevant. License Manager doesn't show anything
for the SQL Server 2000 installation.
2. Can we have subdatasheets in a datagrid control ???
3. SQL server license and server connections
4. VB 5.0/DAO 3.5 - recordset doesn't display in runtime version.
5. SQL server license problem with connections
7. seat license or connection license
8. parent-child dimension problem
9. Licensing problems with sql server and sql server desktop
10. SQL Server connection vs Analysis Server connection
11. licenses vs. user connections in SQL 7
12. SQL 2000 - Replication amd Licensed connections
13. SQLServer 2000 license overriding SQLServer 7.0 license on separate server