cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.