The auto option has been disabled as the dotnetnuke application cannot connect to a valid SQL Server

 

Debug a previous module today, put the dnn5.1 code under the D: directory, and use "SQL Server Management studio Express" to attach the database to the previous database. MDF, exported all database scripts, but after "detach" the database, open the website on the local machine (for details, I use XP, vs2008, and the database is sqlserver express ), the following error occurs.

This error has also occurred before and has never been solved well. It can be recovered or sometimes failed. But today I found a solution and wrote it down.

I found another method on the Internet, but it seems that I can't do it after I try it, or maybe I did not do it.

1) c: \> sqlcmd-e-scomputer2 \ sqlexpress-D master
2) then, 1> alter login [your Windows login (to be full name)] with default_database = Master
2> go
3> exit

My method is as follows:

Figure 2,Open the File Attribute instead of the Directory attribute and find that the ASPNET user does not have the permission or permission to add

Figure 3: troubleshooting after an ASP net user is added.