I cant login to sap 9.2 since i change SQL password

[Former Member]

Dear support

yesterday i failed to login to sap 9.2 so i changed the SQL password since that time i cant find the data as well as i cant login

how i can fix this issue ?

[Former Member]

Dear Luis

really i appreciate your replay,but i new for SAP world

if you say Changed the tag to SAP Business One that mean

warm regards

muhannad

[Former Member]

Dear Sajid

i appreciate your replay but im still confused while im new for sql and SAP as well

[agustin_marcoscividanes]

Hi

connect to SLD portal, and change the configuration data for your databases connection.

Kind regards

Agustín Marcos Cividanes

[kothandaraman_nagarajan]

Hi,

Please esclate to SAP support to fix this issue.

Regards,

Nagarajan

[Former Member]

Currently this is our situation. We change the sql credentials, but when we restart the SAP Server we received SLD connection failed when opening SAP Client. When we login to SLD, the website says SLD is not started. But when we go back the old password, it can login successfully. But we don't want to reinstall the Server Tools. Is there any other way?

[former_member312729]

Try to run latest sql native client on server , restart the SAP and Sql related service and try to connect the SLD.

Regards:

Balaji.S

[former_member312729]

Refer Note:

1882731 - Cannot Display Company List After Database User Password Is Changed

Regards:

Balaji.S

[BattleshipCobra]

Are you able to connect to the ControlCenter? You should be able to login there with your B1SiteUser password and reconnect the main SQL server.

[Former Member]

Hi,

Muhannad

At last i suggest you that reinstall your SQL and SAP carefully

Thanks

[gaurav_bali]

Hi Muhannad

Please follow following steps.

For SLD

1) Open your browser on server and enter following URl

https://<Inert server name or IP>:30010/ControlCenter/

2) Enter B1siteuser and password to login.

3) Under Servers and Companies tab. Click your server name and click edit.

4) Provide new database user password in the respective field.

click OK and restart the server.

For RSP

1) Open RSP > Configuration > Databases > enter database password in respective field.

[Former Member]

my friend

if I forget the password for sap then change the SQL password how I can follow your steps

[gaurav_bali]

Hi Muhannad

The password for B1siteuser can be changed in Control center.

1. Open SAP Business One Server Manager

2. From the Drop down list choose License manager

3. Click on Settings >Configure Security

4. Click on Change Site password

5. Enter the details with new password for B1SiteUser

Or as Girish Patil mentioned reinstall the SAP Carefully

[Former Member]

Select this Service ------ Double Click ----> Select Startup Type ..........> Automatic ----------------> Apply and then again restart that service

[Former Member]

same thing I cant start this services

[Former Member]

Are you sure you keep startup type Automatic

plz check your service startup type Automatic and Automatic(Delay)

i sending you attachment see this and try to re

start this service

[Former Member]

yes I did

[Former Member]

Hi,

1. delete all files from temp folder Run------>%temp%

2. Firewall off

3. Antivirus Disable

4 .Restart your services(TAO NT, SLD, License Manager) keep them Automatic

5. Start license manager...............

Follow this step i am sure that your problem is solve after this steps

Thanks

[Former Member]

Dear Girish

all thanks but when I restart this serves its not start propyl

best regards

[kothandaraman_nagarajan]

Hi,

Please disable anti-virus and Windows firewall and then try. If not working advice your OS.

Regards,

Nagarajan