How to connect to sql datatbase

I am unable to connect to sqldatabase getting below error. Could, you please help me

Thanks

v-kathullac
Community Support
1 year ago
Hi KavyaReddy,

Thank you for reaching out to Microsoft Fabric Community Forum.

Below are the few debug steps to solve your issue.

1) Check if the SQL Server name and instance are correct (e.g., SERVERNAME\SQLEXPRESS)

2) Make sure SQL Server service is running (Use services.msc to verify)

3) Enable TCP/IP and Named Pipes in SQL Server Configuration Manager

4) Allow remote connections (SQL Server Properties > Connections > Check “Allow remote connections”)

5) Check Windows Firewall settings Open port 1433 for SQL Server Allow sqlservr.exe in firewall rules

6) Start the SQL Server Browser service

7) Test connection via SQL Server Management Studio (SSMS) Verify correct authentication method is used (Windows Authentication vs SQL Server Authentication)

8 ) Ensure network discovery is enabled on both machines(if you connected remotely)

Regards,

Chaithanya.
Cookistador
Super User
1 year ago
Are you sure of the name ?
Do you have access to the database from your computer ? (for example with SQL Server management studio)
v-kathullac
Community Support
1 year ago
Hi KavyaReddy ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

Forum Discussion