Licensing of SQL
I previously asked about migrating MS Access to MS SQL 2005 and was informed with the size of my operation that an SQL Server license with 12 device CAL licences would be my best approach.
In an experiment, I loaded SQL Server from the Visual Studio 2003 on one of my PC's in my personal workgroup, then wrote a quick VB 6.0 data access to the SQL table using a oledb connection. I installed the quick data access program on another PC in my workgroup that does not have SQL or SQL CAL and ran updates to the SQL tables and it worked!?!
Are the CAL licences required when doing normal data update routines and not database modification tasks?
In my experiment it seems that only the SQL Server licence and maybe 1 CAL licence is required (for the developer). Is this true?
Any help would be appreciated. Thanks, Tom Amsden.
