Forum Replies Created

Viewing 15 posts - 481 through 495 (of 6,105 total)

  • RE: Password Encryption

    ankur_libra (8/26/2009)


    Thanks Mr. Steve Jones and Mr. K. Brian kelly for your valuable responses.

    Can you please explain more about Rainbow tables? This is the first time i have heared of...

  • RE: Can you have multiple logins pointing to a dbo user

    Is there a reason why you don't just reset Ted's password?

  • RE: SQL 2005 Service Accounts / Windows Groups

    Jeffrey Williams (8/25/2009)


    I am in the process of implementing a four-node PolyServe cluster. What I have found is that the installation in PolyServe is not the same as MSCS...

  • RE: SQL 2005 Service Accounts / Windows Groups

    Inside SQL Server, these groups are given permissions. On the OS, these groups have permissions to the file directories. I'm sure PolyServe has some way of handling it, because of...

  • RE: System dsn connection to SQL server 2008

    SQLdba (8/25/2009)


    But only demand is we should use otherdomain\serviceaccount to connect to sql server.

    What type of app is it? If it's a web application, say ASP.NET-based, you can specify...

  • RE: System dsn connection to SQL server 2008

    No, any DSN will have this issue. Are the user accounts in a trusted domain compared to the server where SQL Server is installed? You'll need to verify this with...

  • RE: Create Credencial for windows login without set password

    You can create the credential, but that requires SQL Server to store the password in an encrypted format. With respect to Profiler or traces, the command will be obscured by...

  • RE: Password Encryption

    For #1, yes, via brute force for sure. While it is theoretically possible that a decryption algorithm may be found, usually it's typical for researchers to instead focus on finding...

  • RE: decrypt sql server 2005 sp

    I'm assuming you checked to verify SQL Browser was running. If it is, check the error log to see what port it says it is starting DAC up on. Then...

  • RE: decrypt sql server 2005 sp

    Lowell (8/25/2009)


    Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on...

  • RE: decrypt sql server 2005 sp

    You can find an algorithm that works in the August 2007 issue of SQL Server Magazine. There's not a need to purchase anything (except maybe access to the SQLMag.com site).

  • RE: System dsn connection to SQL server 2008

    Then that means there is a trust relationship, which is why your system administrator is insisting on Windows authentication. However, when you configure a System DSN, it's going to use...

  • RE: System dsn connection to SQL server 2008

    You can make a connection from the system in question using Windows authentication? Or are you connecting from your workstation/laptop and not the server in question?

    If the computer attempting...

  • RE: Deny OR Revoke "Drop object" Permission

    You also have to worry about ALTER TABLE. Here I explain the issue and why the DDL trigger works:

    Granting limited permissions to create views in another schema in SQL Server...

  • RE: Password Encryption

    You shouldn't be storing passwords using an algorithm which allows for the encryption to be reversed (for the passwords to be decrypted). Rather, you should be using a hash function....

Viewing 15 posts - 481 through 495 (of 6,105 total)