RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://learn.microsoft.com/en-us/fabric/database/sql/connect below:

Connect to Your SQL Database - Microsoft Fabric

Applies to: â SQL database in Microsoft Fabric

You can connect to and query your SQL database in Fabric in all the same ways as Azure SQL Database.

Prerequisites

You need an existing Fabric capacity. If you don't, start a Fabric trial.
Create or use an existing SQL database in Fabric.
- If you don't have one already, create a new SQL database in Fabric.

Currently, the only supported connection policy for SQL database in Microsoft Fabric is Redirect. For more information, see Connection policy.

Query editor in the Fabric portal

You can connect to the SQL database using the web-based editor in the Fabric portal.

The web-based editor for SQL database in Fabric provides a foundational object explorer and query execution interface. The integrated Explorer menu lists all database objects.

A new SQL database in Fabric automatically opens into the web editor and an existing database can be opened in the web editor by selecting it in Fabric.

Find SQL connection string

In Microsoft Fabric, the SQL analytics endpoint and SQL database are accessible through a Tabular Data Stream, or TDS endpoint, familiar to all modern web applications that interact with a SQL Server TDS endpoint. This is referred to as the SQL connection string within the Microsoft Fabric user interface.

The connection string of the SQL database is similar to the connection string of Azure SQL Database, <server-unique-identifer>.database.windows.net. The SQL analytics endpoint connection string looks like <server-unique-identifier>.<tenant>.fabric.microsoft.com.

To find the SQL connection string for your Fabric SQL database:

Go to the settings of your SQL database item.
Or, in the item list, select the ... menu. Select Settings then Connection strings. Fabric provides complete connection strings for providers including ADO.NET, JDBC, ODBC, PHP, and Go.
Or, select the Open in button and SQL Server Management Studio. The server connection information is displayed.

To find the SQL connection string for the SQL analytics endpoint of your Fabric SQL database:

Go to the settings of your SQL database item, then select SQL endpoint.
Or, select the ... menu, then select Copy SQL connection string.

Open in button to connect

You can easy connect to your SQL database with the Open in button in the Fabric portal query editor. Choose SQL Server Management Studio or the mssql extension with Visual Studio Code.

Connect with SQL Server Management Studio manually

In SQL Server Management Studio (SSMS):

From your workspace area in the Database workload of Fabric, select the ... next to your SQL database.
Select Settings.
Select Connection strings. Look for the connection string to your SQL database, including the Data Source=. For example, tcp:<servername>.database.fabric.microsoft.com,1433. The Initial Catalog= is the database name.
In SSMS, open a New connection.
From the Fabric dialog box, copy and paste the value from Server Name into the Server name.
Choose Authentication type: Microsoft Entra ID - Universal with MFA support.
Select Options<<.
Copy and paste the value from Database Name into the Connect to database text box.
Select Connect.
Sign in using Microsoft Entra ID - Universal with MFA support.

Connect with sqlcmd

You can connect to your SQL database in Fabric with sqlcmd, just like any other SQL Database Engine product. Use Microsoft Entra ID authentication with the G option. The Microsoft Entra authentication (-G) requires at least version 13.1.

In the following example, replace <server name> with the long string of unique text that represents your SQL database in Fabric.

sqlcmd -S <your_server>.database.fabric.microsoft.com;1433 -G -d <your_database> -i ./script.sql

Connect with bcp utility

You can connect to your SQL database in Fabric with the bcp utility, just like any other SQL Database Engine product. Use Microsoft Entra ID authentication with the -G option.

In the following example, replace <server name> with the long string of unique text that represents your SQL database in Fabric.

bcp bcptest in "c:\temp\sample.dat" -S <your_server>.database.fabric.microsoft.com;1433 -d testdb -G -c

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4