473,326 Members | 2,102 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,326 software developers and data experts.

ASPNET Projects and SQL Server

I created a walkthrough and couldn't connect to my sql server. I looked up
the problem and MSDN told me to create an ASPNET "User" in SQL Svr.

It worked, but is that right? Do I have to do that for web projects. How
does that user relate to the other users? I'm not seeing the logic. I
thought maybe a "Role" that I could assign all users to would make more
sense, but why have an ASPNET in SQL at all?

--
MichaelM
May 24 '07 #1
5 1601

"Michael Miller" <Mi***********@discussions.microsoft.comwrote in message
news:EE**********************************@microsof t.com...
>I created a walkthrough and couldn't connect to my sql server. I looked up
the problem and MSDN told me to create an ASPNET "User" in SQL Svr.

It worked, but is that right? Do I have to do that for web projects. How
does that user relate to the other users? I'm not seeing the logic. I
thought maybe a "Role" that I could assign all users to would make more
sense, but why have an ASPNET in SQL at all?
>
http://www.google.com/search?hl=en&q...er&btnG=Search

May 24 '07 #2
Thanks for the quick reply.
I checked out my config and took note that under docs and settings there was
my machine name and under that was ASPNET. Was that created when I
'installed' vs and regiis, etc?

In the article you referenced, in the statement:
"7. Click the General tab. In the name field, enter the name of the ASP.NET
user.
By default, this is a local account with the name ASPNET."

Do they mean that <machinename>\ASPNET under my docs and settings?
My machine name is one of the users under docs and settings.

I am just not understanding these relationships. If my install of IIS and
VS created this, then I understand. But, then there was stuff for (when I
created) my VS projects located under docs and settings also, plus under my
documents, Visual Studio Projects.

I will continue to read the learning areas, but maybe you can brief me?
I am starting from scratch (with some experience in VB6 and SQL) and want to
know what MS does with folders for both windows and aspnet projects.

--
MichaelM
"Mr. Arnold" wrote:
>
"Michael Miller" <Mi***********@discussions.microsoft.comwrote in message
news:EE**********************************@microsof t.com...
I created a walkthrough and couldn't connect to my sql server. I looked up
the problem and MSDN told me to create an ASPNET "User" in SQL Svr.

It worked, but is that right? Do I have to do that for web projects. How
does that user relate to the other users? I'm not seeing the logic. I
thought maybe a "Role" that I could assign all users to would make more
sense, but why have an ASPNET in SQL at all?
http://www.google.com/search?hl=en&q...er&btnG=Search

May 24 '07 #3
I forgot to tell you that I am currently using VS 2003 and SQL 2000, but will
be also working in VS 2005 and SQL 2005 as soon as I finish their installs.
I'll check to see if the article fits SQL 2005, and Framework 2.0 as well.
It states its for SQL 2000 and FW 1.1.
--
MichaelM
"Mr. Arnold" wrote:
>
"Michael Miller" <Mi***********@discussions.microsoft.comwrote in message
news:EE**********************************@microsof t.com...
I created a walkthrough and couldn't connect to my sql server. I looked up
the problem and MSDN told me to create an ASPNET "User" in SQL Svr.

It worked, but is that right? Do I have to do that for web projects. How
does that user relate to the other users? I'm not seeing the logic. I
thought maybe a "Role" that I could assign all users to would make more
sense, but why have an ASPNET in SQL at all?
http://www.google.com/search?hl=en&q...er&btnG=Search

May 24 '07 #4

"Michael Miller" <Mi***********@discussions.microsoft.comwrote in message
news:D4**********************************@microsof t.com...
Thanks for the quick reply.
I checked out my config and took note that under docs and settings there
was
my machine name and under that was ASPNET. Was that created when I
'installed' vs and regiis, etc?

In the article you referenced, in the statement:
"7. Click the General tab. In the name field, enter the name of the
ASP.NET
user.
By default, this is a local account with the name ASPNET."

Do they mean that <machinename>\ASPNET under my docs and settings?
My machine name is one of the users under docs and settings.
I don't know what you're talking about here.

You should not be concerned about it. You should just know that it's there
and that the ASPNET machine account must be used with an ASP.Net
application.
>
I am just not understanding these relationships. If my install of IIS and
VS created this, then I understand. But, then there was stuff for (when I
created) my VS projects located under docs and settings also, plus under
my
documents, Visual Studio Projects.
The .NetFramework 1.1 created that account when it was installed on the
machine. If you're using an Asp.Net solution that's accessing SQL server,
then the ASPNET machine account must be an account that has full access
rights to the database. If an ASPNET application is reading and writing
files locally, then the ASPNET machine account must be an account on a
directory that has rights to do it on the directory.

That's the condition for VS 2003 and .Net Framework 1.1 and an ASP.Net
solution that wants database or local file access.

I don't know what's being used with .NET Freamwork 2.0 and the ASPNET, but
for an ASP.NET application using the .NET Framework 1.1, then that ASPNET
machine account must be accounted for in the solution.


May 24 '07 #5
Thanks.
--
MichaelM
"Mr. Arnold" wrote:
>
"Michael Miller" <Mi***********@discussions.microsoft.comwrote in message
news:D4**********************************@microsof t.com...
Thanks for the quick reply.
I checked out my config and took note that under docs and settings there
was
my machine name and under that was ASPNET. Was that created when I
'installed' vs and regiis, etc?

In the article you referenced, in the statement:
"7. Click the General tab. In the name field, enter the name of the
ASP.NET
user.
By default, this is a local account with the name ASPNET."

Do they mean that <machinename>\ASPNET under my docs and settings?
My machine name is one of the users under docs and settings.

I don't know what you're talking about here.

You should not be concerned about it. You should just know that it's there
and that the ASPNET machine account must be used with an ASP.Net
application.

I am just not understanding these relationships. If my install of IIS and
VS created this, then I understand. But, then there was stuff for (when I
created) my VS projects located under docs and settings also, plus under
my
documents, Visual Studio Projects.

The .NetFramework 1.1 created that account when it was installed on the
machine. If you're using an Asp.Net solution that's accessing SQL server,
then the ASPNET machine account must be an account that has full access
rights to the database. If an ASPNET application is reading and writing
files locally, then the ASPNET machine account must be an account on a
directory that has rights to do it on the directory.

That's the condition for VS 2003 and .Net Framework 1.1 and an ASP.Net
solution that wants database or local file access.

I don't know what's being used with .NET Freamwork 2.0 and the ASPNET, but
for an ASP.NET application using the .NET Framework 1.1, then that ASPNET
machine account must be accounted for in the solution.


May 24 '07 #6

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

Similar topics

0
by: JP | last post by:
Is there a way to acess .NEt web projects though UNC path (aka network path)? Heres the situation: 1. Dont want to use FP Extentions 2. Can get a web project to open using //IP of server/site...
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....
5
by: Matthew Louden | last post by:
I wrote ASP.NET application that access SQL Server database. When I run the application, it yields "Login failed for user '<COMPUTER_NAME>\ASPNET'" error message. I then did the following, but...
3
by: Paul D. Fox | last post by:
Hi I'm running Windows Server 2003 as a Domain Controller (with Active Directory) as a development server. I created an app that uploads graphics but it doesn't have permission. ASPNET machine...
3
by: Mr.KisS | last post by:
Hello all, I'm working with Windows XP PRO SP1, ASP.NET v2 (with Visual Web Dev) and, MS SQL 2005 with a database with Windows Authentication mode. I've an aspx page which must send a query to...
3
by: TLin2100 | last post by:
I have been away from .NET development for 18 months. I recently installed VisualStudio 2003. I have no trouble compiling and running new C# ASP.Net projects, but when I try to open and run one...
3
by: jimmyfishbean | last post by:
Hi, My client has the following network structure: 2 Windows 2003 servers : Server 1 - Web server running IIS, ftp import and export folder, ASP.NET SOAP web service and asp code on here....
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...
0
by: CESAR DE LA TORRE [MVP] | last post by:
I am using WSE 3.0 with Visual Studio 2005, specifically I'm using Kerberos authentication and passing Kerberos ticket from Presentation Tier (VSTO.2005 client) to Server Tier through our Web...
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
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
1
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...
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....

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.