do you standard users and password solman 4.0

[Former Member]

dear friends,

system: solman 4.0

database: microsoft SQL server 2005

do you standard users and password solman 4.0.

i m not able to log to system ..

i also tried DDIC and SAP* from 000,800..

do you know any other user of solman .. and it's password..

please give me solution..

thanks

zaheer

[jon_friesen2]

Hi Zaheer,

I don't have a SQL Server in front of me but there should be able to connect using SQL Management Studio. Within the SQL Management Studio there should be something like a "New Query" button which will give you an editor for entering the SQL command to delete the user.

Jon

[Former Member]

Hi,

it is a newly installed system? or you forgotten the sap* passowrd

we can try sap* with the password "PASS".But for that you need to carefully delete it at the database level.

the statment somewhat look like

delete USR02 where UNAME = 'SAP*' and MANDT='000'

, since the table, USR02, which is the one that keeps the passwords.

After this, you will be able to log on as SAP* again with password PASS.

Thanks,

Jansi

[Former Member]

dear friend jansi,

i know the delete procedure from command prompt but this is installed on MS SQL SERVER 2005.. and i m not ble to connect MS SQL SERVER from command prompt..

do you know how to connect from command promt or any other ways to connect to databse only for delete SAP* purpose.

thanks

zaheer