MSDE and SQL Server 2005 combinational problem
-
This is probably the first good topic in here :) I discovered a subtle bug when installing MSDE and SQL Server 2005 on one machine. If you install SQL 2005 first and MSDE after that you will no longer be able to connect to the SQL 2005 server using named pipes. If you then enable network protocols on the MSDE server, the problem is solved, but you are able to connect to the MSDE over the network, which isn't something you would normally do. I also discovered that the same problem happens when you combine SQL 2005 Express and SQL server standard or better on the same machine. The easiest way to prevent this problem, I Discovered, is to install the applications that use MSDE first and then install SQL 2005.
WM.
Yaaarrrr What about weapons of mass-construction?