locked
Create enterprise pool fails to "Failure [0xC3EC7840] Failed to create SQL database." RRS feed

  • Question

  • Hi!

    I'm trying to create a new pool for my installation but for some reason the create enterprise pool wizard is failing every time with the following error:

    Database File Path:
    C:\LC Data\
    Database Transaction Log File Path: C:\LC Log\
    Server Role Account: MYDOMAIN\RTCHSUniversalServices
    Administrator Role Account: MYDOMAN\RTCUniversalServerAdmins
    Readonly Role Account: None
    Force Clean: True
    Script Command Line: cscript.exe //U "D:\setup\i386\dbsetup\dbsetup.wsf" /clean /sqlserver:"TRE-SQL" /sqlfilepath:"D:\setup\i386\dbsetup" /dbpath:"C:\LC Data\" /logpath:"C:\LC Log\" /dyndbpath:"C:\LC Data\" /dynlogpath:"C:\LC Log\" /serveracct:"MYDOMAIN\RTCHSUniversalServices" /adminacct:"MYDOMAIN\RTCUniversalServerAdmins" /role:"ee" /verbose
    Script Output: Microsoft (R) Windows Script Host Version 5.6
    Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

    Connecting to SQL Server on TRE-SQL
    SQL validation: Reconfigure encountered no errors, and SQL version is acceptable: 10.0.1600.22
    (Database rtcdyn doesn't exist.)
    Creating database rtcdyn
    DbFile : PhysicalName = c:\lc data\rtcdyn.mdf
    LogFile: PhysicalName = c:\lc log\rtcdyn.ldf
    Executing resource SetDbOptions on rtcdyn
    Executing batch dbcommon.sql on rtcdyn
    Executing batch types.sql on rtcdyn
    Executing batch roles.sql on rtcdyn
    Executing batch dbrtcdyn.sql on rtcdyn
    (Database rtc doesn't exist.)
    Creating database rtc
    DbFile : PhysicalName = c:\lc data\rtc.mdf
    LogFile: PhysicalName = c:\lc log\rtc.ldf
    Error executing alter database [rtc] set recovery simple, auto_close off, auto_shrink off, auto_create_statistics on, auto_update_statistics on, ansi_nulls on, ansi_padding on, ansi_warnings on, arithabort on, concat_null_yields_null on, quoted_identifier on, numeric_roundabort off
    [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'of'.

    What might be causing this and are there any solutions on how to fix it?

    -- Ville
    Tuesday, March 3, 2009 2:10 PM

All replies

  • Tried to run the following:

    D:\setup\i386>cd dbsetup

    D:\setup\i386\dbsetup>cscript dbsetup.wsf /clean /sqlserver:tre-sql
    Microsoft (R) Windows Script Host Version 5.6
    Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

    Connecting to SQL Server on tre-sql
    (Database rtcdyn doesn't exist.)
    Creating database rtcdyn
    Executing resource SetDbOptions on rtcdyn
    Executing batch dbcommon.sql on rtcdyn
    Executing batch types.sql on rtcdyn
    Executing batch roles.sql on rtcdyn
    Executing batch dbrtcdyn.sql on rtcdyn
    (Database rtc doesn't exist.)
    Creating database rtc
    Error executing alter database [rtc] set     recovery                simple,
    auto_close              off,    auto_shrink             off,    auto_create_stat
    istics  on,    auto_update_statistics  on,    ansi_nulls              on,    ans
    i_padding            on,    ansi_warnings           on,    arithabort
       on,    concat_null_yields_null on,    quoted_identifier       on,    numeric_
    roundabort      off
    [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword
     'of'.

    And still the same error, I'm really running out of options here :)

    -- Ville
    Tuesday, March 3, 2009 3:17 PM