DNN Instance Failure

Hi all,

 Can someone help me out?  I am trying to install DNN on my local computer which runs on XP Pro, as soon as I try to view my site on  the I get this message:

DotNetNuke Error: - Version 04.05.05

Instance failure.

Hi,

That error message is not much help is it?  I've never seen that one before.  Are there any other details you might be able to give?  Does this happen every time you try to install?

Hi John,

  Thanks for your response. I know the error message isn't that helpful but that's all it says on the screen. It loads the DNN page as if it wants to start the installation and then, it displays that error message. I am trying to install it on  a Windows XP Pro machine (which is on my local system).

Well, I just tried browsing the page now with http://localhost/dnn and it says this:

Instance failure.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Instance failure.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:<br/><br/> 1. Add a &quot;Debug=true&quot; directive at the top of the file that generated the error. Example:<br/><br/>&nbsp;&nbsp;<%@ Page Language=&quot;C#&quot; Debug=&quot;true&quot; %><br/><br/> or:<br/><br/> 2) Add the following section to the configuration file of your application:<br/><br/><configuration><br/>&nbsp;&nbsp;&nbsp;<system.web><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<compilationdebug=&amp;quot;true&amp;quot;/><br/>&nbsp;&nbsp;&nbsp;</system.web><br/></configuration><br/><br/> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.<br/><br/> Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

<pre>[InvalidOperationException: Instance failure.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) +69 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) +780 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script) +6 DotNetNuke.Data.SqlDataProvider.GetProviderPath() +191 DotNetNuke.Common.Globals.GetUpgradeStatus() +78 DotNetNuke.Common.Global.CheckVersion() +132 DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) +463</pre>

Please I've got another issue. I managed to install DNN (the latest version 4.05.05) on our VPS which runs Windows 2003 Server (x64) but each time I try to install an existing module, I get the following error:

No Entries were posted for this blog. Error: View_Blog is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. ---> System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.GetBlogModuleSettings(Int32 PortalID, Int32 TabID) at DotNetNuke.Modules.Blog.Business.Utility.GetBlogModuleSettings(Int32 PortalID, Int32 TabID) at DotNetNuke.Modules.Blog.ViewBlog.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Unhandled error loading module. DotNetNuke.Services.Exceptions.ModuleLoadException: Unhandled Error Adding Module to BottomPane ---> System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.GetBlogModuleSettings(Int32 PortalID, Int32 TabID) at DotNetNuke.Modules.Blog.Business.Utility.GetBlogModuleSettings(Int32 PortalID, Int32 TabID) at DotNetNuke.Modules.Blog.ViewBlog.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.Modules.Blog.MainView.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace ---

Sorry, I wasn't implying that the problem was with you not giving enough info.  I was just letting you know that I understand how you can be wondering what to do next with that kind of error message.

This new info is getting us somewhere.  It looks like the SQL connection string may be the culprit.

Check out this thread if you are using SQL 2005 Express:

http://www.snapsis.com/DotNetNuke/Support/tabid/560/forumid/11/postid/6525/view/topic/DNN-Support-6525.aspx

Thanks a lot! Have a look at my connection string, I am not sure where I made a mistake. I know that 'Instance is not meant to be True:

add name="SiteSqlServer" providername="System.Data.SqlClient" connectionstring="Server=VPS322607\SQLEXPRESS;Database=dnn;uid=xxx;pwd=xxx;">

add value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" key="SiteSqlServer"> 

Thanks a lot!!!! It worked. The second connection string wasn't the same as the top one. It was referring to the database that come with DNN and as a result I was getting the error message when trying to install existing modules (such as: Blogs, Forums, Events etc).

I just changed the connection string to exactly the top one and it worked. Thanks a lot!

I am still having issues with my local DNN installation though. Having done only three installs on a server, I thought I should try it on my Windows XP Pro but it still won't work. I keep getting this when I try to browse http://localhost/dnn:

It's a funny one though! Cos when I try sometimes it just shows the DNN home page as it wants to start the install process and it says Instance Failed. I have checked the application protection and it's on Low IIS.

Instance failure.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Instance failure.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:<br/><br/> 1. Add a &quot;Debug=true&quot; directive at the top of the file that generated the error. Example:<br/><br/>&nbsp;&nbsp;<%@ Page Language=&quot;C#&quot; Debug=&quot;true&quot; %><br/><br/> or:<br/><br/> 2) Add the following section to the configuration file of your application:<br/><br/><configuration><br/>&nbsp;&nbsp;&nbsp;<system.web><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<compilationdebug=&amp;quot;true&amp;quot;/><br/>&nbsp;&nbsp;&nbsp;</system.web><br/></configuration><br/><br/> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.<br/><br/> Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

<pre>[InvalidOperationException: Instance failure.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) +69 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) +780 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script) +6 DotNetNuke.Data.SqlDataProvider.GetProviderPath() +191 DotNetNuke.Common.Globals.GetUpgradeStatus() +78 DotNetNuke.Common.Global.CheckVersion() +132 DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) +463</pre>

I will do. I keep having one issue or the other. Remember the DNN site tha wouldn't let me install existing module in which you helped me with the connection string and everything went well? Well, now after installing and Event this morning, I get this when I tried browsing the site now:

Error: Diary is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Events.SelectCategory.get_SelectedCategory() at DotNetNuke.Modules.Events.EventList.BindDataGrid() at DotNetNuke.Modules.Events.EventList.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

It looks like the same issue was posted in the Events Module project forum:

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/20/threadid/128541/threadpage/2/scope/posts/Default.aspx