Post reply

SA password?

  • July 29, 2003 at 5:45 am

    #101596

    We have application need Sa password to login, so what is best if we using pwdencrpt() function encrpt in column, and how we decrpt them out of table? If there is way decrpt out can VB application code password in connection string will see the password, We do not like someone if debug the code then find SA password. Any help will be appreciate.

    feifei liu


    Rachel

  • July 29, 2003 at 5:52 am

    #467442

    Oooooh.

    Is there any way of NOT using the sa password for the application? Or, is this one of those 3rd party apps where you're given no choice?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • July 30, 2003 at 1:20 pm

    #467827

    If it is not possible to modify the VB program to use a different account, then you can modify the sa account to something other than system admin, depending upon what the program actually needs access to.

  • July 30, 2003 at 2:09 pm

    #467840

    SQL Server does not offer a decrypt function, You can only use PWDCOMPARE to compare a plaintext password to an encrypted value

    Shas3

  • July 30, 2003 at 3:04 pm

    #467854

    I don't think you can modify sa'a sysadmin privilege

    Cheers,

    - Mark


    Cheers,
    - Mark

Viewing 5 posts - 1 through 4 (of 4 total)

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