Lync using SQL 2008 R2 SP1 - Publish Topology error
Posted
by
EKS
on Server Fault
See other posts from Server Fault
or by EKS
Published on 2012-06-07T14:05:12Z
Indexed on
2012/06/08
22:42 UTC
Read the original article
Hit count: 320
sql-server-2008-r2
|lync
Error that shows in the web page opened by the Topology builder:
Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Looking in the log file: ( I assume this is the acutal error making it STOP)
Installed SQL Server 2005 Backward Compatibility version is 8.05.1054 Error: SQL Server 2005 Backward Compatibility is not installed or its version is not high enough. SQL Server 2005 Backward Compatability SP2 or higher must be installed.
I have installed SQLServer2005_BC_x64.msi from MS, and cant seem to find this SP2 version.
SQL server is a 2008 R2 SP1. I have also tested with a 2008 SP3 SQL server same error.
Named pippes output via ( OSQL /L)
SQL-2008-1 SQL2
© Server Fault or respective owner