Tuesday, August 21, 2012

Lync Topology publishing error

Error: Script failed (code "ERROR_VALIDATE_BAD_SQL_VERSION") when installing "CentralMgmtStore" on "<systenmane>.lynctest.com". For details, see the following log file: "C:\Users\Administrator.LYNCTEST\AppData\Local\Temp\2\Create-CentralMgmtStore-<systemname>.lynctest.com-[2012_08_21][14_31_26].log"

Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "Cannot open database "xds" requested by the login. The login failed.
Login failed for user 'LYNCTEST\Administrator'."

Running script: C:\Windows\system32\cscript.exe //Nologo "C:\Program Files\Common Files\Microsoft Lync Server 2010\DbSetup\xdssetup.wsf" /dbexists /sqlserver:<systemname>.lynctest.com /publisheracct:LYNCTEST\RTCUniversalServerAdmins /replicatoracct:LYNCTEST\RTCUniversalConfigReplicator /consumeracct:LYNCTEST\RTCUniversalReadOnlyAdmins /role:master /verbose
---------------
Installed SQL Server 2005 Backward Compatibility version is 8.05.2312
Connecting to SQL Server on <systemname>.lynctest.com
SqlMajorVersion : 10
SqlMinorVersion : 0
SqlBuildNo : 1600
Error: SQL version is not high enough. SQL Server 2005 must be major version 9 and build 4035(SP3) or higher. SQL Server 2008 must be major version 10 and build 2531(SP1) or higher. SQL Server 2008 R2 must be minor version 50 and build 1600 or higher. This SQL Server is major version 10, minor version 0 and build 1600.
---------------
Exit code: ERROR_VALIDATE_BAD_SQL_VERSION (-28)
When running /dbexists, non-zero exit codes are not necessarily errors
---------------

Running script: C:\Windows\system32\cscript.exe //Nologo "C:\Program Files\Common Files\Microsoft Lync Server 2010\DbSetup\xdssetup.wsf" /sqlserver:<systemname>.lynctest.com /publisheracct:LYNCTEST\RTCUniversalServerAdmins /replicatoracct:LYNCTEST\RTCUniversalConfigReplicator /consumeracct:LYNCTEST\RTCUniversalReadOnlyAdmins /dbpath:"C:\CsData\CentralMgmtStore\(default)\dbpath" /logpath:"C:\CsData\CentralMgmtStore\(default)\logpath" /role:master /verbose
---------------
Installed SQL Server 2005 Backward Compatibility version is 8.05.2312
Connecting to SQL Server on <systemname>.lynctest.com
SqlMajorVersion : 10
SqlMinorVersion : 0
SqlBuildNo : 1600
Error: SQL version is not high enough. SQL Server 2005 must be major version 9 and build 4035(SP3) or higher. SQL Server 2008 must be major version 10 and build 2531(SP1) or higher. SQL Server 2008 R2 must be minor version 50 and build 1600 or higher. This SQL Server is major version 10, minor version 0 and build 1600.
---------------
Exit code: ERROR_VALIDATE_BAD_SQL_VERSION (-28)

------------------
Other relative errors

Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "Cannot open database "xds" requested by the login. The login failed.
Login failed for user 'LYNCTEST\Administrator'."

Error: Script failed (code "ERROR_VALIDATE_BAD_SQL_VERSION") when installing "CentralMgmtStore" on "<Systemname>.lynctest.com". For details, see the following log file: "C:\Users\Administrator.LYNCTEST\AppData\Local\Temp\2\Create-CentralMgmtStore-<Systemname>.lynctest.com-[2012_08_21][14_44_59].log"
  and in this doc it is showing the DB is not
compatible with the version
"Error: SQL version is not high enough. SQL Server 2005 must be major version 9 and build 4035(SP3) or higher. SQL Server 2008 must be major version 10 and build 2531(SP1) or higher. SQL Server 2008 R2 must be minor version 50 and build 1600 or higher. This SQL Server is major version 10, minor version 0 and build 1600."

Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "Cannot open database "xds" requested by the login. The login failed.
Login failed for user 'LYNCTEST\Administrator'."

-----------------------
One solution  as below

Solution :

The first part of  errors mainly due to the SQL server connectivity and  second part is with the compatibility issue
. Check the SQL server whether named pipe and TCP/IP configuration have enabled or not. Also check whether  the required ports are enabled on the SQL server firewall, you will be able to solve the first part.

Install the service pack of SQL  2008 to rectify the second issue


No comments:

Post a Comment