OCS 2007 QoE installation failing
-
Friday, October 02, 2009 11:07 PMHi There,
I tried to test QoE server to see what information I could get out. But by some reasons the database operations failing.
At first I got the error:
Error executing batch aggregatorSprocDef.sql on QoEMetrics
[Microsoft][ODBC SQL Server Driver][SQL Server]'US_ENGLISH' is not a valid official language name.
But that I fixed, by renaming "US_ENGLISH" --> "us_english" in the aggregatorSprocDef.sql
But after that I have the following error:
Error executing batch aggregatorSprocDef.sql on QoEMetrics
[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@MediaLineKey".
I'm not SQL expert so I have no clue which part of .SQL file should be fixed.
Anyone have an idea to fix this?
All Replies
-
Tuesday, October 13, 2009 8:06 AMModerator
Hi
Per your description, you will install the QOE monitoring server, you can refer to below link learn more about it.
http://technet.microsoft.com/en-us/library/dd627288.aspx
Especially, about the Infrastructure requirements and prerequisites and the How to deploy it.
http://technet.microsoft.com/en-us/library/bb963991.aspx
http://technet.microsoft.com/en-us/library/bb894434.aspx
About SQL server installed you can refer to bleow.
http://technet.microsoft.com/en-us/library/ms143219(SQL.90).aspx
Regards!