MSSQL licences policies for Servoy usage? Help needed

In my opinion, Servoy application server will only need one CAL on an MSSQL server.

Is this always true for servoy client access?
Did you experience any troubles about licence usage when using modules ?
Please give me an advise if this assertion is false.
Thank you in advance.

The servoy server and not the servoy client connects to the database. Number of clients or modules does not affect the mnumber of db connections.

Thank you Bob,

If I read you well, my assertion is true?

Your assertion is techniucally true. However, I do not claim to be an expert on Microsoft licensing - I tend to avoid buying software from Microsoft.

it depends whether you wish to go into disucssion with them. Their official position is that you have to pay for the final end connection, you could however challenge them and say that from a technical point of view their is only one user. You might want to have somebody with a legal background have a in depth look at their exact license terms.

bob cart:
I tend to avoid buying software from Microsoft.

You know, the ways of the customer…

jaleman:
You might want to have somebody with a legal background have a in depth look at their exact license terms.

We will let the lawers of our customer give their advice. If we get some official position, we will report it here.

Many thanks for your help.

Now that I think about the ways of customers, I remember that I did buy some MS SQL licenses a few years ago. It was for a website and even though the application server (Dynamo) only needed a single db connection, we had to buy a special web license that cost a good bit more. I think the development server was cheap, but they also charged us for the staging server. My guess is that they would treat Servoy the same way.

Microsoft also offers a license free version of MS SQL, called MSDE. This version can be distributed free of charge. As far as I know, the only difference to the full version is limited connections and not enterprise manager (management tool). If the limit of connections is enough for Servoy, you might have a cheap solution for a pretty good database. :)

You can find information here: SQL Server 2019 | Microsoft

patrick:
Microsoft also offers a license free version of MS SQL, called MSDE. This version can be distributed free of charge. As far as I know, the only difference to the full version is limited connections and not enterprise manager (management tool). If the limit of connections is enough for Servoy, you might have a cheap solution for a pretty good database. :)

You can find information here: SQL Server 2019 | Microsoft

There was a limit of 5 users and 1GB of data for this I believe. They may have upped it a bit with the recent release. It’s a good deal, but you must handle all the db management and backup with your own tools.

Regards,
Lee Snover

After all, we decided to take the following orientation:

To all of our corporate customer who must stick to company standards we advise to choose a cpu oriented licence. (Or to integrate servoy tables on a main company DB server)
To all other, we advise to keep with ASA, with a second choice being progress.

Thank you all for your time.

Someone asked me directly about installing progress.

OOPS :oops: I mispelled it, sorry.

Please read PostgreSQL and NOT progress.
We have no troubles using PostgreSQL 7.6, and will soon test 8.x

Just want to say that I’m using PostgreSQL 8.0.1 on Mac OS X 10.3.9 for development and for one small client without any problems whatsoever.

PostgreSQL 8.01 on WinXP sp2 on development is REALLY good
my preferred setup in combination with

DataArchitect (www.theKompany.com)
Aqua Data Studio 4.0

Beats ASA anytime in terms of speed of development and I’m ready to compare DataArchitect to PowerDesigner (for my humble needs anyway)

And it’s completely cross platform

And it costed me ca. 80

Odysseus:
PostgreSQL 8.01 on WinXP sp2 on development is REALLY good
my preferred setup in combination with

DataArchitect (www.theKompany.com)
Aqua Data Studio 4.0

In my experience on Mac, DataArchitect seems a bit unstable.
Aqua Data Studio is good and so is
dbVisualizer from www.dbviz.com (link not working) but i found another link http://www.codework.com/dbvis/product.html