Membership provider does not connect to db

[Carlos]

Hi all,

I am trying to figure out how to deal with the membership provider.
I used the aspnet_regsql to create the aspnetdb database in my sqlserver2005
instance of my server. I noticed that the web.config file got updated with
the
entries that include the connnectionStri ng.

However, when I try to test the connection (i.e. AspNetSqlProvid er), I do
get:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to create
and configure the database, and then return to this tool to set the
provider.

I se the database created using my Microsoft SQL Server Management Studio,
The connection string looks fine in web.config i.e.:

<remove name="LocalSqlS erver" />

<add name="LocalSqlS erver" connectionStrin g="Data
Source=server\S QLSERVER2005;In itial Catalog=aspnetd b;Integrated
Security=SSPI;"

providerName="S ystem.Data.SqlC lient" />

When I tried the security tab on the tool I got:

An error occurred while attempting to initialize a
System.Data.Sql Client.SqlConne ction object. The value that was provided for
the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionStrin g

I do have another connectionStrin g that points to the application data, and
resides in the same sql server instance, and works fine. I can see the
aspnedb as part of the databases in the instance.

Thanks in advance for any help,

Carlos.

[Mark Fitzpatrick]

Does the ASP.Net user account have permissions to login and view the
aspnetdb? That's usually the biggest issue when using integrates security in
the connection string.
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Carlos" <ch*****@earthl ink.netwrote in message
news:OT******** ******@TK2MSFTN GP02.phx.gbl...

Hi all,

I am trying to figure out how to deal with the membership provider.
I used the aspnet_regsql to create the aspnetdb database in my
sqlserver2005 instance of my server. I noticed that the web.config file
got updated with the
entries that include the connnectionStri ng.

However, when I try to test the connection (i.e. AspNetSqlProvid er), I do
get:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to create
and configure the database, and then return to this tool to set the
provider.

I se the database created using my Microsoft SQL Server Management Studio,
The connection string looks fine in web.config i.e.:

<remove name="LocalSqlS erver" />

<add name="LocalSqlS erver" connectionStrin g="Data
Source=server\S QLSERVER2005;In itial Catalog=aspnetd b;Integrated
Security=SSPI;"

providerName="S ystem.Data.SqlC lient" />

When I tried the security tab on the tool I got:

An error occurred while attempting to initialize a
System.Data.Sql Client.SqlConne ction object. The value that was provided
for the connection string may be wrong, or it may contain an invalid
syntax. Parameter name: connectionStrin g

I do have another connectionStrin g that points to the application data,
and resides in the same sql server instance, and works fine. I can see the
aspnedb as part of the databases in the instance.

Thanks in advance for any help,

Carlos.

[Carlos]

Mark,

thank you for your help. I just saw your note, and wanted to reply to you.
Yes, I have the ASP .Net user account (NT AUTHORITY\NETWO RK SERVICE), and
<myserver>\ASPN ET accounts in the db_owner role.

Thanks again,

Carlos.
"Mark Fitzpatrick" <ma******@fitzm e.comwrote in message
news:OJ******** ********@TK2MSF TNGP05.phx.gbl. ..

Does the ASP.Net user account have permissions to login and view the
aspnetdb? That's usually the biggest issue when using integrates security
in the connection string.
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Carlos" <ch*****@earthl ink.netwrote in message
news:OT******** ******@TK2MSFTN GP02.phx.gbl...

>Hi all,

I am trying to figure out how to deal with the membership provider.
I used the aspnet_regsql to create the aspnetdb database in my
sqlserver200 5 instance of my server. I noticed that the web.config file
got updated with the
entries that include the connnectionStri ng.

However, when I try to test the connection (i.e. AspNetSqlProvid er), I do
get:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administrati on tool, use the aspnet_regsql command-line utility to create
and configure the database, and then return to this tool to set the
provider.

I se the database created using my Microsoft SQL Server Management
Studio,
The connection string looks fine in web.config i.e.:

<remove name="LocalSqlS erver" />

<add name="LocalSqlS erver" connectionStrin g="Data
Source=server\ SQLSERVER2005;I nitial Catalog=aspnetd b;Integrated
Security=SSPI; "

providerName=" System.Data.Sql Client" />

When I tried the security tab on the tool I got:

An error occurred while attempting to initialize a
System.Data.Sq lClient.SqlConn ection object. The value that was provided
for the connection string may be wrong, or it may contain an invalid
syntax. Parameter name: connectionStrin g

I do have another connectionStrin g that points to the application data,
and resides in the same sql server instance, and works fine. I can see
the aspnedb as part of the databases in the instance.

Thanks in advance for any help,

Carlos.

[Mohsin Rizvi]

Hello Carlos!

Thanx for putting up an issue.
I assume that you have assigned proper rights to 'NT AUTHORITY\NETWO RK
SERVICE' user account.
Secondly, try omitting domain name from the datasource of
connectionStrin g attribute.

And if it doesn't work, do paste your web.config here so we can have a
close look in to your problem.

Do let me know in any case.
Regards,
Mohsin Rizvi

Carlos wrote:

Mark,

thank you for your help. I just saw your note, and wanted to reply to you.
Yes, I have the ASP .Net user account (NT AUTHORITY\NETWO RK SERVICE), and
<myserver>\ASPN ET accounts in the db_owner role.

Thanks again,

Carlos.
"Mark Fitzpatrick" <ma******@fitzm e.comwrote in message
news:OJ******** ********@TK2MSF TNGP05.phx.gbl. ..

Does the ASP.Net user account have permissions to login and view the
aspnetdb? That's usually the biggest issue when using integrates security
in the connection string.
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Carlos" <ch*****@earthl ink.netwrote in message
news:OT******** ******@TK2MSFTN GP02.phx.gbl...

Hi all,

I am trying to figure out how to deal with the membership provider.
I used the aspnet_regsql to create the aspnetdb database in my
sqlserver2005 instance of my server. I noticed that the web.config file
got updated with the
entries that include the connnectionStri ng.

However, when I try to test the connection (i.e. AspNetSqlProvid er), I do
get:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to create
and configure the database, and then return to this tool to set the
provider.

I se the database created using my Microsoft SQL Server Management
Studio,
The connection string looks fine in web.config i.e.:

<remove name="LocalSqlS erver" />

<add name="LocalSqlS erver" connectionStrin g="Data
Source=server\S QLSERVER2005;In itial Catalog=aspnetd b;Integrated
Security=SSPI;"

providerName="S ystem.Data.SqlC lient" />

When I tried the security tab on the tool I got:

An error occurred while attempting to initialize a
System.Data.Sql Client.SqlConne ction object. The value that was provided
for the connection string may be wrong, or it may contain an invalid
syntax. Parameter name: connectionStrin g

I do have another connectionStrin g that points to the application data,
and resides in the same sql server instance, and works fine. I can see
the aspnedb as part of the databases in the instance.

Thanks in advance for any help,

Carlos.