Forum Discussion

KavyaReddy's avatar
KavyaReddy
Regular Visitor
1 year ago
Solved

How to connect to sql datatbase

I am unable to connect to sqldatabase getting below error. Could, you please help me     Thanks
Need Help
  • v-kathullac's avatar
    v-kathullac
    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.

v-kathullac's avatar
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.