Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Analitika
Post Prodigy
Post Prodigy

Connect to server using ms sql server to database

Hello,

 

I would like to ask how to connect to database server using Microsoft SQL server Management Studio. I have connection to database in odbc, and it works, whenever I try connect using microsoft sql server with same connection I am getting this error:

 

Analitika_0-1694528147740.png

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Analitika ,

You can refer the following official documentation to connect to a SQL Server instance:

Connect to a SQL Server instance

vyiruanmsft_0-1694684641893.png

vyiruanmsft_1-1694684762739.png

The error message you’re seeing is quite common when trying to connect to SQL Server. It usually means that the client application can’t find the server or can’t establish a connection. You can refer the following official documentation to make troubleshooting and solve the problem:

A network-related or instance-specific error occurred - SQL Server | Microsoft Learn

  • Check the server and instance name: Make sure the server and instance name you’re trying to connect to is correct.
  • Check the SQL Server service: Make sure the SQL Server service is running. You can check this in the SQL Server Configuration Manager.
  • Check the SQL Server Browser service: If you’re trying to connect to a named instance, make sure the SQL Server Browser service is running.
  • Allow remote connections: Ensure that SQL Server is configured to allow remote connections.
  • Check the network protocols: SQL Server uses TCP/IP and named pipes to communicate. Make sure these network protocols are enabled.
  • Check the firewall: Your firewall might be blocking the connection. You may need to create an exception on the firewall for the SQL Server instance and port you are using.
  • Ping the server: You can try pinging the server to check if DNS can be resolved correctly.

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Analitika ,

You can refer the following official documentation to connect to a SQL Server instance:

Connect to a SQL Server instance

vyiruanmsft_0-1694684641893.png

vyiruanmsft_1-1694684762739.png

The error message you’re seeing is quite common when trying to connect to SQL Server. It usually means that the client application can’t find the server or can’t establish a connection. You can refer the following official documentation to make troubleshooting and solve the problem:

A network-related or instance-specific error occurred - SQL Server | Microsoft Learn

  • Check the server and instance name: Make sure the server and instance name you’re trying to connect to is correct.
  • Check the SQL Server service: Make sure the SQL Server service is running. You can check this in the SQL Server Configuration Manager.
  • Check the SQL Server Browser service: If you’re trying to connect to a named instance, make sure the SQL Server Browser service is running.
  • Allow remote connections: Ensure that SQL Server is configured to allow remote connections.
  • Check the network protocols: SQL Server uses TCP/IP and named pipes to communicate. Make sure these network protocols are enabled.
  • Check the firewall: Your firewall might be blocking the connection. You may need to create an exception on the firewall for the SQL Server instance and port you are using.
  • Ping the server: You can try pinging the server to check if DNS can be resolved correctly.

Best Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.