I am getting a network related error saying cannot connect to a server need help here

0 votes

Below is the error i get when i try to connect to the SQL server:
 

Cannot connect to 108.164.201.162.

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

I am currently trying to configure the database to gridview in VS 2010. 
Can someone help me debug this error? TIA

Apr 26, 2018 in Azure by cloudie_crank
• 1,610 points

edited Apr 27, 2018 by cloudie_crank 1,006 views

1 answer to this question.

0 votes

Actually i got the same error, it is just a IP related issue.

You can try the below steps:

  • Open "SQL Server Configuration Manager"
  • Now Click on "SQL Server Network Configuration" and Click on "Protocols for Name"
  • Right Click on "TCP/IP" (make sure it is Enabled) Click on Properties
  • Now Select "IP Addresses" Tab -and- Go to the last entry "IP All"
  • Enter "TCP Port" 1433.
  • Now Restart "SQL Server .Name." using "services.msc" (winKey + r)

It worked for me.

answered Apr 27, 2018 by null_void
• 3,220 points
Thank you so much sir :)

Related Questions In Azure

0 votes
2 answers

I am getting "Insufficient Privileges" error when trying to access Azure Graph APIs.

I had the same issue before, and ...READ MORE

answered Sep 17, 2019 in Azure by Ju Cheh
23,217 views
+1 vote
2 answers

How do I establish an connection to Azure IoT Hub? Say a connection like MQTT/AMQP using Python.

Azure IoT Hub comes with 3 SDK's: Service SDK Device ...READ MORE

answered Apr 13, 2018 in Azure by null_void
• 3,220 points
2,183 views
0 votes
2 answers

How can I download a .vhd image to my local machine from azure and upload the same to a different azure account?

From the Windows Azure Portal you can ...READ MORE

answered Aug 20, 2018 in Azure by Priyaj
• 58,100 points
13,969 views
0 votes
1 answer

Is there a way to get ERROR details on Azure website?

You have two options: First, you can turn ...READ MORE

answered May 25, 2018 in Azure by club_seesharp
• 3,450 points
2,613 views
+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
2,605 views
0 votes
1 answer

How to debug Azure 500 internal server error?

You can simply turn off custom error in ...READ MORE

answered Mar 29, 2019 in Azure by Prerna
• 1,960 points
4,825 views
0 votes
1 answer

How can I copy SQL Azure database to a local development server?

There are certain ways to do this: Using SSIS ...READ MORE

answered Jun 26, 2018 in Azure by null_void
• 3,220 points
1,171 views
0 votes
1 answer

Why as a co-administrator of a subscription am I unable to edit the Active Directory?

The answer was that I needed to ...READ MORE

answered Aug 23, 2018 in Azure by null_void
• 3,220 points
750 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP