"Unknown error" when adding content database to 3.0 site with 2.0 data

[EtherealMonkey]

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(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.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.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPSqlCommandFactory sqlcmdFactory, String[] strTables, Int32[] nThroughputs, SPLog logGlobal) at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.EnsureVersionsTable(SqlSession 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(String sqlstrLegacyBuildVersion) at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.get_CanUpgrade() at Microsoft.SharePoint.Upgrade.SPManager.CanUpgrade(Object o) at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.get_CanUpgrade() at Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(SPContentDatabase 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(Object 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.RaisePostBackEvent(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.HttpApplication.IExecutionStep.Execut e() 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_Connection=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_Connection=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]

Okay, I admit I just woke up (after letting this error sit overnight...)

I just now saw that the exception occurs here:

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.

Anyone have any ideas about that?

Again, TIA