Post reply

Can we copy the password for ''sa'' login?How to get it?

  • November 28, 2006 at 3:15 am

    #171104

    Hi Everybody,

    can we copy the password for 'sa' login through the enterprise manager?

    I have tried to copy the password as  enterprisemanager>server>security>logins>sa-Properties, but unable to copy.

    How to get the password for sa login?

    Any help would be assist to me.....

     

    Thanks In Advance,

  • November 28, 2006 at 3:57 am

    #674280

    Are you attempting to get the password for a login ?

    If so, then, no, you cannot copy the "password" displayed in Enterprise Manager.

    SQL Server passwords are encyrpted before being stored there is no decryption routine avilable. When connecting, the provided password is encyrpted and then compared to the stored encyrpted password.

    SQL = Scarcely Qualifies as a Language

  • November 28, 2006 at 4:03 am

    #674282

    So there is no way to the get the password for 'sa' login Right?

    Thanks,

  • November 28, 2006 at 4:20 am

    #674287

    I don't think there will be many DBAs telling you how to hack the 'sa' password on their boxes.

    if you're the DBA and you've forgotten the sa then i'm sure you can figure out how to use a local admin account to fix the problem.

    if you can't change the 'sa' password because apps are using it and these are hard coded then you can take it from the app code.... but how bad practice is that!!

    MVDBA

  • November 28, 2006 at 4:34 am

    #674294

    🙂

    Here,what my problem is i do not have priviliges to change the password and the pwd is different for the apps.

    This account is using by many reporting projects  if i change then it will be big problem.

    So there is no way to get from the apps.

    I have forgotten the pwd and now want to get back.Any other way?

    Thanks,

  • November 28, 2006 at 4:49 am

    #674296

    you may be able to get it from the connection string in the apps - depends on your app

    lesson learnt - never use SA account for your apps or reporting

    MVDBA

  • November 28, 2006 at 5:00 am

    #674298

    But i dont have background in the front end side?

    Could the pwd save in any other location while creating login?

     

    Thanks,

     

  • December 4, 2006 at 1:50 pm

    #675614

    This might be the opportunity you need to set up different users and passwords for the projects instead of using the standard System Administrator login which no one should have access to except a system administrator.

    Steve

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply