Problem connecting to SQL 2008 R2

Martin_P

I am getting the following error message when trying to open a database connection to R2...


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)"
Source=".Net SqlClient Data Provider"


I am able to connect to the database via SQL management studio, and also via the SQL Compare GUI - but not from the SDK.

My connection to the database is as follows ...

new ConnectionProperties("my-server\r2", "SQLCompareDev");

I have also tried {IP}\{instance] but get the same error

Finally I can connect to other databases in our environment (SQL 2005) without any problem - so is there an issue with SQL 2008 R2 ?

Cheers

Martin_P

To resolve this issue I had to add a "\" between the database and the instance name, i.e.

"MyInstance\\R2"

Thanks to support for solving this