Using an alternative account for windows authentication with a datasource, possible?

[darkgen]

I need to use a specific windows account in order authentication works across multiple environments including use of that account to connect to a sql data source. For security reasons I can understand why the trust method operates under the user context only but I was wondering whether another means or method exists which allows hard coding a specific set of windows credentials to access sql data sources, with encryption etc. Unfortunately creating a sql user account in this instance isn't a possibility.

Cheers, Paul.

 

[RockLobster]

ASP.NET? In the past I've used identity impersonation.