Recently, in one of my customer’s case I have seen an issue in which the TFS2010 application tier only wizard fails while creating the server databases with below error message:

An exception was occurred while creating the server databases. The exception message is “TfsMasterCreateSchema.sql Line 145 Error: Invalid object name 'dbAdmin.dbo.changelog'”

When I went through the error log file, I found the below error details:

[Error @19:11:26.995] TfsMasterCreateSchema.sql Line 145 Error: Invalid object name 'dbAdmin.dbo.changelog'.

[Info @19:11:27.136] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: TfsMasterCreateSchema.sql Line 145 Error: Invalid object name 'dbAdmin.dbo.changelog'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbAdmin.dbo.changelog'. at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException

Figured out the issue is due to the trigger 'dbAdmin.dbo.changelog' which was enabled under the master database. Disabled the trigger and configured the TFS2010 with Application tier only wizard.

Expand the master database and programmability then Database Triggers, open the trigger and type the below syntax to disable it.

syntax:

USE Databasename;

GO

DISABLE TRIGGER TriggerName ON TableName;

GO

Also, if you are using the SQl server 2008 R2, select the trigger and right click on it and choose ‘Disable’.

clip_image001

Content prepared by: Chandra Sekhar Viswanadha

Content reviewed by: Lakhminder Singh