Authentication Configuration 2
I have tried several times to get the ASP.NET Configuration tool to work but to no avail. When I select the Security tab I'm informed that it is "Unable to connect to SQL Server database." I'm informed that my application is configured to use the provider: AspNetSqlProvider. Attempting to test this provider results in a message to use the command-line utility "aspnet_regsql" for the version of VS I'm running.
Running this without any options starts the "ASP.NET SQL Server Setup Wizard". Using the configure for application services option it asks for the Server name, authentication, and Database. I've used both the default network name and "localhost". If I provide no Database name, i.e. <default>, it creates the database "aspnetdb". I've also created a database with the name "AspNetSqlProvider".
In MS SQL Server Management Studio I can see both of the databases under both the (local)(SQL Server 10.50.1600) connection and under the network name "W371\APPDEV2008 (SQL Server 10.0.1600) - domain/myusername".
Performed the repair procedure today to see if there was any corruption issue with SQL Server.
Any suggestions would be greatly appreciated.
|