Critical System Protection

 View Only
Expand all | Collapse all

Unable to login to CSP

  • 1.  Unable to login to CSP

    Posted Apr 11, 2014 08:26 AM

    After installing CSP server and the console (6.0) on the same server,Tred to login using

    user name : sysadmin

    Password :

    Got the Verify Server Certificate panel  then after verified it There is no prompt to reset new password.

    If try to login with blank password  getting the below message

    "Login Failed. SDCSS could not log you on. Make sure your user name and password are correct, and that your System Administrator has given you permission to use this application."

    Please advice

     

     

    Thanks.



  • 2.  RE: Unable to login to CSP

    Posted Apr 11, 2014 08:38 AM

    Hello Sankara,

    Please reset password as per below thread and igorprint's comments

    https://www-secure.symantec.com/connect/forums/symantec-critical-system-protection-reset-password-console#comment-8853901



  • 3.  RE: Unable to login to CSP

    Posted Apr 11, 2014 09:16 AM

    Thanks James,

    I checked the thread you referred

    And it is suggeing the below as a solution.

    update dbo.USR set PWD = ' ' where USERNAME = 'symadmin'

    Do you have any idea on how to perform this in SQL server 2012?

     

    Thanks



  • 4.  RE: Unable to login to CSP

    Broadcom Employee
    Posted Apr 11, 2014 09:23 AM

    can you login into SQL management studio and then execute the command.

     

    Also check if the SQL services are running while login?

     



  • 5.  RE: Unable to login to CSP

    Posted Apr 11, 2014 09:28 AM

    Hi Pete,

    I could login to my SQL Management studio. and i would like to know on how to perform this script what you are suggesting.

    Do you have details in doing step by step?



  • 6.  RE: Unable to login to CSP

    Broadcom Employee
    Posted Apr 11, 2014 09:37 AM

    select the SCSP database and run the query. I do not have pictures.



  • 7.  RE: Unable to login to CSP

    Posted Apr 11, 2014 09:57 AM

    try symadmin

     

    not sysadmin



  • 8.  RE: Unable to login to CSP

    Broadcom Employee
    Posted Apr 11, 2014 10:00 AM

    ahh. yes you should be using symadmin

    great find Will :-)



  • 9.  RE: Unable to login to CSP

    Posted Apr 11, 2014 10:28 AM

    My bad time..It still not working even with "symadmin"

     

    I appreciate any more help with in detail steps about performing that changes in SQL

     

     

    Thanks



  • 10.  RE: Unable to login to CSP

    Posted Apr 11, 2014 10:49 AM

    Start the console as administrator (??)

    grasping at anything right now



  • 11.  RE: Unable to login to CSP

    Posted Apr 11, 2014 12:30 PM

    Use the OSQL.exe commandline utility:

    load up commandline, navigate to osql.exe and run that (just search for osql but you dont need studio installed, just the client tools.)

    osql -S database\instance -U username -P password 

    ^ - sa credentials or your domain credentials and capital letters are important for the switches

    then just copy and paste that SQL statement mentioned previously and press enter to get onto next line

    then type go and press enter

    That should then run the statement

     

     

     



  • 12.  RE: Unable to login to CSP
    Best Answer

    Posted Apr 14, 2014 09:57 AM

    I tried to run OSQL.exe  to check execute the  below

    osql -S database\instance -U username -P password  - but it failed

    I uninstalled DCS and deleted the users created in SQL server then reinstalled DCS - Login was not successfuly

     

    Then we found that...in SQL we dont't see the USER NAME row under the tables..

    so i created new instance in SQL for SDCSS

    Uninstalled DCS server and console

    Reinstalled DCS and pointed to the new instance SDCSS then it worked fine...

     

     

    Thanks for all your inputs and ideas..