Monday, August 27, 2012

OCS Addressbook error (Resolved)

While expanding a distribution list OCS user recieve the below error

Error 1
Cannot synchronize with the corporate address book. This may be because the proxy server setting in your web browser does not allow access to the address book. If the problem persists, contact your system administrator.
Error 2
Distribution group service could not perform this action .Contact system administrator to investigate this problem.

Case study :
The issue happened because of the internal certificate which is renewed.
I took the configuration information of the MOC client and took the internal Url entry
Eg. Internal From Server :https://ocspool.mydomain.com.com/Abs/Int/Handler.
While browsing this URL I found it was not opening. Then checked the IIS in one frontend server and checked the certificate associated to that (edit bindings-option) Select new certificate and clicked OK.

And Issue is resolved :)

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