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.

 

[Guest]

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

 

[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]

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..

 

[Carlos]

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

 

[Sophia]

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/default.asp?url=/library/en-us/dnpag2/html/paght000013.asp

 

[Scott Allen]

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>