SQL Provider does not show after reregistering

The ASP.NET Configuration Manager uses whatever database connection string is configured by default in machine.config or web.config. The default connection string that ships in machine.config points at a local Sql Server Express (SSE) instance with user instancing. However, aspnet_regsql creates a database in whatever Sql Server instance you provider.

In your example it created the database against the local Sql Server. For the ASP.NET Configuration utility to know where to look, create a web.config for your application, and paste in the following connection information:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Server=(local);Integrated Security=SSPI;Database=aspnetdb"/>
</connectionStrings>

-Stefan

-

This posting is provided "AS IS" with no warranties, and confers no rights.