Re: Pass in NT Username and Password for connection

From: chris (christian.eyrich@epost.de)
Date: 06/02/02


From: "chris" <christian.eyrich@epost.de>
Date: Sun, 2 Jun 2002 21:31:09 +0200


> I want to use only NT Authentication in SQL Server, but
> when the NT user don't have permission to execute the
> command, I want to display a message box in the
> application and allow a NT User with the appropriate
> permission to make the connection to the server. I would
> not want to log on as a different user.

I do not know your system, but you can use "SU" from the
resource kit for NT4 or if you have Win2000 the command "runas".
The user do not have to log off and log on, he can then
run the application with the new user credentials.

bye
chris



Relevant Pages