Visit our Google Group Way 2 SAP BASIS

Unable to login into 800 client

Forum where general Basis related topics are discussed.

Moderators: BASIS24x7, Rashed

Unable to login into 800 client

Postby scorpian »

Hi
I installed ecc6 ides on my home desktop. now the problem is that i am unable to login into the default 800 client with sap* user id. earlier when i created a new client and when i am unable to login, i changed the parameter login/no_automatic_user_sapstar by default this value is 1 and I set it to 0 in 000 client . Can anyone help me in this regard.
scorpian
 
Posts: 18

Re: Unable to login into 800 client

Postby ratnakar606 »

Hello Scorpian ,

Could u please tell me the error message what it is prompting while entering the user id and password.

With Kind Regards

Ratnakar gurugubelli
ratnakar606
 
Posts: 5

Re: Unable to login into 800 client

Postby srikant »

IN ides CLIENT 800 WOULD BE HAVING THE DUMMY DATA. WHICH USER YOU ARE TRYING TO LOGIN WITH, WE CAN RESET THE SAP* USER FROM ORACLE DATABASE DIRECTLY
srikant
 
Posts: 12

Re: Unable to login into 800 client

Postby scorpian »

Hi srikanth!!!
Thnks for the reply. can u tell me the procedure for resetting the sap* user from oracle database directly.
scorpian
 
Posts: 18

Re: Unable to login into 800 client

Postby zamu84 »

Hello Scorpian

to reset the password

u have to login as a dba admin into the database and from there u can execute
this command

>delete from sapr3.usr02 where bname='SAP*' and mandt='000'

correct me if i am wrong

Regards
Zamu
zamu84
 
Posts: 1

Re: Unable to login into 800 client

Postby hussaini »

hi zamu

u gave the command

>delete from sapr3.usr02 where bname='SAP*' and mandt='000'

in which the database schema is wrong it should b sapsr3

delete from sapsr3.usr02 where bname='SAP*' and mandt='000'
Regards,
Syed Hussaini.
SAP BASIS Consultant
Terrenos Software Technologies Pvt (Ltd).
hussaini
 
Posts: 72

Re: Unable to login into 800 client

Postby scorpian »

hi hussain!!!
i tried with the command tht u mention here. but itz showing the message tht particular table or view doesnt exist. is there any other way to reset the password. if possible plz send at sap level rather than at os level


regards,
scorpian
scorpian
 
Posts: 18

Re: Unable to login into 800 client

Postby chakrishroff »

Hi Scorpian,
Table USR02 must exist in the database. May be the schema you are using is wrong. by default the system creates schema by the name SAPSR3. if you have not changed this schema name at the time of installation then what you have used is correct. try using the same command in upper case.
also SAP* should be in upper case.
chakrishroff
 
Posts: 8

Re: Unable to login into 800 client

Postby saleemzm »


hello friends i am your junear right kow i am learning BASIS .AND ALL THE BEST ALLOFF U U WILL BE IN GOOD POSITION THANKU
saleemzm
 
Posts: 1


Return to General Basis Forum

Who is online

Users browsing this forum: No registered users and 0 guests

Visit our Google Group Way 2 SAP BASIS
cron