Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'

Question

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

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

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

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

Error received is

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.

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

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

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

MDM and SQL Server are on different Machine.

Any suggestion?

Answer 1

By default SQL Server will track failed logins and register it in the server log along with the reason. So check out your errorlog and look for errors 18456.

You can read the log by using SQL Server Management Studio by going to server, Management, SQL Server Logs, Current. Or any other way you prefer.

You'll find something like this:

2018-02-27 13:51:26.120 Logon        Error: 18456, Severity: 14, State: 5.
2018-02-27 13:51:26.120 Logon        Login failed for user 'fasd'. Reason: Could not find a login matching the name provided. [CLIENT: 10.80.62.89]

Answer 2

server=Yourservername,portnumber

You can put the above in your connection string