Commerce Server 2007 sp1 install - Longest Error I have Seen. (Commerce Server 2007 Error code: Incorrect syntax near '0x0a0d'.) Fix.

So I and my coworkers (Joe Levi and Angela Perry) were fast installing Commerce Server 2007 sp1(you know I shouldn't leave out the sp1. It gives it an edge.(besides that I could get sued!)) We arrived at the 8 minute mark of go ahead and create my database when this happened:

 

 

"---------------------------
Error
---------------------------
An error occurred when configuring the feature 'Administration Database'. The configuration log file may have more details about the error.

Error Summary:

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_Sites_s_Name".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_errstr1".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@site".

Must declare the scalar variable "@res_id".

Must declare the scalar variable "@localized_string_errstr4".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

The variable name '@site_id' has already been declared. Variable names must be unique within a query batch or stored procedure.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_errstr5".

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@res_id".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_connstr_db_Catalog".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_num_full_text_catalogs".

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_AppDefaultConfig".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_S_BizTalkSourceQualifierID".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_S_BizTalkOrderDocType".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_S_BizTalkSubmittypeQueue".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_S_WeightMeasure".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_SitePrivacyOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_CurrencyDisplayOrderOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_AnonymousUserDefaultCatalogSet".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_AddItemRedirectOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_PaymentOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_ShipToLevelOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_BaseCurrencyLocale".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_SiteTicketOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_HostNameCorrectionOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_AltCurrencySymbol".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_f_AltCurrencyConversionRate".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_AltCurrencyCode".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_SMTPServerName".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_DelegatedAdminOptions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_RequiresASCIIIdentifiers".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_connstr_db_TransactionConfig".

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_Transactions".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_connstr_db_Campaigns".

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_BDSecurity".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_AuthManager".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_Logon_Form".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_u_cache_size".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_auth_profile_name".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_Auth_HelperDir".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_Help_Form".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_Migration_Form".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_AutoCookie_Form".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_d_CookieExpirationDate".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_AuthManager_EncryptionKey".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_u_CookieDomain_Scope".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_max_err_count".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_delivery_method".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_msg_per_hour".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_pcf_file".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_perf_interval".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_NumOfRetries".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_i_Interval".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_GlobalDatawarehouse".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_connstr_db_dw".

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_connstr_db_Analysis".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_ConnStr_OLAP".

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_ConnStr_OLAP_HA".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_SiteDatawarehouse".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_BizDataService".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_ExtendedProps_s_Description_s_ProfileServiceConnectionString".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@localized_string_SystemProps_s_Description_Address".

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Incorrect syntax near '0x0a0d'.

Must declare the scalar variable "@s_CurrentVersion".

Must declare the scalar variable "@s_CurrentVersion".

Must declare the scalar variable "@s_CurrentVersion".

Must declare the scalar variable "@s_CurrentVersion".

Must declare the scalar variable "@s_CurrentVersion".

Must declare the scalar variable "@s_CurrentVersion".

---------------------------
OK  
--------------------------- "

 

If you stuck around this long. Means you either read the entire error and you are a Microsoft Premier support professional or you are just about to hit that comment button and send me an email saying dude that is a error when creating a database and you don't have proper permissions. Yes I know that and that last statement really was one sentence.

Mostly the reason for this post is showing you the length and sheer wowness (Angela I know "wowness" is very poor SEO. However I am assuming Joe is laughing.) of the error. The only way to correct this error that I know (because I am not a SQL admin (even though I play one at another job)) is to run the sql scripts that were used to create the database in the first place one at a time until the database stops freaking out.

This little rant brought to you by Commerce Server 2007  and the corresponding Service pack 1.

**Update**

 This error is fixed by replacing the admin_schema.sql and admin_schema_increment.sql with the files on the CD or checking the MD5 Sum when you ftp or copy the files to another location.