Trying to link a 2003 website with a 2008 R2 SQL database.
I setup the Client Tools for the 2003 server so it could (theoretically) establish a connection with a 2008R2 SQL instance. This is a 2008R2 Express install.
The latest error I've been getting is:
Microsoft SQL Server Native Client Version 10.50.1600
Running connectivity tests...
[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[Microsoft][SQL Server Native Client 10.0]Login timeout expired
[Microsoft][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 firewall is off. The named pipes TCP/IP and other connectors are all turned on. I can't connect to this server instance (to browse and see databases from any ODBE or connection string through a .UDL file) from any machine.
Anyone have any ideas? Is it possible to get these two different machines or server types to talk to each other?