从Management Studio连接到SQL DWH服务时出现问题 [英] Problem connecting to SQL DWH service from Management Studio

问题描述

大家好，

从本地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...

推荐答案

您好，

当您对Azure SQL数据仓库执行ping操作时，它会解析名称并为您提供IP吗?

Hello,

When you ping your Azure SQL Data Warehouse, does it resolve the name and give you the IP?

Can you try with SQLCMD? What is the result?

https://docs.

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/zh-CN/azure/sql-database/sql-database-firewall-configure? toc =/azure/sql-data-warehouse/toc.json

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服务时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！