When trying to add a content database to an extended site, the action
results in a message of "unknown error" being shown in the "Central
Administration" utility.
Here is the log (I trimmed the date/time, other regions to "clean up"
the formatting):
> Adding S-1-5-20 to the role, db_owner, in the database,
> STS_MachineName_987654321.
> System.Data.SqlClient.SqlException: DDL statement is not allowed.
> 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(TdsParserStateObje ct
> 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.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand
> command)
> SqlError: 'DDL statement is not allowed.' Source: '.Net SqlClient
> Data Provider' Number: 2782 State: 1 Class: 16 Procedure: '' LineNumber:
> 4 Server: 'MachineName\Sharepoint'
> Unknown SQL Exception 2782 occured. Additional error information from
> SQL Server is included below. DDL statement is not allowed.
> at
> Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethod Core(SqlSession
> sqlSession, ISqlSession isqlSession, String sqlscript,
> SPSqlCommandFactory sqlcmdFactory, String[] strTables, Int32[]
> nThroughputs, SPLog logGlobal) at
> Microsoft.SharePoint.Upgrade.SPDatabaseSequence.EnsureVersionsTable(SqlSess ion
> sqlSession, ISqlSession isqlSession, SPLog log) at
> Microsoft.SharePoint.Upgrade.SPDatabaseSequence.SetVersion(Guid id,
> Version version) at
> Microsoft.SharePoint.Upgrade.SPDatabaseWssSequence.set_BuildVersion(Version
> value) at Microsoft.SharePoint.Upgrade.SPSequence.get_CanUpgrade()
> at
> Microsoft.SharePoint.Upgrade.SPDatabaseWssSequence.InternalCanUpgrade(Strin g
> sqlstrLegacyBuildVersion) at
> Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.get_CanUpgrade()
> at Microsoft.SharePoint.Upgrade.SPManager.CanUpgrade(Object o) at
> Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.get_CanUpgr ade()
> at
> Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(SPConte ntDatabase
> database, Boolean provision, Boolean allowUpgrade) at
> Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(Guid
> newDatabaseId, String strDatabaseServer, String strDatabaseName, String
> strDatabaseUsername, String strDatabasePassword, Int32 warningSiteCount,
> Int32 maximumSiteCount, Int32 status, Boolean provision, Boolean
> allowUpgrade) at
> Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(String
> strDatabaseServer, String strDatabaseName, String strDatabaseUsername,
> String strDatabasePassword, Int32 warningSiteCount, Int32
> maximumSiteCount, Int32 status, Boolean provision, Boolean allowUpgrade)
> at
> Microsoft.SharePoint.ApplicationPages.NewContentDBPage.BtnSubmit_Click(Obje ct
> sender, EventArgs e) at
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) at
> System.Web.UI.WebControls.Button.RaisePostBackEvent(String
> eventArgument) at
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaiseP ostBackEvent(String
> eventArgument) at
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) at
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> at System.Web.UI.Page.ProcessRequest(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> at System.Web.UI.Page.ProcessRequest() at
> System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
> at System.Web.UI.Page.ProcessRequest(HttpContext context) at
> ASP._admin_newcntdb_aspx.ProcessRequest(HttpContext context) at
> System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplicat ion.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
> Boolean& completedSynchronously) at
> System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception
> error) at
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest (HttpContext
> context, AsyncCallback cb, Object extraData) at
> System.Web.HttpRuntimeProcessRequestInternal(HttpWorkerRequest wr)
> at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32
> iWRType)
> ConnectionString:
> 'Server=MachineName\Sharepoint;Database=STS_MachineName_987654321;Trusted_C onnection=yes;App=Windows
> SharePoint Services;Timeout=15' ConnectionState: Open
> ConnectionTimeout: 15
> SqlCommand: ' IF NOT EXISTS (SELECT * FROM
> dbo.sysobjects WHERE id = object_id(N'[dbo].[Versions]') and
> OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN
> CREATE TABLE [dbo].[Versions] ( [VersionId]
> uniqueidentifier NOT NULL, [Version]
> nvarchar(64) NOT NULL, [Id]
> int IDENTITY NOT NULL, [UserName]
> nvarchar(255) NULL, [TimeStamp]
> datetime NULL, [FinalizeTimeStamp]
> datetime NULL, [Mode] int
> NULL, [ModeStack] int NULL,
> [Updates] int DEFAULT 0 NOT NULL,
> [Notes] nvarchar(1024) NULL,
> CONSTRAINT [Versions_PK] PRIMARY KEY CLUSTERED (VersionId,
> Id) ) END ELSE IF NOT
> EXISTS (SELECT * FROM sysobjects join syscolumns on sysobjects.id =
> syscolumns.id WHERE sysobjects.name='Versions' and syscolumns.name =
> 'TimeStamp') BEGIN ALTER TABLE
> [dbo].[Versions] DROP Versions_PK ALTER TABLE
> [dbo].[Versions] ADD Id int IDENTITY NOT
> NULL, UserName nvarchar(255) NULL,
> TimeStamp datetime NULL,
> FinalizeTimeStamp datetime NULL, Mode int
> NULL, ModeStack int NULL,
> Updates int DEFAULT 0 NOT NULL, Notes
> nvarchar(1024) NULL, CONSTRAINT Versions_PK
> PRIMARY KEY CLUSTERED (VersionId, Id) END
> ' CommandType: Text CommandTimeout: 1800
> Deleting the SPPersistedObject, SPContentDatabase
> Name=STS_MachineName_987654321 Parent=SPDatabaseServiceInstance
> Name=Sharepoint.
> Exception Type: System.Data.SqlClient.SqlException Exception Message:
> DDL statement is not allowed.
Specifically this part:
> ConnectionString:
> 'Server=MachineName\Sharepoint;Database=STS_MachineName_987654321;Trusted_C onnection=yes;App=Windows
> SharePoint Services;Timeout=15' ConnectionState: Open
> ConnectionTimeout: 15
The reason that I ask, is that I am able to connect to the SQL server
using the same user that the log records adding the role of db_owner
for.
But, when I connect using the SQL Server Management Studio, I use the
MachineName\SharePoint (not MachineName\Sharepoint) as recorded in the
log.
If this is not the issue, the I hope someone may be able to help me get
this site back online.
TIA
--
EtherealMonkey
------------------------------------------------------------------------
EtherealMonkey's Profile: http://forums.techarena.in/members/150490.htm
View this thread: http://forums.techarena.in/small-business-server/1268478.htm
http://forums.techarena.in
|
