Enterprise manager compatibility

6 Jan 2006 2:53 PM

Igor Solodovnikov

Hi

I trying register SQL Server 2005 Express Edition instance in Enterprise
Manager 2000 without success. Enterprise Manager 2000 do see instance and
lists its name in the list of available servers. But connection check
returns error: "SQL Server does not exist or access denied. ConnectionOpen
(Connect())".
Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?

6 Jan 2006 5:10 PM

Erland Sommarskog

Igor Solodovnikov (IgorSolodovni***@discussions.microsoft.com) writes:

> I trying register SQL Server 2005 Express Edition instance in Enterprise
> Manager 2000 without success. Enterprise Manager 2000 do see instance and
> lists its name in the list of available servers. But connection check
> returns error: "SQL Server does not exist or access denied. ConnectionOpen
> (Connect())".
> Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?

No, you cannot connect to SQL 2005 with Enterprise Manager 2000. Query
Analyzer works though. (With some restrictions.)

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

6 Jan 2006 5:28 PM

David Portas

Igor Solodovnikov wrote:

> Hi
>
> I trying register SQL Server 2005 Express Edition instance in Enterprise
> Manager 2000 without success. Enterprise Manager 2000 do see instance and
> lists its name in the list of available servers. But connection check
> returns error: "SQL Server does not exist or access denied. ConnectionOpen
> (Connect())".
> Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?

No. Use SQL Server Management Studio for 2005. SSMS can also manage SQL
Server 2000 instances.

--
David Portas
SQL Server MVP
--