cancel
Showing results for 
Search instead for 
Did you mean: 

SAPService<SAPSID> password change

manoj_nayak2
Participant
0 Kudos

Hi,

In ditributed system i have changed password of SAPService<SAPSID> user in DB instance, after that i am getting log

01:02:45 DIA 000 BY 2 Database error -1 at CON

01:02:45 DIA 000 BY 0 > Login failed for user ''. The user is not associated with a

01:02:45 DIA 000 BY 0 > trusted SQL Server connection.

in TP test also i am getting error

ERRORS: Highest tp internal error was: 0232

So in this scenario should i changed password of user SAPService<SAPSID> in Central instance also?

Regarda

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please check your services are running. Did you change the password in services to for SAPservice<SAPSID>?

[http://help.sap.com/saphelp_nwmobile71/helpdata/en/aa/1dc94af0fa11d3a6510000e835363f/content.htm]

manoj_nayak2
Participant
0 Kudos

Hi,

Services are running.

in work process trace i found

Mon Feb 28 11:22:46 2011

OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server co

sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associ

Procname: [OpenOledbConnection - no proc]

sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

in sm66 i found

Type PID Status Start

DIA 4340 Complet No

DIA 2280 Complet No

Any idea?

Regards

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

If you have change the password of SAPService<SID> user then you need to update same in window services for SAP as well.

Thanks

Sunny

Former Member
0 Kudos

Hello,

The user SAPService<SID> is a Domain or local user? If is a local user you need change the password on each server of your system.

Please execute the following command: R3trans -x and paste the output.

See U

Cristian

manoj_nayak2
Participant
0 Kudos

Hi,

SAPServiceSID user is a local user.

Note: This is distributed system like DB & CI. I only changed the password of SAPServiceSID in DB instance.

I executed R3trans -d from CI (Central Instance). Below is log of trans.log

4 ETW000 R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 02.03.2011 - 01:18:02

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Mar 02 01:18:02 2011 5771 0.005771

4 ETW000 [dev trc ,00000] db_con_init called 22 0.005793

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 126 0.005919

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 52 0.005971

4 ETW000 [dev trc ,00000] Wed Mar 02 01:18:03 2011 209696 0.215667

4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000187700000

4 ETW000 78 0.215745

4 ETW000 [dev trc ,00000] using "D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\dbmssslib.dll" 17 0.215762

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 40 0.215802

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll 23 0.215825

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.179) 23323 0.239148

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll 35 0.239183

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll 28 0.239211

4 ETW000 [dev trc ,00000] New connection 0 created 5468 0.244679

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 140 0.244819

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 37 0.244856

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 18 0.244874

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 48 0.244922

4 ETW000 [dev trc ,00000] Thread ID:6024 3841 0.248763

4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 24 0.248787

4 ETW000 [dev trc ,00000] Using dynamic link library 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000 34 0.248821

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 48 0.248869

4 ETW000 [dev trc ,00000] patchlevel 0 20 0.248889

4 ETW000 [dev trc ,00000] patchno 179 18 0.248907

4 ETW000 [dev trc ,00000] patchcomment A better db user check (832618) 22 0.248929

4 ETW000 [dev trc ,00000] Network connection used from IBGPRD to IBGPRDN using tcp:IBGPRDN 149 0.249078

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'prd' 21 0.249099

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 20821 0.269920

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 159 0.270079

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 75280 0.345359

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 514 0.345873

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 23 0.345896

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 110 0.346006

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.346025

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 4024 0.350049

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 131 0.350180

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 4198 0.354378

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 48 0.354426

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.354445

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 97 0.354542

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.354561

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 11151 0.365712

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 104 0.365816

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 4356 0.370172

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 48 0.370220

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.370239

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 96 0.370335

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.370354

4 ETW000 [dev trc ,00000] failed to establish conn to tcp:IBGPRDN. 10895 0.381249

4 ETW000 [dev trc ,00000] Retrying without protocol specifier: IBGPRDN 38 0.381287

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 68 0.381355

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 91 0.381446

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 6422 0.387868

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 48 0.387916

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.387935

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 96 0.388031

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.388050

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 8871 0.396921

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 118 0.397039

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 5562 0.402601

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 48 0.402649

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.402668

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 115 0.402783

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.402802

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 9737 0.412539

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 132 0.412671

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 23839. hr: 0x8000ffff Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 5468 0.418139

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 18452, sev 0), Login failed for user ''. The user is not associated with a trusted SQL Server connection.

4 ETW000 47 0.418186

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.418205

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 101 0.418306

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 19 0.418325

4 ETW000 [dev trc ,00000] failed to establish conn. 0 9785 0.428110

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error -1 performing CON [dblink#8 @ 433] 20848 0.448958

4 ETW000 [dblink ,00433] ***LOG BY0=>Login failed for user ''. The user is not associated with a trusted SQL Server connection. [dblink#8 @ 433]

4 ETW000 36 0.448994

2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'IBGPRDN' DBNAME = 'PRD'"

Former Member
0 Kudos

Hello,

You need change the password on all servers, use the same password for SAPService<SID> on each server. Please check the authentication type on MS SQL Server, Change to "NT authentification" and test it again.

Cristian

manoj_nayak2
Participant
0 Kudos

Thanks to everyone.

Answers (0)