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?
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 :)
