Home / server / Questions / 172711
In Process
Sam
Asked: 2010-08-21 03:53:36 +0800 CST

Problems with side-by-side-installation of SQL Server 2008R2 and MSDE?

  • 772

I installed SQL Server 2008 R2 Standard on a server, without knowing there was an installation of MSDE (Microsoft SQL Server 2000 Desktop Engine).

After I installed SQL Server 2008 R2 the client software of the MSDE won't start anymore, instead they show the error (translated) "Connection to policy mananger component failed".

(strange, though, on the server itself the client software seems still to work).

Any ideas what I might have broken with the side-by-side installation of SQL Server 2008R2?
And (hopyfully) how to repair it?

sql-server installation sql-server-2008-r2

1 Answers

  1. I would ensure that the SQL Browser service is running and that the appropriate ports are open on the firewall(s) between the instances and the remote machines that will be connecting. If you can connect to a named instance locally but not remotely, the likeliest problem is a firewall, either the local software firewall or a hardware firewall/switch somewhere on the network.

    • 0