Case Status
Log In


Kappris Signing with Azure Dat…
  • RSS Feed

Last modified on 6/2/2020 2:43 PM by User.


Kappris Signing with Azure Database

Sign in to Azure portal EG with the administrator account.

Click on SQL Databases

Click Add+

Name the database keeping the other defaults

Click on your new database and then connection strings

ADO.NET gives the string for use in your Signature.dotm macro

ODBC gives the string for use in your workflows

Now open SQL Management Studio from a server within your network and connect to the Azure DB

R-click Logins and choose New Login

Click File – Open – File and choose your SQL script ‘CreateLoginWithPassword’

Execute the script, changing the username and password as required.

Check that you now have a new login

Now click File – Open – File again choose CreateUser.sql. Check that KapprisWIS is selected in top left and then click Execute.

Note that you have a new user under KapprisWIS – Security – Users


Repeat with GrantExecute.sql

Your database is now ready.

Edit your Kappris.ini file by adding the section below:

ADO.NET Connection String=Data;Initial Catalog=KapprisWIS;Uid=SignatureUsers;Pwd=YourPassword;Encrypt=yes;TrustServerCertificate=no;
ADO Connection String=Provider=SQLOLEDB;Data;Initial Catalog=KapprisWIS;Uid=SignatureUsers;Pwd=YourPassword;Encrypt=yes;TrustServerCertificate=no;