SQL网络接口，错误:26使用Windows Azure [英] SQL Network Interfaces, error: 26 using Windows Azure

问题描述

我有一个正在使用的应用程序应该使用Azure SQL.该解决方案构建良好，没有任何错误，但是找不到SQL Server.我不断收到此消息:

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:

与网络相关或特定于实例的错误发生在建立与SQL Server的连接.找不到服务器或无法访问.验证实例名称正确，并SQL Server配置为允许远程连接.(提供者:SQL网络接口，错误:26-查找服务器/实例时出错已指定)

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:  }

我真的不明白这意味着什么，因为我根本没有使用过ASP.NET，C#或Azure.任何帮助都很好.

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.

推荐答案

请确保已允许Windows Azure服务，然后输入IP地址(如果要通过SSMS访问).

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

对于您的情况，我将首先通过SSMS进行测试-只是确保实例名称和凭据正确无误.

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

这篇关于SQL网络接口，错误:26使用Windows Azure的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！