471,074 Members | 1,430 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,074 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 1520

"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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Harry Simpson | last post: by
5 posts views Thread by Matthew Louden | last post: by
3 posts views Thread by Paul D. Fox | last post: by
3 posts views Thread by TLin2100 | last post: by
6 posts views Thread by Andrew Chalk | last post: by
reply views Thread by CESAR DE LA TORRE [MVP] | last post: by

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.