Error installing TFS 2008 SP1, CREATE TABLE permission on database "master"
only now dba allows me to connect to the database using Sql Server Management Studio, so I noticed that the default database for tfs installation and maintenance users is wizard, is this ok? that's why I got this error ?, let me post part log and User Setup properties to ensure that users are configured correctly.
Here is part of the error log:
Using workflow file from location exe.
Executing workflow 'Quiesce ATDT'...
Stopping Windows Service 'TFSServerScheduler'...
Stopping Windows Service 'CoverAn'...
Stopping Windows Service 'W3SVC'...
Starting Windows Service 'W3SVC'...
Disabling SQL Jobs for databases
FSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
CREATE TABLE permission denied in database 'master'.
Retrying...
Disabling SQL Jobs for databases
TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
CREATE TABLE permission denied in database 'master'.
Retrying...
Disabling SQL Jobs for databases
TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
CREATE TABLE permission denied in database 'master'.
Retrying...
Disabling SQL Jobs for databases
TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
CREATE TABLE permission denied in database 'master'.
Retrying...
Disabling SQL Jobs for databases
TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
CREATE TABLE permission denied in database 'master'.
Retrying...
Disabling SQL Jobs for databases
TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
SQL Error #1
SQL Message: CREATE TABLE permission denied in database 'master'.
SQL LineNumber: 13
SQL Source: .Net SqlClient Data Provider
SQL Procedure:
System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'master'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
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.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.TeamFoundation.Admin.TFSQuiesce.Quiescer.DisableJobs(XPathNavigator workflow)
at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.ProcessSqlDatabaseElement(XPathNavigator workflow, String action, String dbName)
at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.ExecuteWorkflowStep(XPathNavigator workflow, String action, String nameAttribute)
at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.ExecuteWorkflowStepWithRetry(XPathNavigator workflow, String action, String nameAttribute)
at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.RunWorkflow(String workflowName)
Exception Data:
Key: HelpLink.ProdName, Value: Microsoft SQL Server
Key: HelpLink.ProdVer, Value: 09.00.3054
Key: HelpLink.EvtSrc, Value: MSSQLServer
Key: HelpLink.EvtID, Value: 262
Key: HelpLink.BaseHelpUrl, Value: http://go.microsoft.com/fwlink
Key: HelpLink.LinkId, Value: 20476
Executing workflow 'Unquiesce ATDT'...
Enabling SQL Jobs.
Unblocking service account from accessing database TFSActivityLogging
Unblocking service account from accessing database TFSBuild
Unblocking service account from accessing database TFSIntegration
Unblocking service account from accessing database TFSVersionControl
Unblocking service account from accessing database TFSWorkItemTracking
Unblocking service account from accessing database TFSWorkItemTrackingAttachments
Unblocking service account from accessing database TFSWarehouse
Stopping Windows Service 'W3SVC'...
Starting Windows Service 'W3SVC'...
Starting Windows Service 'TFSServerScheduler'...
Starting Windows Service 'CoverAn'...
Workflow 'Quiesce ATDT' failed! ExitCode = 9000.
12/03/08 16:29:03 DDSet_Status: Process returned 9000
12/03/08 16:29:03 DDSet_Status: Found the matching error code for return value '9000' and it is: '29207'
12/03/08 16:29:03 DDSet_Error: 9000
12/03/08 16:29:03 DDSet_CARetVal: 29207
12/03/08 16:29:03 DDSet_Status: QuietExec returned 29207
12/03/08 16:29:03 DDSet_Exit: QuietExec ended
MSI (s) (44:18) [16:29:03:812]: User policy value 'DisableRollback' is 0
MSI (s) (44:18) [16:29:03:812]: Machine policy value 'DisableRollback' is 0
Action ended 16:29:03: InstallFinalize. Return value 3.
Following are the properties of the setup user in SQL:
General
Username: CNBYV \ SRVSTFTN
Windows Authentication
Default Database: Wizard
Default Language: English
Server Roles
DBCreator
public
sercurityadmin
User Mapping
Default Database User DefaultSchema | Checked Master CNBYV \ SRVSTFTN ... public
Checked TfsActivityLogging dbo dbo dbo_owner, public Checked TfsBuild dbo dbo dbo_owner, public Checked TfsIntegration dbo dbo dbo_owner, public Checked dbo dfs_owner, public Checked dfsVersion_Control downbo dbo, public Checked dfsVersion_Control downbo dbo dbo public Checked TfsWorkItemTrackingAttachments dbo dbo dbo_owner, public
These are the settings I found to be more important, if you need more information please let me know.
Many thanks.
PS: It was just a pain in FK to post the table above, I don't know why people love Markdown, if anyone knows how to fix it, so it looks like a table, please edit the question.
Juan Zamudio
source to share
In fact, adding the sysadmin role to the TFSSETUP account is pretty drastic. In my company, it's just a big no, no. The DBAs created a database for me. I tried to point tfsdb (TFS DB configuration utility) to it using H_DB_NAME, but it doesn't work.
Does Microsoft provide any useful information about all the possible properties that can be set in msiproperty.ini? Koz, I couldn't find much useful at all.
Microsoft, if you're listening, I'm actually thinking about disabling TFS entirely, because you can't manufacture and / or document your setup procedures decently.