code_junkie

Error Installing TFS 2008 SP1, CREATE TABLE permission denied in database 'master'

Nov 12th, 2011
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.67 KB | None | 0 0
  1. Using workflow file from location exe.
  2. Executing workflow 'Quiesce ATDT'...
  3. Stopping Windows Service 'TFSServerScheduler'...
  4. Stopping Windows Service 'CoverAn'...
  5. Stopping Windows Service 'W3SVC'...
  6. Starting Windows Service 'W3SVC'...
  7. Disabling SQL Jobs for databases
  8. FSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
  9. CREATE TABLE permission denied in database 'master'.
  10. Retrying...
  11. Disabling SQL Jobs for databases
  12. TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
  13. CREATE TABLE permission denied in database 'master'.
  14. Retrying...
  15. Disabling SQL Jobs for databases
  16. TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
  17. CREATE TABLE permission denied in database 'master'.
  18. Retrying...
  19. Disabling SQL Jobs for databases
  20. TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
  21. CREATE TABLE permission denied in database 'master'.
  22. Retrying...
  23. Disabling SQL Jobs for databases
  24. TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
  25. CREATE TABLE permission denied in database 'master'.
  26. Retrying...
  27. Disabling SQL Jobs for databases
  28.  
  29. TFSActivityLogging,TFSBuild,TFSIntegration,TFSVersionControl,TFSWorkItemTracking,TFSWorkItemTrackingAttachments,TFSWarehouse
  30. SQL Error #1
  31. SQL Message: CREATE TABLE permission denied in database 'master'.
  32. SQL LineNumber: 13
  33. SQL Source: .Net SqlClient Data Provider
  34. SQL Procedure:
  35.  
  36. System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'master'.
  37. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  38. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  39. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  40. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  41. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  42. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  43. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  44. at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.DisableJobs(XPathNavigator workflow)
  45. at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.ProcessSqlDatabaseElement(XPathNavigator workflow, String action, String dbName)
  46. at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.ExecuteWorkflowStep(XPathNavigator workflow, String action, String nameAttribute)
  47. at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.ExecuteWorkflowStepWithRetry(XPathNavigator workflow, String action, String nameAttribute)
  48. at Microsoft.TeamFoundation.Admin.TFSQuiesce.Quiescer.RunWorkflow(String workflowName)
  49. Exception Data:
  50. Key: HelpLink.ProdName, Value: Microsoft SQL Server
  51. Key: HelpLink.ProdVer, Value: 09.00.3054
  52. Key: HelpLink.EvtSrc, Value: MSSQLServer
  53. Key: HelpLink.EvtID, Value: 262
  54. Key: HelpLink.BaseHelpUrl, Value: http://go.microsoft.com/fwlink
  55. Key: HelpLink.LinkId, Value: 20476
  56.  
  57. Executing workflow 'Unquiesce ATDT'...
  58. Enabling SQL Jobs.
  59. Unblocking service account from accessing database TFSActivityLogging
  60. Unblocking service account from accessing database TFSBuild
  61. Unblocking service account from accessing database TFSIntegration
  62. Unblocking service account from accessing database TFSVersionControl
  63. Unblocking service account from accessing database TFSWorkItemTracking
  64. Unblocking service account from accessing database TFSWorkItemTrackingAttachments
  65. Unblocking service account from accessing database TFSWarehouse
  66. Stopping Windows Service 'W3SVC'...
  67. Starting Windows Service 'W3SVC'...
  68. Starting Windows Service 'TFSServerScheduler'...
  69. Starting Windows Service 'CoverAn'...
  70.  
  71. Workflow 'Quiesce ATDT' failed! ExitCode = 9000.
  72. 12/03/08 16:29:03 DDSet_Status: Process returned 9000
  73. 12/03/08 16:29:03 DDSet_Status: Found the matching error code for return value '9000' and it is: '29207'
  74. 12/03/08 16:29:03 DDSet_Error: 9000
  75. 12/03/08 16:29:03 DDSet_CARetVal: 29207
  76. 12/03/08 16:29:03 DDSet_Status: QuietExec returned 29207
  77. 12/03/08 16:29:03 DDSet_Exit: QuietExec ended
  78. MSI (s) (44:18) [16:29:03:812]: User policy value 'DisableRollback' is 0
  79. MSI (s) (44:18) [16:29:03:812]: Machine policy value 'DisableRollback' is 0
  80. Action ended 16:29:03: InstallFinalize. Return value 3.
Add Comment
Please, Sign In to add comment