locked
Create top level site collection error RRS feed

  • Question

  • I'm trying to create a top level site collection but keep running into error Event ID 6141. I turned on verbose logging and discover the following. My question is how to resolve the database error to create the top level site.

    11/28/2011 19:33:09.80 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       6t8b Verbose Looking up  site http://toplevelSite/ in the farm SharePoint_Config  

    11/28/2011 19:33:09.80 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:09.80 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:09.80 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.80 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.80 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_getObjectsByBaseClass'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@BaseClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '9920f486-2ff4-4d10-9532-e01979826585'     Parameter: '@ParentId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '52ab5124-69db-43a2-b339-2707f86d9bfb'  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_getObjectsByBaseClass'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@BaseClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '45ad2bf2-4e3e-46a1-b477-126944c0acef'     Parameter: '@ParentId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '52ab5124-69db-43a2-b339-2707f86d9bfb'  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_getObjectsByBaseClass'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@BaseClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '113fb569-7520-4651-8fc4-e9f4f5887618'     Parameter: '@ParentId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'ae66bd5d-259a-4675-a87c-d7e3ed7d01a3'  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin  SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_getObjectsByBaseClass'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@BaseClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '113fb569-7520-4651-8fc4-e9f4f5887618'     Parameter: '@ParentId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '20d1dd73-1f12-4fb3-98e2-a632bd938fc2'  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       6t8d Verbose Looking up the additional information about the typical site http://toplevelsitecollection.  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       6t8f Verbose Site lookup is replacing http://toplevelsitecollection/ with the alternate access url http://toplevelsitecollection.  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       6t8g Verbose Looking up typical site http://toplevelsitecollection/ in web application SPWebApplication Name=finance Parent=SPWebService.  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.81 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_getSiteMap'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@ApplicationId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'dd7dd4e5-c7ff-4869-b968-deac79e6472f'     Parameter: '@Path' Type: NVarChar Size: 128 Direction: Input Value: '/'  

    11/28/2011 19:33:09.83 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:09.83 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:09.83 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.83 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:09.83 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_putSiteMap'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@ApplicationId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'dd7dd4e5-c7ff-4869-b968-deac79e6472f'     Parameter: '@DatabaseId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '5f82c9ed-a5b3-421e-b206-4a312c62b756'     Parameter: '@SiteId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '29be82d0-06a8-4fb4-9271-d95be49676a9'     Parameter: '@Path' Type: NVarChar Size: 128 Direction: Input Value: '/'     Parameter: '@Pairing' Type: TinyInt Size: 0 Direction: Input Value: 'None'     Parameter: '@RedirectUrl' Type: NVarChar Size: 512 Direction: Input Value: ''     Parameter: '@HostHeaderI...  

    11/28/2011 19:33:09.83* STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose ...sSiteName' Type: Bit Size: 0 Direction: Input Value: 'False'     Parameter: '@CurrentDatabaseSiteCount' Type: Int Size: 128 Direction: Output Value: ''  

    11/28/2011 19:33:09.88 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Topology                       88b9 Verbose Determining if the current user is a SharePoint Farm Administrator  

    11/28/2011 19:33:09.94 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       72jz Medium   Creating site: URL "/"  

    11/28/2011 19:33:10.14 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       8gam Medium   Recalc needs to happen. Real = 0, Cached =-1, WFE = -1  

    11/28/2011 19:33:10.16 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       6f8g Unexpected Unexpected query execution failure, error code 8144. Additional error information from SQL Server is included below. "Procedure or function proc_SecAddUser has too many arguments specified." Query text (if available): "SET NOCOUNT ON; DECLARE @DN nvarchar(256),@LN nvarchar(128),@@DocUIVersion int,@@Level tinyint,@@S uniqueidentifier; DECLARE @ItemId int; DECLARE @@iRet int; DECLARE @ExtraItemSize int; DECLARE @Login nvarchar(255); DECLARE @Title nvarchar(255); DECLARE @Email nvarchar(255); DECLARE @Notes nvarchar(1023); DECLARE @AddedToTable bit; DECLARE @UserIdOut int; DECLARE @LoginOut nvarchar(255); DECLARE @TitleOut nvarchar(255); DECLARE @EmailOut nvarchar(255); DECLARE @NotesOut nvarchar(1023); DECLARE @DeletedOut bit; DECLARE @IsGroup bit; SET @IsGroup = 0; SET @@Level = 1; SELECT @...  

    11/28/2011 19:33:10.16* STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       6f8g Unexpected ...Login = ?; SELECT @Title = ?; SELECT @Email = ?; SELECT @Notes = ?; SELECT @@S=?; BEGIN TRAN; EXEC @@iRet = proc_SecAddUser @@S, ?, ?, ?, ?, ?, @Login, @Title, @Email, @Notes, ?, ?, ?, ?, @AddedToTable OUTPUT, @UserIdOut OUTPUT, @LoginOut OUTPUT, @TitleOut OUTPUT, @EmailOut OUTPUT, @NotesOut OUTPUT, @DeletedOut; IF @@iRet <> 0 BEGIN ROLLBACK TRAN; GOTO DONE; END ; SELECT @ItemId = @UserIdOut ; COMMIT TRAN; DONE: SELECT @@iRet, @ItemId, @AddedToTable, @LoginOut, @TitleOut, @EmailOut, @NotesOut, @DeletedOut "  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       72k1 High     Cannot create site: "http://toplevelsitecollection/" for owner "farmAdmin", Error: , 0x80040e14  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_dropSiteMap'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@Id' Type: UniqueIdentifier Size: 0 Direction: Input Value: '29be82d0-06a8-4fb4-9271-d95be49676a9'  

    11/28/2011 19:33:10.17 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       8e2s Medium   Unknown SPRequest error occurred. More information: 0x80040e14  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Topology                       95ks Critical The site / could not be created.  The following exception occured: Exception from HRESULT: 0x80040E14.  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4                               1624                           8acf Verbose Current user after SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-94148 ImpersonationLevel: None  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   Database                       880m Verbose SqlCommand: 'dbo.proc_dropSiteMap'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@Id' Type: UniqueIdentifier Size: 0 Direction: Input Value: '29be82d0-06a8-4fb4-9271-d95be49676a9'  

    11/28/2011 19:33:10.20 STSADM.EXE (0x1608)                     0x15C4 Windows SharePoint Services   General                       72ju High     stsadm: The IIS Web Site was extended with Windows SharePoint Services, but the following error occurs in creating the default site "http://toplevelsitecollection/". Please correct the input and try to create the default site again. Error: Exception from HRESULT: 0x80040E14 Callstack:    at Microsoft.SharePoint.StsAdmin.SPExtendVirtualServer.Run(StringDictionary keyValues)     at Microsoft.SharePoint.StsAdmin.SPStsAdmin.RunOperation(SPGlobalAdmin globalAdmin, String strOperation, StringDictionary keyValues, SPParamCollection pars)  

    11/28/2011 19:33:10.25 STSADM.EXE (0x1608)                     0x1480 ULS Logging                   Unified Logging Service       2pso Verbose Released an item in Perfmon Memory  

    11/28/2011 19:33:10.72 OWSTIMER.EXE (0x0A40)                   0x11BC ULS Logging                   Unified Logging Service       3oyg Verbose Refreshing ULS config objects  

    11/28/2011 19:33:10.72 OWSTIMER.EXE (0x0A40)                   0x11BC ULS Logging                   Unified Logging Service       3oyg Verbose Refreshing ULS config objects  

    11/28/2011 19:33:10.72 OWSTIMER.EXE (0x0A40)                   0x11BC ULS Logging                   Unified Logging Service       3oyg Verbose Refreshing ULS config objects  

    11/28/2011 19:33:11.20 OWSTIMER.EXE (0x0A40)                   0x0A48 Windows SharePoint Services   Timer                         5utp Verbose Scheduled timer job Variations Propagate Site Job Definition, id {842E2C16-3A7D-4DA7-9D9A-A214C6BE05F0} at 28 Nov 2011 19:34:11 -0500 (now is 28 Nov 2011 19:33:11 -0500)  

    11/28/2011 19:33:12.19 STSADM.EXE (0x1608)                     0x15C4 ULS Logging                   Unified Logging Service       41i1 Verbose Performing Terminate from PROCESS_DETACH  

    11/28/2011 19:33:12.19 STSADM.EXE (0x1608)                     0x15C4 ULS Logging                   Unified Logging Service       8wsw High     Now terminating ULS (STSADM.EXE, Microsoft.Office.Server.Native.dll)  

    11/28/2011 19:33:12.20 STSADM.EXE (0x1608)                     0x15C4 ULS Logging                   Unified Logging Service       41i1 Verbose Performing Terminate from PROCESS_DETACH  

    11/28/2011 19:33:12.20 STSADM.EXE (0x1608)                     0x15C4 ULS Logging                   Unified Logging Service       8wsw High     Now terminating ULS (STSADM.EXE, onetnative.dll)  

    11/28/2011 19:33:12.38 mssearch.exe (0x0DC8)                   0x013C Search Server                 MS Search Propagation         0 Verbose SQL: {? = call dbo.proc_MSS_PropagationQueryServerPickUpNewPropagationItems(?,?)}  

    11/28/2011 19:33:12.38 mssearch.exe (0x0DC8)                   0x013C Search Server                 MS Search Propagation         0 Verbose 'f795d4e3...', 'Portal_Content', index receiver:               processing propagated tasks (0)  

    11/28/2011 19:33:12.38 mssearch.exe (0x0DC8)                   0x013C Search Server                 MS Search Propagation         0 Verbose 'f795d4e3...', 'Portal_Content', index receiver:               cleaning up completed items from shadow index queue  

    11/28/2011 19:33:12.38 mssearch.exe (0x0DC8)                   0x013C Search Server                 MS Search Propagation         0 Verbose 'f795d4e3...', 'Portal_Content', propagation task receiver:    processing propagated tasks (0, reset only false)  

    11/28/2011 19:33:12.38 mssearch.exe (0x0DC8)                   0x013C Search Server                 MS Search Propagation         0 Verbose 'f795d4e3...', 'Portal_Content', index receiver:               worker thread callback (0 items in shadow index queue)  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0A48 Windows SharePoint Services   Timer                         5utp Verbose Scheduled timer job Config Refresh, id {87B20DC1-11D1-4530-BBAF-211C295298CA} at 28 Nov 2011 19:33:30 -0500 (now is 28 Nov 2011 19:33:15 -0500)  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0768 Windows SharePoint Services   Topology                       88b9 Verbose Determining if the current user is a SharePoint Farm Administrator  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0768 Windows SharePoint Services   Timer                         8e45 Verbose Begin invoke timer job Config Refresh, id {87B20DC1-11D1-4530-BBAF-211C295298CA}, DB n/a  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0768 Windows SharePoint Services   Database                       880l Verbose ConnectionString: 'Data Source=its-sql08-q01;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False'    ConnectionState: Closed ConnectionTimeout: 15  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0768                               1624                           8acb Verbose Reverting to process identity  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0768                               1624                           8acc Verbose Current user before SqlConnection.Open: Name: farmAdmin SID: S-1-5-21-1409082233-776561741-725345543-97050 ImpersonationLevel: None  

    11/28/2011 19:33:15.20 OWSTIMER.EXE (0x0A40)                   0x0768                        

    Tuesday, November 29, 2011 4:44 AM

Answers

  • I requested from our DBA's to delete the pre-created database and allow SharePoint to create it and elevate my permissions accordingly........ IT WORKED. What I don't understand with the pre-created database is that I was successfully creating the Web App but not the Site Collection? Hmmmmmmmm. Oh well. Not sure I understand that one. Thanks to everyone that responded.
    • Marked as answer by mwhite01 Thursday, December 1, 2011 6:22 PM
    Thursday, December 1, 2011 6:22 PM

All replies

  • Hi,

    Did you just install a WSS service pack or a security update before? This issue may occur if the content databases in Windows SharePoint Services are not updated correctly. Please refer to this: http://support.microsoft.com/kb/841216 .

    Another main cause of this problem is the about SQL Server database, please check the options in this link: http://sharepointsearch.com/cs/blogs/sharepointblogs/archive/2007/11/21/hresult-0x80040e14-when-added-items-to-sharepoint.aspx .

    If the problem persistent, try to increase the connection time between SQL and SharePoint: http://pcfromdc.blogspot.com/2011/03/increase-time-before-sql-connection.html . Also you can try to create site collection on another web application to see if the problem still exists.

    Thanks,
    • Edited by Wayne Fan Tuesday, November 29, 2011 10:41 AM
    Tuesday, November 29, 2011 10:09 AM
  • Hi,

    Try creating using STSADM command.

    Use STSADM createweb


    Thanks, Rahul Rashu
    Wednesday, November 30, 2011 3:26 AM
  • I have modified the SQL connection time-out. Executed the stsadm -o upgrade and examined the SQL Server in case the Transaction Logs were full or the mdf, ldf files could not grow. Still nothing. I did try creating the Web application and Site Collection using stsadm but recieved the same error. Any other troubleshooting tips?

    Note that this is a pre-created database which does attached successfully with the web app.

     

    The error from the command line is as follows:

    The IIS Web Site was extended with Windows SharePoint Services, but the followin

    g error occurs in creating the default site "http://INeedATopLevelSiteCollection/"

    . Please correct the input and try to create the default site again. Error: Exce

    ption from HRESULT: 0x80040E14

    • Edited by mwhite01 Thursday, December 1, 2011 5:50 PM
    Thursday, December 1, 2011 5:36 PM
  • I requested from our DBA's to delete the pre-created database and allow SharePoint to create it and elevate my permissions accordingly........ IT WORKED. What I don't understand with the pre-created database is that I was successfully creating the Web App but not the Site Collection? Hmmmmmmmm. Oh well. Not sure I understand that one. Thanks to everyone that responded.
    • Marked as answer by mwhite01 Thursday, December 1, 2011 6:22 PM
    Thursday, December 1, 2011 6:22 PM