# Fabric SQL

**To set up your Database instance, follow the steps below:**

* Log in to the DBSync Cloud Replication instance
* To configure, navigate to the Database tab.
* Click the Database icon from the top navigation toolbar
* To start with, select Fabric SQL and enter all the configuration details like host, port, username, password, database name, and schema.

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FLbngdoEZ1sJ5334zytSF%2Fimage.png?alt=media&#x26;token=65446c77-8458-45c8-ab7a-c4a8bbd4909a" alt=""><figcaption></figcaption></figure>

> Select AAD Password Authentication

> How to get Fabric SQL details&#x20;

* Log in to the Azure portal and open your Fabric workspace at:[ https://app.fabric.microsoft.com/](https://app.fabric.microsoft.com/)
* Create a database, then click the settings icon in the left panel

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FIhkoh9VXiGyhyNCoAD7g%2Fimage.png?alt=media&#x26;token=fced39c3-dd59-4e68-b601-dab1fd5bb2e3" alt=""><figcaption></figcaption></figure>

* Then select the Connection strings.

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FGOvm0Mp61N3EbSVyPVQn%2Fimage.png?alt=media&#x26;token=38f1f616-e788-4143-bee3-8fbbc471f83a" alt=""><figcaption></figcaption></figure>

* The host name can be found after Data Source= in the connection string, for example

```
avrav7zpjxje3cthvcgnyigimac7mnyi5rj3qedi7s3gxmpkk7wm.database.fabric.microsoft.com
```

* Use port number 1433
* Use your Azure username and password for authentication  \
  The database name can be found after Initial Catalog=, for example: Fabric sql-6f742f08-00b4-4553-91d3-839339681861

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FreUiWZ1Z3fcsEBWQYqPA%2Fimage.png?alt=media&#x26;token=8cb359f3-773f-400f-a20c-621942292e30" alt=""><figcaption></figcaption></figure>

* Once the user enters all the details, the URL details will get auto-filled.
* Click Save
* You can save and test your Database connection.

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FF0ebroxTlMs7WQJliiUo%2Fimage.png?alt=media&#x26;token=5b9d5e54-fb58-46fa-ae52-2a7bb78679f1" alt=""><figcaption></figcaption></figure>

* Click Next
