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

sql-server sql-server-2008 informatica mdm
DanieleO picture DanieleO · Feb 26, 2018 · Viewed 24.6k times · Source

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

kirchner picture kirchner · Feb 27, 2018

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]

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More