SQL secure connection passed to user web app

[jrcanfer]

How would I go about the following;

The ability to have an interface connect to a WebService on IIS which in turn connects to the SQL Database and for the Users interface security credentials to be carried through to the SQL Database.

This is so the SQL Database will know who is logging on via a Trusted Connection.

Setting up a trusted connection to SQL on our internal LAN seems easy enough, it's when the users are coming in across the web via a web app that my knowledge gets squeezed!

Thanks in advance.

 

[mrdenny]

Setup the web server to use SSL (https). Set the authentication to clear text (don't worry about the warning, the username and password will be protected by the SSL). Now when they log in with there domain username and password the web server can pass that into to the SQL Server.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[jrcanfer]

Close - but it has helped me explain the problem more clearly.

What we have is a VB .NET application which uses a connection string to connect to the web server.

We've got a "Who am I" button in the program to test the connection and to make sure the user credentials are getting through - unfortunately they are not!

Needless to say if we go straight to the https page after I set it up in the manner mrdenny explained, it works. It's getting the app to work that's the prob.

Any other ideas?

Thanks!