I Installed a new SQL Server 2008 cluster (active/passive) with SP2 and 1 named instance.
The database is running fine but when I want to connect from my client PC using SQL Server Management studio or OSQL (using this to caputure the error message) I get the following message:
[SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[SQL Server Native Client 10.0]Login timeout expired
[SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server
is configured to allow remote connections. For more information see SQL Server Books Online.
The strange thing is, that If I use management server or OSQL to connect to the same server without the named instance, I get a connection to the named instance (probably cause it sees this instance as the default instance?, but correct me if I'm wrong here!) so I don't think it's a firewall/network issue.
Some info : Using port 1433 to connect (no dynamic ports). The SQL Server browser services is running (on both nodes) and the "Allow remote connections to this server" option is on. The client I use to connect to the server is a SQL Server 2008 client, also updated with SP2.
What am I doing wrong?