We are currently installing a CS 2007 for a client. I have successfully completed the installation of CS and ran into some problems when running the Configuration Wizard.
The log file contains the following [excerpt]:
[09:21:14 INFO] Beginning configuration of feature Administration Database (Feature.MS.CS.Admin).
[09:21:29 INFO] Database 'MSCS_Admin' exists on server 'SHOP'
[09:21:29 INFO] The ComparisonStyle for Database 'MSCS_Admin' is 196609
[09:21:29 ERROR] CSConfig failed during configuration of feature Administration Database (Feature.MS.CS.Admin).
[09:21:29 ERROR] Exception occured during feature configuration: Microsoft.CommerceServer.Internal.Config.ConfigurationException: Incorrect syntax near '0x0a0d'.
Must declare the scalar variable "@resourceType".
Must declare the scalar variable "@resourceType".
...
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.CommerceServer.Internal.ServerUtility.ExecuteSqlScriptFromString(SqlConnection connection, SqlTransaction transaction, String sqlScriptContents)
at Microsoft.CommerceServer.Internal.ServerUtility.ExecuteSqlScript(SqlConnection connection, SqlTransaction transaction, String sqlFileName)
at Microsoft.CommerceServer.Internal.ServerUtility.ExecuteSqlScript(String connectionString, String sqlFileName)
at Microsoft.CommerceServer.Internal.Config.DBConfig.ExecuteSqlScript(String connectionString, String scriptFilePath)
--- End of inner exception stack trace ---
at Microsoft.CommerceServer.Internal.Config.DBConfig.ExecuteSqlScript(String connectionString, String scriptFilePath)
at Microsoft.CommerceServer.Internal.Config.AdminConfig.ConfigureAdminDB()
at Microsoft.CommerceServer.Internal.Config.AdminConfig.Configure()
at Microsoft.CommerceServer.Internal.Config.ConfigurationDriver.ConfigureHelper(List`1 orderedListOfFeatures).
[09:21:29 INFO] Exception was non-fatal. Beginning rollback.
Followed by a couple of other undeclared variables.
This error comes from the SQL Server, right
The MSCS_Admin database is created by the wizard, but no tables or anything else is added to it.
The server is pretty standard; Windows 2003 Server Standard Edition and SQL Server 2005 Standard Edition as well.
[Edit]
Okay, so I figured out that the error relates to the admin_schema.sql file. Any ideas on why it's filled with junk It looks to be in utf-8 or something, but SQL Server should be able to handle that, right
Configuration Wizard (Admin database) fails
Duncan Smith 1974
Turns out the problem wasn't the installation but the file transfer. The client uploaded the whole installation directory through FTP and somehow a couple of files got corrupted during the transfer. I replaced the admin_schema.sql and admin_schema_increment.sql with the files on the CD and that solved the problem.