Discussion:
How many user licenses required for SQL Server BE
(too old to reply)
kscheu via AccessMonster.com
2008-02-05 15:55:02 UTC
Permalink
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
Pat Hartman
2008-02-11 14:51:57 UTC
Permalink
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.
Post by 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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
²ÌŽä÷
2008-05-07 08:19:12 UTC
Permalink
Post by 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.
Post by 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
Post by Pat Hartman
Post by kscheu via AccessMonster.com
of
user licenses I would need to purchase. If I create pass through
queries
Post by Pat Hartman
Post by kscheu via AccessMonster.com
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
Post by Pat Hartman
Post by kscheu via AccessMonster.com
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
june1
2008-05-31 11:31:07 UTC
Permalink
drytfthgmgmvvgmjf u dr7i84g
Post by Pat Hartman
Post by 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.
Post by Pat Hartman
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
Post by Pat Hartman
other applications, they already have the license and will not need to
acquire separate ones to run your access application.
Post by kscheu via AccessMonster.com
I have an Access front end application that links to Access Back end
tables
Post by Pat Hartman
Post by kscheu via AccessMonster.com
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
Post by Pat Hartman
Post by kscheu via AccessMonster.com
of
user licenses I would need to purchase. If I create pass through
queries
Post by Pat Hartman
Post by kscheu via AccessMonster.com
and
use one login id to SQL server for the Front end to use to access the
SQL
Post by Pat Hartman
Post by kscheu via AccessMonster.com
Server BE tables, will I need a user license for all 50 users or just
one
Post by Pat Hartman
Post by kscheu via AccessMonster.com
for
the FE application?
What about if I link the BE SQL Server tables to the FE? Will I need
50
Post by Pat Hartman
Post by kscheu via AccessMonster.com
licenses or just one?
Thanks,
Karen
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
june1
2008-05-31 12:00:05 UTC
Permalink
yes ok
Post by Pat Hartman
Post by 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.
Post by Pat Hartman
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
Post by Pat Hartman
other applications, they already have the license and will not need to
acquire separate ones to run your access application.
Post by kscheu via AccessMonster.com
I have an Access front end application that links to Access Back end
tables
Post by Pat Hartman
Post by kscheu via AccessMonster.com
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
Post by Pat Hartman
Post by kscheu via AccessMonster.com
of
user licenses I would need to purchase. If I create pass through
queries
Post by Pat Hartman
Post by kscheu via AccessMonster.com
and
use one login id to SQL server for the Front end to use to access the
SQL
Post by Pat Hartman
Post by kscheu via AccessMonster.com
Server BE tables, will I need a user license for all 50 users or just
one
Post by Pat Hartman
Post by kscheu via AccessMonster.com
for
the FE application?
What about if I link the BE SQL Server tables to the FE? Will I need
50
Post by Pat Hartman
Post by kscheu via AccessMonster.com
licenses or just one?
Thanks,
Karen
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
lunwanting
2008-05-07 08:21:28 UTC
Permalink
Post by 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.
Post by 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
Post by Pat Hartman
Post by kscheu via AccessMonster.com
of
user licenses I would need to purchase. If I create pass through
queries
Post by Pat Hartman
Post by kscheu via AccessMonster.com
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
Post by Pat Hartman
Post by kscheu via AccessMonster.com
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
Continue reading on narkive:
Loading...