Failed to generate a user instance of SQL Server

Hello all,

I have a VB.NET 2005 windows based application that uses the Enterprise Library Data Access Application Block and SQL Server Express and I am having an issue getting the application to install and run from a Setup Package.

I have included the Prerequisites of SQL Server Express, .NET Framework and Microsoft Visual Studio 2005 Report Viewer in my setup project and when I run setup.exe that was created by my Setup Project, it appears everything is installed correctly on the client pc. However, when I go to run the application if get the following error:

10/05 08:44:35 ERROR DHGUI.DHConfiguration DHConfiguration_FormClosed
System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(CommandType commandType, String commandText, DataSet dataSet, String[] tableNames)
at DHFramework.Configuration.GetConfigDS()
at DHFramework.Links.InitializeLinks()
at DHGUI.DHConfiguration.DHConfiguration_FormClosed(Object sender, FormClosedEventArgs e)

I ran the SSEUTIL program with the -l option and it returns the message of:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

Can anyone please tell me what it is that I'm doing wrong and how I can get this to work? I'm up against a deadline and this is killing me!

Thanks,

Brent

There appears to be something that SQL Express doesn't like when being installed via a Remote Desktop connection. So I re-installed my application without using Remote Desktop and that seems to have cleared it up.

Brent

|||

Bsmith05 wrote:

I have included the Prerequisites of SQL Server Express, .NET Framework and Microsoft Visual Studio 2005 Report Viewer in my setup project and when I run setup.exe that was created by my Setup Project, it appears everything is installed correctly on the client pc.

how did you do? can you explain this to me, please?

|||If you're referring to how I included the prerequisites, right-click on your project in the Solution Explorer, click on the Publish tab and then you will see a button called Prerequisites. If you click that you will see a list of available Prerequisites. If you select any one of those they will be included in the installation package and they will be installed on the target machine during the setup process.

Hope that helps.sql