Tuesday, November 20, 2012
[DotNetNuke] Site redirects to InstallWizard.aspx
So you decided to peak inside DotNetNuke's database with SQL Management Studio.
You attach the dabatase (since it's running under user instance), make your edits, and dettach it again.
So far so good.
But when you open up your site again, it redirects you to http://localhost/Install/InstallWizard.aspx and says the "auto option is disabled since the sql connection failed".
a) do not use management studio in the first place. using it may stop your database from working in user instance mode. try using sql queries with DNN option Host > SQL. if it's too late for that now, try b)
b) after dettach, add the "Network Service" account to the SQL instance by opening management studio, logging in, and going to Secutiry > Logins
c) if everything else fails, try using persistent attach, and disable user instance mode (web.config, both connectionstrings and appsettings sections)
Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;
Data Source=.\SQLExpress;Integrated Security=True;User Instance=False;Database=DotNetNuke_attached_db_name.mdf;
Note: I recommend backup of the whole site before attempting file or database edits. If attaching the database fails, it is usually required to restart the machine to clear out all connections (even stopping sql service won't do it).