How many user licenses required for SQL Server BE

  • Thread starter kscheu via AccessMonster.com
  • Start date
K

kscheu via AccessMonster.com

I have an Access front end application that links to Access Back end tables
located on a server. The Front End application is used by approx. 50 users,
some internal and some thru Term Server. I am planning to convert the
Backend access database to SQL server, but I am confused as to the number of
user licenses I would need to purchase. If I create pass through queries and
use one login id to SQL server for the Front end to use to access the SQL
Server BE tables, will I need a user license for all 50 users or just one for
the FE application?

What about if I link the BE SQL Server tables to the FE? Will I need 50
licenses or just one?

Thanks,
Karen
 
P

Pat Hartman

SQL is licensed on either a per server, per user, or per concurrent user
basis - I don't know which. If it is per user - you will need 50 licenses.
If it is per concurrent user - you will need enough licenses to cover the
maximum number of users logged in at one time. This may be 50 or 1
depending on how your application is used. If the users use SQL server for
other applications, they already have the license and will not need to
acquire separate ones to run your access application.
 
²

²Ì´ä÷

Pat Hartman said:
SQL is licensed on either a per server, per user, or per concurrent user
basis - I don't know which. If it is per user - you will need 50 licenses.
If it is per concurrent user - you will need enough licenses to cover the
maximum number of users logged in at one time. This may be 50 or 1
depending on how your application is used. If the users use SQL server for
other applications, they already have the license and will not need to
acquire separate ones to run your access application.
 
L

lunwanting

Pat Hartman said:
SQL is licensed on either a per server, per user, or per concurrent user
basis - I don't know which. If it is per user - you will need 50 licenses.
If it is per concurrent user - you will need enough licenses to cover the
maximum number of users logged in at one time. This may be 50 or 1
depending on how your application is used. If the users use SQL server for
other applications, they already have the license and will not need to
acquire separate ones to run your access application.
 
J

june1

yes ok
²Ì´ä÷ said:
Pat Hartman said:
SQL is licensed on either a per server, per user, or per concurrent user
basis - I don't know which. If it is per user - you will need 50 licenses.
If it is per concurrent user - you will need enough licenses to cover the
maximum number of users logged in at one time. This may be 50 or 1
depending on how your application is used. If the users use SQL server for
other applications, they already have the license and will not need to
acquire separate ones to run your access application.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top