Internal Web Portals - Use user logon NetworkCredentials

Toddy_Boy

We have started to write a few web based portals interfacing with Navision and other applications and services.

To develop the portal I've used the following credentials statement where username and password are known and stored in a config file (the same super user credentials that run the middle tier service).

objWSClass.Credentials = New Net.NetworkCredential(strUserName, strPassword, strDomain)

I'd like to move away from this and use the users network logon username and password credentials? I've tried setting the portal site to Basic Authentication and replaced the above with the following without success

objWSClass.UseDefaultCredentials = True

I get prompted for the logon details but then the site throws the following error which I assume the credentials are not super enough to run the service.

"The login failed when connecting to SQL Server sqlservername."

Any ideas how I achieve this, looking at it I'm trying to replicate the RTC logon

Steve