SQL Server的Microsoft ODBC驱动程序13:用户"sa"的登录失败 [英] Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'

问题描述

我正在安装Informatica的MDM. MDM 10.2-Jboss 6.4 EAP-SQL Server 11-Windows Server 2008 R2.

Im installing the MDM of Informatica. MDM 10.2 - Jboss 6.4 EAP - SQL Server 11 - Windows Server 2008 R2.

在创建架构"sip_ant.bat create_bpm"期间，我遇到了此错误

During the creation of the schema 'sip_ant.bat create_bpm' i got this error

用于SQL Server的Microsoft ODBC驱动程序13:用户'sa'登录失败. (与另一位用户相同的ereror)

Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'. (Same eeror with another user)

我已经尝试使用 Auth混合模式，并重新启动了数据库实例.

I already tried to use the Auth Mixed Mode and restarted the instance of the DB.

收到的错误是

D:\informatica\database\bin\common.xml:248: The following error occurred while executing this line:
D:\informatica\database\bin\mssql\database.xml:1214: Launched command return error code 1.

这是database.xml:1214所在的行，它引用:

And that's the line of database.xml:1214 that refers:

 collation_name="${activevos.collation}" param2=""${dbpath_short}"" param1="${activevos.password}">

我能够使用用户'sa'和其他用户通过CMD上的SQLCMD登录.

Im able to login via SQLCMD on CMD with user 'sa' and other users.

MDM和SQL Server在不同的计算机上.

MDM and SQL Server are on different Machine.

有什么建议吗?

推荐答案

问题出在客户配置了另一个默认SQL端口以在SQL管理上使用.

Problem was due to Customer configured another Default SQL port to use on SQL Management.

这篇关于SQL Server的Microsoft ODBC驱动程序13:用户"sa"的登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！