473,320 Members | 1,858 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.

ASPNET user

Hi,

I'm having trougble connecting a web application to SQL Server. The
connection string, "Provider=SQLOLEDB;Data Source=MYSERVER;Initial
Catalog=MYDB;" Integrated Security=SSPI;" seems to be fine.

I get an error message of:
System.Data.OleDb.OleDbException: Cannot open database requested in
login.

The IUSR account has logon rights to the the DB, and necessary exec
rights on the relevent stored procedures. I was reading that ASP.NET
uses an ASPNET account, but this account was not installed on my
server.
I've tried to modify the web.config to allow impersonation, so that
ASP.NET would act as if it were IUSR, but that doesn't work either.
<identity impersonate="true" />

I know there's a simple solution out there, with so many SQL servers
talking to ADO.NET, but it escapes me.

Thanks in advance,
John
Jul 21 '05 #1
4 1369
I'm having almost exactly the same problem! For some reason my ASPNET account doesn't show up on my windows 2000 server when I install the .Net framework

Please help us!!!
Thank

See string: ASPNET user or group not created!
Jul 21 '05 #2
I'm having almost exactly the same problem! For some reason my ASPNET account doesn't show up on my windows 2000 server when I install the .Net framework

Please help us!!!
Thank

See string: ASPNET user or group not created!
Jul 21 '05 #3
I found the answer to this. It seems that the .Net framework 1.1 no
longer has an ASPNET user, and works through the IWAM_Servername
account.
Jul 21 '05 #4
I found the answer to this. It seems that the .Net framework 1.1 no
longer has an ASPNET user, and works through the IWAM_Servername
account.
Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Matt Calhoon | last post by:
Hi there, I have specified a aspnet user account to run all .net sites. This account needs access to start a .BAT File (in my global.asax on session start the app needs to execute this bat...
2
by: Andrew J Fortune | last post by:
Hello all, I am trying to ascertain the difference, in terms of access and privileges, between the Internet Guest User Account (IUSR_machinename, where machinename is the name of your computer)...
6
by: Matthew Wieder | last post by:
I have an ASPNET app that is running as the ASPNET machine user. It makes a call to the API CreateProcessWithLogonW. On Windows XP it executes without a problem, but on Windows 2000, I get an...
3
by: Harry Simpson | last post by:
Windows Server 2003 is supposed to include Framework 1.1 right. I don't have it here but have reports that the web is not running. The users say that the %COMPUTERNAME%\ASPNET user doesn't exist....
3
by: Jiho Han | last post by:
Should ASPNET user belong to the local Users group? I may have made some changes that affected my workstation setup and I am experiencing some unexpected behaviors. For example, I have my IIS...
0
by: John Holmes | last post by:
I saw a post in October that related to the problem I'm having and posted something yesterday but never saw it show up, so I'll try again. I read secnet.pdf and gathered from that document that one...
3
by: Kim | last post by:
After installing MSDE2000 on my WIN XP machine, I created the database from Access using the upsizing wizard. Although the tables can be seen from the server explorer, I keep on encountering...
7
by: SK | last post by:
Hi, Would appreciate if anyone could help me on this. Basically my client having few branches across state. And they used Citrix in which to connect to the server side for accessing application...
6
by: Andrew Chalk | last post by:
My application attempts to connect to an SQL Server database as name ASPNET and Login Name SERVERNAME/ASPNET in response to these commands: SqlConnection myConnection = new SqlConnection("Data...
7
by: torus | last post by:
Is the aspnet account called "aspnet" for all non-English versions of Windows and IIS?
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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.