Skip to content
logo Knowledgebase

Sage 200 Professional - How to obtain a connection string for a Microsoft Azure SQL Database via the Azure Portal

Created on  | Last modified on 

Summary

This article relates to the Sage 200 Professional software deployed via the Sage Provisioning Portal and explains the process of obtaining a connection string for a Microsoft Azure SQL database through the Microsoft Azure Portal

Resolution

Make a note of your SQL Server name, this can be found on your Site page in the Sage Provisioning Portal.

Image

Go to https://portal.azure.com and open Resource groups (under Azure services).

Image

Enter the SQL Server name into the search box and click on the SQL Server Resource Group.   

Image

Find and click on the resource (the server or the database) for which you are looking to obtain the connection string.

Image

Click on Connection Strings (under Settings on the left-hand menu).

Image

Select the desired format (ADO.NET, JDBC, ODBC, PHP, Go) of the connection string, and copy the connection string.

Image
NOTE: You will need to enter your password into the string manually.