 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Conversion / May 2008How many user licenses required for SQL Server BE
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 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. >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 [quoted text clipped - 14 lines] > Thanks, > Karen > 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. [quoted text clipped - 22 lines] > > Thanks, > > Karen drytfthgmgmvvgmjf u dr7i84g >> 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 [quoted text clipped - 30 lines] >> > Thanks, >> > Karen yes ok >> 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 [quoted text clipped - 30 lines] >> > Thanks, >> > Karen > 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. [quoted text clipped - 22 lines] > > Thanks, > > Karen
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.