situation we lose all our work which previously did in local DB.
To overcome this kind of problem there is simple below tip to reset local DB user password.
1. Go to Siebel tool installdir like c:\siebel\8.1\tools_1\bin and open dbisqlc.exe as shown in below
2. Enter Userid as “DBA” and password “your enterprise name” like CRMDEV81
3. Go database tab and select your local dbf file like below..
4. Click OK
5. Interactive sql window open saying connected to database.
6. Execute following query to reset password of userid “TEST”.
grant connect to TEST identified by PASSWORD
NOTE-Here PASSWORD is your new password and userid and password is in caps only.
good one!!
ReplyDeleteIf the password is not working .. Then What are things i need to check . My EnterPrise name is DEV i have provided DEV12345 still it is not working , so what will be the solution ?
ReplyDeleteI get the below error when I try to reset my local db password using below command : ---------------------------
ReplyDeletegrant connect to DEMO.USER identified by DEMO.USER
Interactive SQL
---------------------------
Error at line 1
Syntax error near '.' on line 1
---------------------------
OK
---------------------------
I think that you need to enclose name and password into quotas in this case.
DeleteSQLServer USERNAME and PASSWORD alphas are all CAPS; Enterprise Name must be at least 8 characters in length as PASSWORD, if not 1234 must be added to reach 8, thus SBL_82 would be SBL_8212.
ReplyDelete