ASP.NET Configureation - can NOT connect to SQL server

  • Thread starter Thread starter Zilla
  • Start date Start date
Z

Zilla

Please tell me if there's a more appropriate NG for this topic.

I've googled answers to no avail.

I installed SQL 2008 Express in my machine, then MS Visual Web Developer
2008 Express.
I'm created a web project, with access to a db. When I go to
Website->ASP.NET configuration,
then go to Providers tab on the resulting browser, Select Single Provider,
then click Test, I 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 have created the database, and have ran aspnet_regsql with same results.
SQL Services ARE running, with TCP/IP and Pipe protocols enabled.

Any pointers?
 
Zilla said:
Please tell me if there's a more appropriate NG for this topic.

I've googled answers to no avail.

I installed SQL 2008 Express in my machine, then MS Visual Web Developer
2008 Express.
I'm created a web project, with access to a db. When I go to
Website->ASP.NET configuration,
then go to Providers tab on the resulting browser, Select Single Provider,
then click Test, I 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 have created the database, and have ran aspnet_regsql with same results.
SQL Services ARE running, with TCP/IP and Pipe protocols enabled.

Any pointers?
Click to expand...

BTW, this is on a Vista Premium 32 machine.
 
I solved this issue my modifying the connectionString block of the
web.config file.
However, I consider this a SUCKY way to do it. Since web.config is a
"generated"
file, why was it NOT modified when I connected to my DB?
 
re:
!> Since web.config is a "generated" file,
!> why was it NOT modified when I connected to my DB?

Not all configurations are auto-saved to web.config.
In fact, most are not.

Web.config is not a "generated" file, mostly.
Web.config is, mostly, a user-modifiable file.




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
 
Juan T. Llibre said:
re:
!> Since web.config is a "generated" file,
!> why was it NOT modified when I connected to my DB?
Click to expand...

Exactly my sentiments - non-consistency.
Not all configurations are auto-saved to web.config.
In fact, most are not.

Web.config is not a "generated" file, mostly.
Web.config is, mostly, a user-modifiable file.
Click to expand...

It was "generated" for me when I started my project!
 
re:
!> It was "generated" for me when I started my project!

Indeed, but it will not be auto-edited except for the ASP.NET configuration tool.




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
=========================
 
Back
Top