My company is shopping for sql server, we want to migrate to in the very near future. I have a licencing question. If users have a local copy (runtime) of front end of access connected to sql server back end, do we need cal licence for each user?
Access/SQL Server Cal Licence (1 Viewer)
- Thread starter jsdba
- Start date
- Local time
- Today, 12:10
- Joined
- Feb 19, 2013
- Messages
- 16,634
I don't know for definite but I would think yes - sql server is a backend only, the fact you are running a free licence front end is irrelevant.
depending on your requirements you can consider using sql server express which is license free but has certain limitations - primary ones are limited to 10gb of data and only uses one core for processing (same as access). Depending on your reasons for moving to sql server, perhaps use express for testing purposes and upgrade to the full fat version if required.
If the reason for moving is poor performance, be aware the main reason for poor performance across a network is due to poor form/report/query design and/or lack of or inappropriate indexing and/or a choked network. Using sql server as a back end will not in itself resolve these issues.
depending on your requirements you can consider using sql server express which is license free but has certain limitations - primary ones are limited to 10gb of data and only uses one core for processing (same as access). Depending on your reasons for moving to sql server, perhaps use express for testing purposes and upgrade to the full fat version if required.
If the reason for moving is poor performance, be aware the main reason for poor performance across a network is due to poor form/report/query design and/or lack of or inappropriate indexing and/or a choked network. Using sql server as a back end will not in itself resolve these issues.
Minty
AWF VIP
- Local time
- Today, 12:10
- Joined
- Jul 26, 2013
- Messages
- 10,371
SQL Server licensing can be complicated.
As CJ stated you can can get Multi Processor and different versioning licences - I would have a look here https://www.microsoft.com/en-us/sql-server/sql-server-2016-pricing and see what version suits your requirements.
As CJ stated you can can get Multi Processor and different versioning licences - I would have a look here https://www.microsoft.com/en-us/sql-server/sql-server-2016-pricing and see what version suits your requirements.
