Skip to main content
Skip table of contents

MS SQL Server - Connect sapio365 to your Microsoft SQL server

To collaborate in sapio365 using a database on your SQL server, you must configure how sapio365 connects.

Some important info for the Microsoft SQL database setup:

  • You must create the database. Note that sapio365 does not create the database. This usually requires some access level to the SQL server we should not have to handle. We let the customer do this, so they can set the proper security access on the database.

  • The user set in the database must have the ability to create and delete tables, in addition to a full access to the records. Usually, our customers create a dedicated user in the database for sapio365.

Configure connection to MS SQL Server

From the Dashboard → Settings → About sapio 365

SQL1.jpg
  1. Choose “Set Collaboration Connection Info”

  2. Enter your subscription code information. This can be found on your Cleverbridge invoice.

  3. Choose SQL Server

SQL2.jpg
  1. You have the option to store your secret key information in an Azure Key Vault. This additional layer of security is optional.

You may choose to create a new key vault or use an existing one. Once you have completed this dialog, the Azure key chose will be associated with your license and you won’t be able to change it.

  1. Configure your SQL server settings.

  2. Test your current settings.

If there is an error, check your credentials and the information you entered.

If the error persists, you can check the connection directly instead of through sapio365. There may be an issue with how how your database is setup.

  1. Enter the subscription code from your Ytria invoice, and Apply.

You should now see collaboration connection information: Server (port) - Instance - Database - Username

SQL3.jpg
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.