ASPNET Projects and SQL Server

[=?Utf-8?B?TWljaGFlbCBNaWxsZXI=?=]

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

[Mr. Arnold]

Re: ASPNET Projects and SQL Server


"Michael Miller" <MichaelMiller@ discussions.mic rosoft.comwrote in message
news:EE4A6C5A-168A-4085-8705-8A011C452E8A@mi crosoft.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=+what+is+the+ASPNET+user+account+and+SQL+server&btnG=Search

[=?Utf-8?B?TWljaGFlbCBNaWxsZXI=?=]

Re: ASPNET Projects and SQL Server

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>\A SPNET 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" <MichaelMiller@ discussions.mic rosoft.comwrote in message
news:EE4A6C5A-168A-4085-8705-8A011C452E8A@mi crosoft.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=+what+is+the+ASPNET+user+account+and+SQL+server&btnG=Search

>
>

[=?Utf-8?B?TWljaGFlbCBNaWxsZXI=?=]

Re: ASPNET Projects and SQL Server

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" <MichaelMiller@ discussions.mic rosoft.comwrote in message
news:EE4A6C5A-168A-4085-8705-8A011C452E8A@mi crosoft.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=+what+is+the+ASPNET+user+account+and+SQL+server&btnG=Search

>
>

[Mr. Arnold]

Re: ASPNET Projects and SQL Server


"Michael Miller" <MichaelMiller@ discussions.mic rosoft.comwrote in message
news:D4EB7DAF-4385-448C-AB49-4555F7517419@mi crosoft.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>\A SPNET 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.

[=?Utf-8?B?TWljaGFlbCBNaWxsZXI=?=]

Re: ASPNET Projects and SQL Server

Thanks.
--
MichaelM


"Mr. Arnold" wrote:

>
"Michael Miller" <MichaelMiller@ discussions.mic rosoft.comwrote in message
news:D4EB7DAF-4385-448C-AB49-4555F7517419@mi crosoft.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>\A SPNET 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.
>
>
>
>
>