无法从SQL Server Management Studio远程连接到Plesk v12 SQL Server [英] Cannot Connect to Plesk v12 SQL Server Remotely from SQL Server Management Studio

问题描述

我很难理解为什么可以访问 mssql.anggalisdiyanto.net 域并且我可以登录通过浏览器从ASP.NET企业管理器成功完成，但从SQL Server Management Studio失败.如下图所示是错误:

I am difficult to understand why the mssql.anggalisdiyanto.net domain is can be accessed and i can login successfully from ASP.NET Enterprise Manager via browser, but not from SQL Server Management Studio. It is error like in below figure :

请帮助我，谢谢.

推荐答案

您正在使用的MSSQL实例名称是什么?

What is MSSQL instance name you are using?

如果您未指定实例名称并像"server.com"那样进行连接，则使用默认实例名称"MSSQLSERVER"，但是您的MSSQL服务器的实例名称可能是"MSSQLSERVER2012"或"SQLEXPRESS"，在这种情况下，您可以应该像"server.com \ MSSQLSERVER2012"或"server.com \ SQLEXPRESS"那样连接

If you don't specify instance name and connect like "server.com" than default instance name is used "MSSQLSERVER", but instance name of your MSSQL server may be "MSSQLSERVER2012" or "SQLEXPRESS" and in this case you should connect like "server.com\MSSQLSERVER2012" or "server.com\SQLEXPRESS"

您可以在"SQL Server配置管理器"中检查实例名称:

You can check instance name in "SQL server configuration manager":

如果实例名称正确，请检查指定IP地址的远程网络连接是否已启用"(但要注意安全威胁):

In case instance name is OK, check that remote network connections are "Enabled" for specified IP addresses(but pay attention to security threats):

安全说明

当您允许与MS SQL Server的远程连接时，这意味着SQL Server 将打开以接受密码暴力攻击，拒绝服务(DoS)攻击以及任何种类的利用攻击.

When you allow remote connections to MS SQL server it means that SQL server will be open for password brute force attacks, Denied of Service(DoS) attacks, any kinds of exploit attacks.

所有这些攻击都可能使整个服务器变慢.

All this kinds of attacks may slowdown whole your server.

这篇关于无法从SQL Server Management Studio远程连接到Plesk v12 SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！