I'm trying to use SSMS to connect to previously configured remote MSDE servers. I can connect just fine using Enterprise Manager to these remote machines. Using Management Studio, I can only connect to some of the machines. And no matter what combination of authorization/protocol I select, I still cannot connect to certain machines. Some machines, configured with MSDE exactly as others, I can connect to.
What is SSMS doing differently than Enterprise Manager Can somebody give me some clues of what to check Please
The error messages in SSMS are always along the lines of:
===================================
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.
===================================
This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IConnectionValidator.CheckConnection(IDbConnection conn)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.testConnection_Click(Object sender, EventArgs e)
SQL Management Studio (RTM) Connect Problem
Nagaraju Palla MSFT
SSMS can only connect to SQL Server 2005 servers (including Express servers) and SQL Server 2000 servers (including SQL Server 2000 Desktop Engine servers). If your server is actually a SQL Server 7.0 server or earlier, SSMS can't work with it, but SEM can.
We see the error about the version whenever the server major version number is not 8 or 9. You can find out your server's version by executing the following T-SQL:
select @@version