Hi,
I am facing a problem accessing SQL Server using WindowsAuthentication. One
Sharepoint application development team need a webpart to access one SQL
Server Database using a service account (Windows Authentication). Due to
company policy, SQL authentication is not allowed. When a user uses the web
page with the Webpart, it should connect to the Database using this Windows
Service Account and pull the data for display. When the connection string is
composed with Windows Authentication with Windows Authentication, access
denied error pops up. Any work around for any user to use this Windows
Account to access the database for any logged in user ? Thanks
Suhas