SAPSID User Password Change Problem

[Former Member]

Hi Gurus,

I have a test SRM System which was installed long time ago (using SAP DB). I forgot the password of SAP<SID>, so I changed its password in Database Manager GUI with SAP Instance offline. After that, I can log in SAP DB with SQL Studio with SAP<SID> user.

When I tried to restart the system, error came up showing that the SAP<SID> user's password does not match (error -4008), so no successful access to SAP DB, work+dispatcher stopped.

I guess the SAP System is still using the old password to access to DB. But how can I change the old password into new one?

Thanks a lot in advance!

[Melanie · Accepted solution]

You'll need to adapt the xuser entries.

Check out notes 25591 and 39439.

Best regards,

Melanie

[Former Member · Accepted solution]

Hi Melanie,

thanks a lot for your answer!

Just read the notes you posted. When I use command "xuser list" I get no information. After I followed 39439 to create a new entry for user SAP<SID> (in my case SAPSRM), I get the following info:

Key :default

Username :SAPSRM

UsernameUCS2:S.A.P.S.R.M.........

Password :????????

PasswordUCS2:????????

Dbname :sapsrm

Sqlmode :<unspecified>

Cache limit :-1

Timeout

Isolation :-1

Charset :<unspecified>

But the old problem remains. Is there something wrong with the entried I created?

Thanks!

[markus_doehr2 · Accepted solution]

> Just read the notes you posted. When I use command "xuser list" I get no information. After I followed 39439 to create a new entry for user SAP<SID> (in my case SAPSRM), I get the following info:

Did you do that as <sid>adm user? is this Windows?

> Key :default

The key should be in capitals: DEFAULT

Markus

[Melanie · Accepted solution]

Hello!

In addition to Markus' answer and as specified in the note:

> Dbname :sapsrm

should be the database name (SID) - seems to be SRM.

> Sqlmode :<unspecified>

Should be SAPR3

> Cache limit :-1

OK

> Timeout

OK

> Isolation :-1

Should be 0

And I'm missing

Nodename : <database hostname>

in your list...

After adapting the entries try again.

Furthermore you have to set these entries for the OS user, who runs the SAP system. As you didn't have any user entries before, it sounds like you are using the wrong user for creating the XUSER data...

Regards,

Melanie

[Former Member · Accepted solution]

Hello Markus,

yes, the OS is windows 2000NT and did it administrator who has installed the SAP System.

The key is in uppercase, but I typed it as lowercase, sorry for confusing...

Thanks!

Hello Melanie,

sorry the DBname is SRM and I missed the nodename, it is sapsrm.

After I had changed the isolation to 0 and SQL mode to SAPR3, I tried again, but still failed.

I am also wondering why there was no xuser information before, but I still could start the SRM system without any problem, but not after I changed the password of SAPSRM...

Thanks&Best Regards,

Deming

Edited by: He Deming on Feb 3, 2009 11:29 AM

[Melanie · Accepted solution]

Hello,

the system probably runs as SAPServiceSRM user.

You'll have to adapt the XUSER entries for that OS user!

Regards,

Melanie