473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem Accessing SQL Database

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
3 1384
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
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
> 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jaydeep | last post by:
Hello, I am facing a strange problem. Problem accessing remote database from ASP using COM+ server application having VB components (ActiveX DLL) installed. Tier 1 : ASP front End (IIS 5.0) Tire...
0
by: Xerxes | last post by:
I am having a problem with accessing MySQL database from my PHP code. I tested accessing MySQL db locally and once things worked I created the same DB on my web hosting's server. No problem...
3
by: Jagdip Singh | last post by:
Hi, We are facing problem accessing to DB2. Seems like database manager is down I tried starting it using db2start but it was neither showing any messages nor returning to command prompt...
3
by: prodirect | last post by:
Hi all, I hope someone can help me. I've recently created a database and wanted to put it up on an ftp sight so that multiple people could access the same tables at the same time from different...
9
by: zMisc | last post by:
When I try to update record, I kept getting this error: Row cannot be located for updating. Some values may have been changed since it was last read. No other users are accessing the database...
1
by: Jake Henderson | last post by:
I am developing apps in VWD Express and SQL Svr 2005 Express. I currently have a web server running Win2K3 SBS W/IIS V.6.0 & ASP.NET 2.0. I am currently using a test site that is only availible on...
8
by: supasnail | last post by:
I have a happily working set of asp pages which read from the database via include file "./_private/include/database.mdb". However, when I try to gain access to this database on pages one folder...
13
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
0
by: mitrofun63 | last post by:
Hello. On my production site i have DB2 9.1.2 database configured for archiving logs and making backup through TSM Data Protection for DB2 UDB The LOGARCHMETH1 parameter is set to ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.