Anyone know how to dig into NT to get the username password information (I am an NT administrator, so I have the rights) cos I want to pass the information off to SQL Server to set a shadow username, don't ask why.
Cheers,
P.
Printable View
Anyone know how to dig into NT to get the username password information (I am an NT administrator, so I have the rights) cos I want to pass the information off to SQL Server to set a shadow username, don't ask why.
Cheers,
P.
You can not do this. Even an administrator does not have the right to view other peoples passwords. He only has the right to change them.
NT offers NO function (API or whatever) to retrieve a password.
However, you can use NT security with SQL Server.
A connection string would look like this:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=YourDatabase;Data Source=YourServerName
Thanks for the reply, but what I was after was a bolt on to NT to allow the setting of a SQL Server password at the same time as the password was set for the Domain.
For reasons too complex to go into, I cannot use integrated security.
Thanks anyway.
P.