无法通过 SSMS 连接到集成服务 [英] Unable to connect to Integration service through SSMS

问题描述

我已经创建了一个 SSIS 包，现在想要部署它，为此我需要创建 Integration Service Catalog，所以我有 SQL Server评估 设置为当我尝试连接集成服务时，出现以下错误，

I have created a SSIS Package and now want to deploy it, for that I am required to create the Integration Service Catalog,so I have SQL Server Evaluation Set up in that when I m trying to connect the integration service, I am getting following error,

连接到计算机上的 Integration Services 服务《雷什马加达夫》失败，出现以下错误:访问被拒绝."默认情况下，只有管理员有权访问 Integration Services 服务.在 Windows Vista 及更高版本上，该进程必须以管理权限运行以连接到 Integration Services 服务.有关如何配置对服务的访问的信息，请参阅帮助主题.

Connecting to the Integration Services service on the computer "RESHMAJADHAV" failed with the following error: "Access is denied." By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.

我还观察到我的 SQL Server Evaluation edition 实例是 RESHMAJADHAV\SQL_SERVER_EVALU 但是当我尝试连接此服务器时，此选项未显示在集成服务如下图，

Also I have observed that my instance for SQL Server Evaluation edition is RESHMAJADHAV\SQL_SERVER_EVALU but when I am trying to connect this server, then this option is not shown under Integration Services as shown below,

.

我无法解决这个问题，因为我对此完全陌生，请解释可能的解决方案.

I am unable to sort this out, since I am entirely new to this, please explain what can be the solution.

请注意，我也有 sql server express 版本，但由于它不支持创建 SSIS 集成服务目录，所以我安装了 SQL Server 评估版.

Please make a note, I also have sql server express edition ,but since it doesn't support to create the SSIS Integration service catalog then I installed the SQL Server Evaluation edition .

此外，当我尝试通过 SQL 数据库进行连接时，如下图所示，

Also when I am trying to connect via SQL Database as shown in below image,

然后在创建集成服务目录时，出现以下错误

then while creating the integration service catalog, it is given the following error

密码验证失败.密码不符合密码过滤器DLL的密码要求.将数据库上下文更改为 SSISDB.

Password validation failed. The password doesn't meet the requirements of password of the password filter DLL. Change database context to SSISDB.

我观察到的一个事实，我不知道它是否相关，但是当我尝试为我的系统输入密码时，它也会给出相同的错误，即密码不符合要求，并且当安装 SQL Server 版本，它给出了同样的错误，毫无疑问我的密码非常强并且满足强密码的所有要求，目前我正在尝试使用 Windows 身份验证模式运行我的 SQL Server，并且我也尝试禁用强密码来自管理工具的密码策略，但这完全是徒劳的......任何帮助将不胜感激.

One fact I have observed, I don't know whether it is related or not but when I am trying to enter password for my system, then also it's giving same error that password doesn't meet the requirement and also when while installing the SQL Server edition, it gave the same error, no doubt my password was very strong and fulfill all the requirements of strong password, currently I am trying to run my SQL Server with windows authentication mode and also I have tried to disable the strong password policies from the administrative tools but it's totally futile....any help will be greatly appreciated.

推荐答案

我研究了一下才知道原来是HP Laptop的HP Security Tool Manager服务的问题弄乱了系统密码，SQL安装程序和集成服务目录，我从PC上卸载了它，现在我的问题解决了..

I researched little bit and then I came to know it was actually the problem of HP Security Tool Manager service of HP Laptop which was messing with the password of system,SQL Setup and catalog of Integration Service,I uninstalled it from PC and now my problem is resolved..

这篇关于无法通过 SSMS 连接到集成服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！