Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ BI Gateway

TABLE OF CONTENTS

Connect SQL Server Management Studio

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedOct 08, 2024
  • 1 minute read

You can connect SQL Server Management Studio (SSMS) to Azure SQL Database.

Connect SSMS

  1. Open SQL Server Management Studio.

    The Connect to Server dialog box appears.

  2. In the Server name box, enter the Datastore Server name. Ensure that this value matches the Datastore Server name displayed in the Datastore Connection Information dialog box. For more information, see View datastore connection information.

  3. In the Authentication drop-down list, select the Azure Active Directory - Password option.

    The dialog box appears.

  4. In the User name and Password boxes, enter the user name and password to connect to SSMS.

  5. Click Options.

  6. Click the Connection Properties tab.

    The dialog box appears as follows.

    sql server

  7. In the Connect to database box, enter the name of the datastore name. Ensure that this value matches the Datastore name displayed in the Datastore Connection Information dialog box. For more information, see View datastore connection information.

  8. Click Connect.

    The connection between SSMS and Azure SQL database is established successfully.

TitleResults for “How to create a CRG?”Also Available in