by 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,
Michael