Hmm, that is odd. There's no firewall settings to configure on the Fabric side. What other connection options are failing for you?
I wonder if these apps are attempting to connect to "<default>" or "master", instead of the specific database.
We can try out a plain C# console app and see if that gives us any insights into the connectivity -
ConnectionTester.csproj
<Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<OutputType>Exe</OutputType>
<TargetFramework>net8.0</TargetFramework>
<ImplicitUsings>enable</ImplicitUsings>
<Nullable>enable</Nullable>
</PropertyGroup>
<ItemGroup>
<PackageReference Include="Microsoft.Data.SqlClient" Version="6.1.1" />
<PackageReference Include="Microsoft.Extensions.Configuration" Version="8.0.0" />
<PackageReference Include="Microsoft.Extensions.Configuration.Json" Version="8.0.0" />
</ItemGroup>
<ItemGroup>
<None Include="appsettings.json">
<CopyToOutputDirectory>Always</CopyToOutputDirectory>
</None>
</ItemGroup>
</Project>
appsettings.json
{
"ConnectionStrings": {
"DefaultConnection": "Data Source=yourcxninfo.database.fabric.microsoft.com,1433;Initial Catalog=AdventureWorks-20ba15a4-b4f9-4d46-ad10-ddd9d0b7a6ea;Multiple Active Result Sets=False;Connect Timeout=30;Encrypt=True;Trust Server Certificate=False;Authentication=Active Directory Interactive"
}
}
Program.cs
using Microsoft.Data.SqlClient;
using Microsoft.Extensions.Configuration;
using System.Diagnostics;
namespace ConnectionTester;
class Program
{
private static IConfiguration? _configuration;
static async Task Main(string[] args)
{
// Build configuration from appsettings.json
_configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
.Build();
Console.WriteLine("SQL Database Connection Tester");
Console.WriteLine("==============================");
Console.WriteLine();
var connectionString = _configuration?.GetConnectionString("DefaultConnection");
if (string.IsNullOrEmpty(connectionString))
{
Console.WriteLine("✗ Error: No connection string found in appsettings.json");
return;
}
await TestDatabaseConnectionAsync(connectionString);
Console.WriteLine();
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
private static async Task TestDatabaseConnectionAsync(string connectionString)
{
var stopwatch = Stopwatch.StartNew();
try
{
Console.WriteLine("Attempting to connect to the database...");
using var connection = new SqlConnection(connectionString);
// Test opening the connection
await connection.OpenAsync();
Console.WriteLine("✓ Successfully connected to the database!");
// Test executing a simple query
Console.WriteLine("Testing query execution...");
using var command = new SqlCommand("SELECT @@VERSION as ServerVersion, GETDATE() as CurrentTime", connection);
using var reader = await command.ExecuteReaderAsync();
if (await reader.ReadAsync())
{
Console.WriteLine("✓ Query execution successful!");
Console.WriteLine($" Current Server Time: {reader["CurrentTime"]}");
}
stopwatch.Stop();
Console.WriteLine($"✓ Connection test completed successfully in {stopwatch.ElapsedMilliseconds}ms");
}
catch (SqlException sqlEx)
{
stopwatch.Stop();
Console.WriteLine($"✗ SQL Server error occurred after {stopwatch.ElapsedMilliseconds}ms:");
Console.WriteLine($" Error Number: {sqlEx.Number}; Severity: {sqlEx.Class}; State: {sqlEx.State}; Message: {sqlEx.Message}");
}
catch (Exception ex)
{
stopwatch.Stop();
Console.WriteLine($"✗ General error occurred after {stopwatch.ElapsedMilliseconds}ms:");
Console.WriteLine($" Type: {ex.GetType().Name}");
Console.WriteLine($" Message: {ex.Message}");
}
}
}
