Connectivity to 2005 and 2008 from same workstation
I have databases on both MSSQL 2005 and 2008. On my workstation I have Microsoft SQL Server Management Studio version 10.0.5500.0. I have set up DSN for both of my databases (1 2005 and 1- 2008) and can use my tool to connect to the 2008 database, but get the following error in my log when I try to test the 2005 connection (this is a peoplesoft specific tool, I can connect with all other tools to both instances). RC=0 Dur=0.000000 XER rtncd=0 **msg=Invalid SQL Server version (minimum is SQL Server 2008)** (SQLSTATE PS078) My Question is: Can you access both MSSQL 2005 and 2008 from the same windows machine using the SQL Server Native Client 10.0? If so, then what am I missing in the setup? I did set up with both the 32-bit and the 64-bit version of odbc.
I did more researching on my tool and both are correct, this particular version of the tool does only support 2008. It didn't do the checking in previous releases, so that's what threw me off. Thanks for your help.
Yeah, you absolutely should be able to connect to 2005 from a 2008 instance of SSMS. I was able to connect to 2000, 2005, 2008 & 2008R2 all from a 2008R2 instance. Connecting down should work just fine. That looks like some kind of command is being run, not simply a connection.