Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

Is the affected instance configured to listen on a static port number that is perhaps being used by the MAP toolkit?

If so, this:

netstat -ao | find "<port>" 

Should give you the PID of the process listening on the port.

share|improve this answer
    
I will pass the information onto our services team and see what they come back with. –  MiscellaneousUser Apr 23 '12 at 13:00

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.

share|improve this answer
1  
I guess because it had to install an instance of SQL Server 2008 Express. But that should just be temporary. Anyways, without Browser, you won't be able to remotely access any named instances. I suspect you were only able to access your main MSSQLSERVER instances. –  Diane Jun 4 '12 at 23:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.