using NT logon information
Is there a way to extract a decrypted password from the registry using VB? I have gotten the username sucessfully using an API, but I need to get both NT username and password to pass to an ISQL script in order to log into the other server. Any ideas?
Re: using NT logon information
can't you use a "trusted connection" via the /E switch in ISQL?
That way you don't need username OR password.
Re: using NT logon information
THat would be great, but I need to make sure that the user is allowed to be accessing the data, and only certain NT users are allowed.
Re: using NT logon information
with SQL server's integrated security mode this shouldn't be a problem.
Just GRANT or REVOKE the permissions for the given users.