using NT logon information

[zootz]

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?

[Lothar Haensler]

can't you use a "trusted connection" via the /E switch in ISQL?
That way you don't need username OR password.

[zootz]

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.

[Lothar Haensler]

with SQL server's integrated security mode this shouldn't be a problem.
Just GRANT or REVOKE the permissions for the given users.