Problem Accessing SQL Database

[Guest]

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

 

[Abdellah Elamiri]

You need to make sure that the account ASP.NET is running under has
access to the database. Check out this quick article for info
http://www.devx.com/security/Article/20898/0/page/4

Regards,

Abdellah Elamiri

 

[Guest]

Hi,

Thanks for the providing the help. I would like to know whether it is
possible to execute only one block of code using Windows Authentication - I
mean with the service account ? I am not sure whether the existing settings
for ASP.NET account will be allowed to change.

Thanks
Suhas

 

[Wessel Troost]

Thanks for the providing the help. I would like to know whether it is

possible to execute only one block of code using Windows Authentication
- I
mean with the service account ? I am not sure whether the existing
settings
for ASP.NET account will be allowed to change.

That is possible (though not easy) with impersonation. According to the
documentation it works properly on Windows XP or 2003, but doesn't work on
Windows 2000.

See the following linkg for more details:
http://msdn.microsoft.com/library/d...cipalWindowsIdentityClassImpersonateTopic.asp

Greetings,
Wessel