I installed MS SQL 2005 Server Express Edition instance X on SERVER where is
already installed SQL 2000. When I try to connect to SERVER\X from CLIENT
machine in LAN with SQL Server Management Studio Express I get error:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 28 - Server doesn't support
requested protocol) (.Net SqlClient Data Provider)
From the SERVER I connect regulary with SQL Server Management Studio Express
to instance SERVER\X.
SQL Server Express is working, SQL browser is working. It is enabled remote
One more thing I can regulary connect from CLIENT with Enterprise Manager to
SERVER on SQL 2000.
How could I solve this problem?