By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,591 Members | 629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,591 IT Pros & Developers. It's quick & easy.

Problem Accessing SQL Database

P: n/a
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

Nov 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 17 '05 #2

P: n/a
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
"Abdellah Elamiri" wrote:
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

Nov 17 '05 #3

P: n/a
> 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/de...onateTopic.asp

Greetings,
Wessel
Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.