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 26, 2018 by cloudie_crank 73 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 26, 2018 by null_void
• 3,220 points
Thank you so much sir :)

Related Questions In Azure

0 votes
2 answers
+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
589 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
• 56,900 points
2,689 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
165 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
238 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 in Azure by Prerna
• 1,940 points
356 views
0 votes
1 answer

I want to detect whether a request is being made over HTTPS or HTTP on Azure Websites.

It's looking like you can make use of ...READ MORE

answered Apr 2 in Azure by Prerna
• 1,940 points
44 views
0 votes
1 answer

Getting an error when trying to authenticate using REST API Dynamics CRM with Azure AD.

Dynamics 365 has started to support Server-to-Server ...READ MORE

answered Apr 25 in Azure by Prerna
• 1,940 points
149 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
70 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 22, 2018 in Azure by null_void
• 3,220 points
24 views