问题描述
大家好，
从本地Management Studio连接到Azure中的新SQL Datawarehouse服务时遇到问题.
I have a problem connecting to a new SQL Datawarehouse service in Azure from my local Management Studio.
我尝试了该文章:
https://docs.microsoft.com/zh-cn/azure/sql-data-warehouse/create-data-warehouse-portal
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/create-data-warehouse-portal
我得到的错误是:
已成功与服务器建立连接，但是在登录前握手期间发生错误. (提供者:TCP提供程序，错误:0-指定的网络名称不再可用.)(Microsoft SQL Server，错误:64)
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)
将感谢您的帮助...
will appreciate your help...
推荐答案
您可以尝试使用SQLCMD吗?结果如何?
Can you try with SQLCMD? What is the result?
https://docs. microsoft.com/zh-CN/azure/sql-data-warehouse/sql-data -warehouse-get-started-connect-sqlcmd
您配置了防火墙规则吗?
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-get-started-connect-sqlcmd
Have you configured firewall rule?
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure?toc=/azure/sql-data-warehouse/toc.json
希望这会有所帮助.
Hope this helps.
问候
Regards,
阿尔贝托·莫里洛
SQLCoffee.com
Alberto Morillo
SQLCoffee.com
这篇关于从Management Studio连接到SQL DWH服务时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！