We have installed MAPS onto our development machine and it has disabled one of our SQL Server 2000 instances. We have a few instances on the server but only one is disabled. When I say disabled, it can be accessed via the Management Tool on that machine and accessed through webpages. However when we try to connect remotely (different machine, same domain and site) to the SQL instance, we can't. We get an error 26 message. Any ideas on what to check?
Is the affected instance configured to listen on a static port number that is perhaps being used by the MAP toolkit?
If so, this:
Should give you the PID of the process listening on the port.
I just had it happen to me, and it was because for some reason, the MAP installation stopped and disabled SQL Server Browser service. I had to manually change start-up type to Automatic and restart it before everything was working again.
This should be documented somewhere, and I'm not sure why it would have to disable it in the first place.