Licensing SQL Server 6.5

Licensing SQL Server 6.5

Post by Michael Cutte » Sat, 23 Jan 1999 04:00:00

Hi all -

We have a project to do involving SQL Server 6.5 The shiny new box of
software arrived on my desk, so off I go to install it.

We have two servers installed at our ISP, each of which can see the other in
the Network Neighbourhood.
One is the webserver, the other the SQL Server. So I install SQL Server,
then use the Licensing applet of Control Panel to tell it about the 5 client
access licences that came in the SQL Server box. It seemed happy enough, so
I cranked up Enterprise Manager, registered the server OK, and went home.

When I get back to my development machine, I wrote a load of Active Server
Pages to connect to the server, and display the data from it. Standard stuff
using ADODB.Connection and so on.
Unfortunately the page only ever returns the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- The maximum
simultaneous user count of 1 licenses for this server has been exceeded.
Additional licenses should be obtained and registered via the Licensing
application in the NT Control Panel.

/trading/commissions/login.asp, line 18

I'm not sure I understand this. We obviously have no idea how many people
will access this page at once, so am I right in thinking that we need to buy
the Internet Connector? Also, as the machine running the Active Server Page
is connecting to the SQL Server across the LAN running at the ISP, do I only
need one CAL? If not, is 5 enough?

Sorry for all the questions, I think I might be suffering slightly from
Friday afternoon syndrome!

Thanks very much for any help,


Licensing SQL Server 6.5

Post by Neil Pik » Sat, 23 Jan 1999 04:00:00


 Yes you need to buy an internet connector license.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 and GO MSSQL Lib 1 on Compuserve


Licensing SQL Server 6.5

Post by Neil Pik » Sun, 31 Jan 1999 04:00:00

Nope - it's just a bit of paper

Quote:> The real funny thing is that we purchased the Internet Connector when it
> first came out and all we got was a lousy piece of paper...a license
> indicating that it was a ok for multiple tcp/ip clients to connect to our
> SQL?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 and GO MSSQL Lib 1 on Compuserve

1. Upgrading from 120-day demo to licensed SQL Server 6.5 CD-ROM

I have purchased the licensed version of SQL Server 6.5. I want to upgrade
my 120-day demo, which I got from Microsoft's site, to this licensed
version. On their web site, it says that if one decides to purchase SQL
Server, one may simply upgrade to the licensed version. I've tried to do
that with the CD-ROM that I got, and it does not work. If I try to use the
I386\setup.exe program and then choose "Upgrade" it tells me I need to use
the SQL Server Service Pack 3. When I tried that, it told me that the
version I had installed could not be upgraded.

I've looked on Microsoft's site for the answer to this problem, but have not
been able to find it. And of course getting technical support is pretty much
out of the question since they won't give out any phone numbers except for
the ones that cost $100 per call or something like that. You'd think they'd
help out with a simple problem like this since I actually paid for the

I don't want to totally remove the demo, because I want to keep my database
and settings intact. And according to their web site, I should be able to
simply upgrade. Anyone know how???

Joe Moorman

Note: Remove .spamless from e-mail address to send
personal/non-commercial e-mail.

2. International Business Managers,Phoenix,Arizona,comp.databases

3. SQL Server 2000 license overriding SQL Server 7.0 license on separate server

4. DB_BLOCK_SIZE: Possible Misinformation

5. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

6. a question for setup experts please

7. SQL Server 6.5 client license upgrade

8. Connecting to SQLAnywhere 7.03

9. SQL Server 6.5 License and interdev application

10. SQL Server 6.5 out of License (ghost?)

11. SQL Server 6.5 Licensing

12. Web Use of SQL Server 6.5 and the Internet Connector License