cancel
Showing results for 
Search instead for 
Did you mean: 

Problem of SAP* user in New Client

Former Member
0 Kudos

Dear All,

My platform is

O/S : Windows 2003

SAP Ver. : ECC 6

Database : Oracle 10g

After installation of sap I have created new client say 300. After creating for client copy I tried

to login in client 300 using SAP* user and password PASS, it gives invalid password message.

I have search on internet and in some forum it is suggested that set the parameter

"login/no_automatic_user_sapstar" to 0 in instance profile and restart the SAP and recreate client.

I have set the same, restart SAP and recreate client but the problem remains same.

I have also tried with "login/no_automatic_user_sapstar" by value 1.

I request you all to please give me reason and solotion for the same.

Thanks in advance

Nirav

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

try password "pass" in lowercase....

Former Member
0 Kudos

No it is not working.

There is no record related to new client in usr02 table.

Syamkriz
Active Participant
0 Kudos

select * from usr02 where bname='SAP*'

select * from usr02 where mandt='300'

It shows records related to 000,001 and 066 clinets. There is record related to new client 300 in this table.

Have you assigned logical client while creating the client 300?

Regards

Syam

Edited by: Syam on Jan 28, 2009 7:11 AM

Former Member
0 Kudos

Dear Syam,

Sorry. It was typing mistak.

select * from usr02 where bname='SAP*'

select * from usr02 where mandt='300'

There is no record related to new client 300 in this table.

markus_doehr2
Active Contributor
0 Kudos

If there is no entry for SAP* in USR02 then you MUST be able to logon with SAP* and "pass".

Please logon to another client, start RZ11 and check if login/no_automatic_user_sapstar is set to "0".

Markus

Former Member
0 Kudos

Thanks for your reply.

I have check the value of login/no_automatic_user_sapstar by RZ11.

It is set to 1. Not 0.

Why it is like this? I have set "login/no_automatic_user_sapstar =0" in

F:\usr\sap\DVL\SYS\profile\DVL_DVEBMGS00_rlsdev profile and restart the server.

How to change this value?

When I have tried RZ10, and press F4 key, it shows "No profile found"

Nirav

Syamkriz
Active Participant
0 Kudos

Hi Nirav,

When I have tried RZ10, and press F4 key, it shows "No profile found"

Make sure that there the profile exist at operating system level.Then logon to SAP ,go to RZ10->Utilities->Import profile->Of active servers.

There is no record related to new client 300 in this table.

I understood the typing mistake:)If you have not assigned Logical system during the creating of client 300,then you may face this problem.You may also face this problem if you did not restart SAP after creating the client.Let us know the result please.

Warm Regards,

Syam

Former Member
0 Kudos

Dear ,

First of all import the profile ....

usr\sap\<SID>\SYS\profile\<SID>_DVEBMGS00

then change the parameter .

then restart the server .....

check the value through RZ11 and also profile version....check that it should be updated.ok

then try with PASS ok

it will work

Cheers

Anuj

Former Member
0 Kudos

Hi Syam,

After importing the profiles please make an entry of parameter in defaul profile and it will solve the problem.

login/no_automatic_user_sapstar =0"

Cheers

Deepanshu

Former Member
0 Kudos

Thanks to everyone.

My problem is solved.

I have import the profile.

Thanking you all ones again

Former Member
0 Kudos

Hi Nirav,

If you think you got help award the necessary point.

This improves the SDN Community to grow.

Cheers

Deepanshu

Answers (1)

Answers (1)

former_member185031
Active Contributor
0 Kudos

Hello Nirav,

"login/no_automatic_user_sapstar" should be 0 only to login into new client with PASS

So just restart your server and try to login again.

Regards,

Subhash

Former Member
0 Kudos

Thanks for your reply Subhash.

I have set login/no_automatic_user_sapstar to 0 but problem is not solved.

Thanks,

Nirav

Former Member
Former Member
0 Kudos

I have check with the following query at database level.

select * from usr02 where bname='SAP*'

select * from usr02 where mandt='300'

It shows records related to 000,001 and 066 clinets. There is record related to new client 300 in this table.

Thanks

Former Member
0 Kudos

Hi Nirav,

After setting parameter login/no_automatic_user_sapstar to 0 you should restart the SAP system to make the parameter effective.Unless it will not work.

Regards

Ashok

Former Member
0 Kudos

In my first message i have already mention related to parameter.

"I have search on internet and in some forum it is suggested that set the parameter

"login/no_automatic_user_sapstar" to 0 in instance profile and restart the SAP and recreate client.

I have set the same, restart SAP and recreate client but the problem remains same"

Thanks