• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 953
  • Last Modified:

Connection failed: Too many connections to the database

I'm running a windows 2000 server with 5 CAL and the sybase adaptive server anywhere 6.0

during setup, I chose the per network seat license. but when i try to connect to the database, it only allows one user at a time.

I have another PC running windows NT and the sybase adaptive server anywhere 6.0 but this setup allows the database to be used by several users at the same time.

If possible, I prefer to use the windows 2000 as the my server to run my database.

Can someone please explain/tell me what should i do.
0
Sandy Kalugdan
Asked:
Sandy Kalugdan
1 Solution
 
DaniProCommented:
You can try to use "dblic" command-line utility that allow you to change the number of user license but i think than on Win 2000 O.S. this ASA 6.0 utilities non work.
Otherwise you can reinstall the server!

dblic { switches } executable-name user-name company-name
-l type = License type. Allowed values are perseat or concurrent
-o filename = Log output messages to a file
-p operating-system = Target operating system. Allowed values are NetWare, UNIX, WIN32, WINNT
-q = Operate quietly—do not print messages
-u license-number = Total number of users for license
 
Examples:
dblic -l concurrent -p WINNT -u 50 dbsrv6.exe "Sys Admin" "My Con"
0
 
gletiecqCommented:
It makes a difference whether you're starting the database with the dbsrv or dbeng commands.  dbeng is limited to five connections, regardless of licence limits.  dbsrv uses the licensing information to determine the number of allowed connections.  The OS used is irrelevant to this issue.

If you are actually exceeding the number of licenses you've bought, you might as well get the number you actually need.  Extra licenses are incredibly cheap.

Greg
0
 
AchetonCommented:
DaniPro is right this one is almost certainly because you need to run dblic
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now