Installation cancels because of login failed for user 'SAPSIDDB'

[Former Member]

Hi everybody,

I am installing SAP Solution Manager 7 EHP1 on Windows Server 2008 R2 and SQL 2008, the process cancels in the Java import, the following message appears in jload.java.log:

java version "1.4.2_30"

Java(TM) Platform, Standard Edition for Business (build 1.4.2_30-b04)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_30-b04, mixed mode)

20/03/2011 02:21:14 AM com.sap.inst.jload.Jload main

INFO: Jload -sec SLM,jdbc/pool/SLM,
ZILMOSOL/sapmnt/SLM/SYS/global/security/data/SecStore.properties,
ZILMOSOL/sapmnt/SLM/SYS/global/security/data/SecStore.key -dataDir E:/IBM/Java_Components\DATA_UNITS\SOLMAN_JAVA_EXPORT_JDMP -job C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log

20/03/2011 02:21:16 AM com.sap.inst.jload.Jload main

GRAVE: couldn't connect to DB

20/03/2011 02:21:16 AM com.sap.inst.jload.Jload logStackTrace

GRAVE: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SAPSLMDB'.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)

at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)

at com.sap.inst.jload.Jload.main(Jload.java:583)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:331)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Edited by: alejovw on Mar 20, 2011 3:18 PM

[former_member189546 · Accepted solution]

Hello,

GRAVE: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SAPSLMDB'.

J2EE does not use Windows Authentication but it uses a common username

password logon to SQL Server. The logon data for the users are stored in

the secure store and can be changed using the J2EE config tool.

Can you please make sure that the password is set correctly for the

SAPSLMDB in the secure store?

regards,

John Feely

[Former Member · Accepted solution]

Dear Jhon,

We could find the sectore file, but there was no way to update because the configtool was not installed. We change the SAPSLMDB´s password right in the SQL manager and we solved the problem.

Thanks for your response.