Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
share|improve this question

1 Answer 1

Is the topology already published or are you publishing it for the first time? This looks like Topology Builder can't communicate with your SQL server. Can you check that it's listening on Named Pipes?

share|improve this answer
    
Its a first time publish. If you look at the last error thats the one in the log file. –  EKS Jun 8 '12 at 22:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.