Post reply

Unable to set up Share Point 2010 using the DBA created databases

  • July 8, 2011 at 11:00 am

    #253420

    Hi,

    We are setting up Share Point 2010 and following the method "Deploy by using DBA-created databases (SharePoint Server 2010)" from the below link

    http://technet.microsoft.com/en-us/library/cc262869.aspx

    Steps Performed:

    1.[DBA] Create the configuration database and the Central Administration content database using the LATIN1_General_CI_AS_KS_WS collation sequence and set the database owner (dbo) to be the Setup user account.

    2.[Setup] Run Setup on each server computer in the farm. You must run Setup on at least one of these computers by using the Complete installation option. The steps for this option are described in Deploy a single server with SQL Server (SharePoint Server 2010).

    3. [Setup] Do not run the SharePoint Products Configuration Wizard after Setup finishes.

    4. From the SharePoint 2010 Management Shell, use the New-SPConfigurationDatabase command to create a new configuration database, for example:

    New-SPConfigurationDatabase -DatabaseName "SharePoint_Config" -DatabaseServer "SQL-sp01" -Passphrase (ConvertTo-SecureString "MyPassword" -AsPlainText -force) -FarmCredentials (Get-Credential)

    But at step 4, we are getting the below error:

    New-SPConfigurationDatabase : SharePoint_Config on SQL\sp01 contains user-

    defined schema. Databases must be empty before they can be used. Delete all o

    f the tables, stored procedures and other objects or use a different database.

    At line:1 char:28

    + New-SPConfigurationDatabase <<<<

    + CategoryInfo : InvalidData: (Microsoft.Share...urationDatabase:

    SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], SPUncle

    anDatabaseException

    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPCon

    figurationDatabase

  • July 8, 2011 at 12:53 pm

    #1350593

    Did you check you created databases for any user created objects? even if you did not create any objects manually there may be some in model and thus also in your created databases. If there are any object that are not ms shipped then drop them. You can always re-add them after the sharepoint setup is complete.

    SELECT *

    FROM sys.objects

    where is_ms_shipped = 0

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply