Hi,
I've read the file READ_ME_FIRST from the folder 2 - Jet Configuration Service - Optional\JCS Azure configuration files.
I've first installed SQL Server Express, then installed the Jet Service Tier and it works correctly using the local database (tested the connection using Jet Administration Console).
Now I'd like to point to an Azure database, so I've created a new database, run the script JetConfigurationDatabase.sql and then the SQL Query to add the User and insert the Schema Version as explained in the READ_ME_FIST.
First question is: My admin user is a db user and not a domain user, what should I change in the query? Just leaving the domain empty?
Continuing, I've stopped the Jet Configuration Service and I've added the string in the 'Start Parameters' but the service start and then crashes.
Questions:
- Is <server name> the server where I've installed the Jet Service Tier? Can I write localhost?
- Should I use any single quote or other delimiters to specify the values?
- Should <database name> contain Instance\DatabaseName or just the DatabaseName?
- Is <username> the same user I've inserted in the Users table with the query before? Can It be a db user or must be domain user?
If possible please provide an example of the full string.
How to troubleshoot in case of crash of the service? I've noted that when i start the service the parameters disappear, do I need to rewrite them at every restart or where are they stored?
Last but not least, I've read that you can have only one Jet Service Tier, is the limit referring to have only one database? Could I have multiple server in load balance to access to the same database?
Thanks
Sergio Castelluccio
