2

Closed

Error Installing SQL 2008 and IIS 7.5

description

After clicking on updating the database i get this error:
 
The database failed to install properly. Errormessage: umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Foreign key 'FK_forumTopics_umbracoNode1' references invalid table 'dbo.umbracoNode'. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 64 at umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 217 --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 223 at uForum.usercontrols.DBInstaller.installButton_Click(Object sender, EventArgs e)
 
The problem is when i installed umbraco 4.0.1 in the database it dosen't use "dbo." in the start of the tables, it uses the username for the sql login.
Closed Nov 11, 2010 at 7:00 PM by mortenbock
Fixed in changeset 47484

comments

mortenbock wrote Apr 3, 2010 at 5:20 PM

Good point. The installer should not assume that it can use the dbo user.

wrote Apr 3, 2010 at 5:27 PM

wrote Nov 11, 2010 at 5:40 PM

wrote Nov 11, 2010 at 5:40 PM

wrote Nov 11, 2010 at 7:00 PM

wrote Nov 11, 2010 at 7:00 PM

wrote Feb 14, 2013 at 12:25 AM

wrote May 16, 2013 at 5:34 AM