Hello. We are looking to upgrade from Advanced to premium primarily because of the need for external reporting from "3rd Party" tools. These tools require SQL server access to be able to PULL data from Sage running SQL.
We have read where the SQL server runtime can not run other applications which makes sense. BUT can the other applications read that SQL data or would we need the SQL standard license for that.?
Thanks for any info
You need SQL licenses for Premium (one per connection, unless you license by core). What Sage sells for SQL licenses is restricted to Sage 100 use only, and not applicable to cloud hosted servers.
I don…
Yes, the terminology can be confusing.
If you see any reference to only needing two SQL licenses because Sage connects to SQL using the same two utility SQL logins, that is absolutely wrong. SQL licensing…
Sage has scattered little tidbits of SQL requirements in the various PDF documentation. You really have to read it all to find everything. That particular detail is in the Install & Sys Admin guide.…
Sage has scattered little tidbits of SQL requirements in the various PDF documentation. You really have to read it all to find everything. That particular detail is in the Install & Sys Admin guide.
In that same document is reference to the collation, which is a critical detail. (Most don't notice this, because this is the default value for servers running in US English, but it is potentially disastrous if set incorrectly).
Are you working with your Sage Partner / reseller?
