我当前无法从专用数据中心中的单独远程独立专用机箱连接到我的Azure SQL数据库.
我有一个Azure SQL数据库,我在其中管理可以连接到此数据库的IP地址列表.到目前为止,这种做法一直运作得很好.我最近在一个私有数据中心设置了一个新的专用箱,它需要以规则的5秒间隔(或多或少)查询Azure SQL数据库.
The problem is, this dedicated box cannot establish a connection to the Azure SQL database, despite being able to connect to other remote FTP servers, MySQL servers, etc. The Azure SQL database does have the IP address of the dedicated box on the allowed connection list. Furthermore, I temporarily opened up a massive range of allowed IP addresses (0.0.0.0 -> 255.255.255.255) on the Azure SQL database to see whether this inability to connect may have resulted from IP blocking.
有没有人有什么建议或 idea 可能会导致这种情况,以及我如何才能开始更好地调试这种情况?
需要澄清的是:我可以从办公室和其他地方拥有单独IP地址的笔记本电脑连接到Azure SQL数据库,只要它们已经添加到数据库白名单中;我可以从专用的盒子向外连接到远程FTP和MySQL服务器;我已经try 在Azure SQL上打开大量允许的IP地址,但没有成功.
Edit个
C:\Users\graphite.rack.ID17157>osql -S v7o06blktw.database.windows.net -U XXXXXXX@v7o06blktw -P XXXXXXX
[SQL Server Native Client 11.0] Named Pipes Provider: Could not open a
connection to SQL Server [53].
[SQL Server Native Client 11.0] Login timeout expired
[SQL Server Native Client 11.0] A network-related or instance-specific error
has occurred while establishing a connection to SQL Server. Server is not
found or not accessible. Check if instance name is correct and if SQL Server
is configured to allow remote connections. For more information see SQL Server
Books Online.