asp .net 2.0 and configuration tool for sql provider

[Carlos]

Hi all,

I am trying to configure a sample website under asp .net 2.0, and play
with the security provider. I already have the aspnetdb db, but when I go to
the
security tab for the asp configuration tool, a connection can not be
established with the provider. I noticed I did not have the NT
AUTHORITY\NETWORK SERVICE user for the db, so I went and added it with
db_owner role. However, it is still not able to connect.to that provider. Am
I missing something?

Thanks in advance,

Carlos.

[Edward]

Did you use the aspnet_Regsql utility? Do you have a setting in the
connectionstrings in web.config?

"Carlos" wrote:

Hi all,

I am trying to configure a sample website under asp .net 2.0, and play
with the security provider. I already have the aspnetdb db, but when I go to
the
security tab for the asp configuration tool, a connection can not be
established with the provider. I noticed I did not have the NT
AUTHORITY\NETWORK SERVICE user for the db, so I went and added it with
db_owner role. However, it is still not able to connect.to that provider. Am
I missing something?

Thanks in advance,

Carlos.

[Juan T. Llibre]

If you're not running Windows Server 2003, the user is
Machinename\ASPNET, not NT AUTHORITY\NETWORK SERVICE.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"Carlos" <ch*****@earthlink.net> wrote in message
news:Od*************@TK2MSFTNGP10.phx.gbl...

Hi all,

I am trying to configure a sample website under asp .net 2.0, and play with the
security provider. I already have the aspnetdb db, but when I go to the
security tab for the asp configuration tool, a connection can not be established with
the provider. I noticed I did not have the NT AUTHORITY\NETWORK SERVICE user for the db,
so I went and added it with db_owner role. However, it is still not able to connect.to
that provider. Am I missing something?

Thanks in advance,

Carlos.

[Carlos]

Yes, I already used the aspnet_Regsql utility, and was able to
create the database, however, I did not see any connection string
created in my web.config file. Do I need to create it manually ?
I am running under windows server 2003 EE.
Is there any log created while the ASP Configuration tool is trying to
connect to the database? I would like to see what connection string
is trying to use. Thanks again,

Carlos..
"Edward" <Ed****@discussions.microsoft.com> wrote in message
news:E1**********************************@microsof t.com...

Did you use the aspnet_Regsql utility? Do you have a setting in the
connectionstrings in web.config?

"Carlos" wrote:

Hi all,

I am trying to configure a sample website under asp .net 2.0, and play
with the security provider. I already have the aspnetdb db, but when I go
to
the
security tab for the asp configuration tool, a connection can not be
established with the provider. I noticed I did not have the NT
AUTHORITY\NETWORK SERVICE user for the db, so I went and added it with
db_owner role. However, it is still not able to connect.to that provider.
Am
I missing something?

Thanks in advance,

Carlos.

[Carlos]

Thank you Juan, I am running under WS 2003 EE.. Any other suggestions ?

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...

If you're not running Windows Server 2003, the user is
Machinename\ASPNET, not NT AUTHORITY\NETWORK SERVICE.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"Carlos" <ch*****@earthlink.net> wrote in message
news:Od*************@TK2MSFTNGP10.phx.gbl...

Hi all,

I am trying to configure a sample website under asp .net 2.0, and play
with the security provider. I already have the aspnetdb db, but when I go
to the
security tab for the asp configuration tool, a connection can not be
established with the provider. I noticed I did not have the NT
AUTHORITY\NETWORK SERVICE user for the db, so I went and added it with
db_owner role. However, it is still not able to connect.to that provider.
Am I missing something?

Thanks in advance,

Carlos.

[Sophia]

"Carlos" <ch*****@earthlink.net> wrote in message
news:Od*************@TK2MSFTNGP10.phx.gbl...

Hi all,

I am trying to configure a sample website under asp .net 2.0, and play
with the security provider. I already have the aspnetdb db, but when I go
to the
security tab for the asp configuration tool, a connection can not be
established with the provider. I noticed I did not have the NT
AUTHORITY\NETWORK SERVICE user for the db, so I went and added it with
db_owner role. However, it is still not able to connect.to that provider.
Am I missing something?

Carlos, check thsi page:
http://msdn.microsoft.com/library/de...aght000013.asp

[Scott Allen]

On Sat, 19 Nov 2005 12:41:16 -0500, "Carlos" <ch*****@earthlink.net>
wrote:

I would like to see what connection string is trying to use. Thanks again,

All of the providers using a database service connect using a
"LocalSqlServer" connection string defined in machine.config. By
default they all look for a SQL Server Express database in App_Data.

You can edit machine.config, or override the settings in web.config on
a per-app bases, e.g:

<configuration>
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=MyServer;
Initial Catalog=appservicesdb;
Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>

--
Scott
http://www.OdeToCode.com/blogs/scott/