CCE 5.0 Problem Creating AS Contact & Media store Datbase

[davidsahim]

Hello all,
I am getting the following when attemting to Create the 2 Dabased ffrom the CCE Control Panel wich resided on a diferent server as the SQL 2005 server.


-- Please wait while the contents of the sql scripts execute...
-- Database create process started at : 11/4/2010 11:47:26 AM.
-- Create Database: ExecuteDatabaseScripts entry point.
-- Using C:\Program Files\Avaya\Contact Center Express\Desktop\Contact Center Express Control Panel\Databases\ASContact\DatabaseInstructions.xml
-- Attempting connection string with Initial Catalog.
-- Warning: Initial Catalog does not exist. Using connection string without Initial Catalog.
-- Begin executing database scripts for create case.
-- Last known database version is 0.0.0.0
-- Performing action sequence AS ASContact database create.sql
ASCCEDBDeploymentUtilityPlugin.Database_Deployment _And_Management.DatabaseInstructions.ExecuteTheScr ipt: System.IO.FileLoadException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
File name: 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
at System.Reflection.Assembly._GetType(String name, Boolean throwOnError, Boolean ignoreCase)
at System.Reflection.Assembly.GetType(String name, Boolean throwOnError)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand)
at ASCCEDBDeploymentUtilityPlugin.Database_Deployment _And_Management.DatabaseManagement.ExecuteTheScrip t(XmlDocument xmlDoc, String databaseVersion, String filePath, String connectionString, Boolean runSQLScript)

-- End executing database scripts for create case with errors.
-- Job completed at 11/4/2010 11:47:27 AM with 2 errors, 1 warnings and 6 messages in 0.4843688 seconds.

[mandalapu]

Hi,

Please verify if the datbase machine is accessible from CCE machine and verify if the credentials are fine. If the above does not help, I would suggest that you either create an online Service Request at http://support.avaya.com/ >> "Create Service Request", or call into the support center to ask this technical question , we would be glad to assist you further.

Thanks,