Hi! I have a Windows Server 2008 64 bit standard running both Microsoft SQL Server 2000, and Microsoft SQL Server 2008, 64 bit. I can't say why, I've inherited it.
If I look in services, I can see both the 2000 version and the 2008 version started, yet when I open Microsoft SQL Server Management Studio 2008, all I can see and connect to is the 2000 installation. How do I access the new version/instance with Management Studio?