Situation: two workstations (OS = XP, names A and B) with SQL 2005 Express and 2008 R2 Express installed. Workstations are connected to a domain
If, via Management Studio 2008 R2, I try to connect to a SQL instance, from computer A to computer B, I am able to connect to the 2005 instance, but not to the 2008 R2 instance.
I checked all server settings I could find, and they are identical. Yet, every time when trying to connect to the 2008R2 instance, I get the message:
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) (Microsoft SQL Server, Error: 2)
The instance name (computername\instance) is correct (I browsed for the instance, and it does show both the 2005 and 2008R2 instances), and remote connections are allowed. As I said, I see no differences in the settings save intance names...
I have no idea what setting to change to allow for connecting to the 2008R2 instance.... anyone here any suggestions?
View Complete Post