0

I have an application that I'm working on that is supposed to use Azure SQL. The solution builds fine without any errors but it can't find the SQL server. I keep getting this message:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

and it says my source error is this:

Line 73:  DbProviderServices services = DbProviderServices.GetProviderServices(wrappedConnection);
Line 74: 
Line 75:  string token = wrapper.WrappedProviderInvariantName + ";" + services.GetProviderManifestToken(wrappedConnection);
Line 76:  return token;
Line 77:  }

I don't really understand what this means, as I haven't been working with ASP.NET, C#, or Azure long at all. Any help at all would be great.

ono2012
  • 4,967
  • 2
  • 33
  • 42
user3235565
  • 3
  • 2

1 Answers1

2

Please make sure you allowed Windows Azure Serves, and enter IP Addresses (if you want to access via SSMS).

For your scenario, I'll test it via SSMS first - just to make sure Instance name and credential are correct.

enter image description here

Win
  • 61,100
  • 13
  • 102
  • 181