Help:MS SQL 2000 SP4 dont run !

I have installed MS SQL 2000 Personal Edition on XP SP2 and It works !
I verified its version :
SQL Server 2000 Original Release 8.00.194 RTM

When I try to install SP4 after extracting locally I see the first windows for a moment and then nothing appens !

x86\setup\setupsql.exe process remain in task manager without make nothing.

Someone can help me ?Check windows event log & SQL error lgo for any information.
Also try to download the file again, make sure you're using correct SP4 file from MS.|||Thank you !

I have found only this warning in eventlog

SuperSocket info: (SpnRegister) : Error 1355.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

But I think it's because I have no SP4 installed .
When I try to install SP4 I have no message in any logs.
Process do nothing because, I suppose , It's waiting for a Dialog Window that I don't see :-(|||There was a problem on the Clustered environment previously as per KBA http://support.microsoft.com/?id=303411 , but yours it not that case. Anyway try downloading SP3a for SQL 2000 and apply, then use SP4.

BTW mention the filename of SP4 you're using to apply.|||I have the same problem with SP3.
File name is SQL2000-KB884525-SP4-x86-ENU.EXE
May be MSI ? I have 3.1
Or IIS ? I have 5.1
How can I remove IIS ?

Help: Messages stuck in sys.transmission_queue

For some reason the messages are stuck at sys.transmission_queue. The transmission status seems to be null. I verified all the Queues and they hae the values of (is_receive_enables = 1, is_enqueue_enabled = 1, is_activation_enabled = 0)

I have set up the service broker on different domain and have bidirectional ports open to receive messages.

I can send and receive messages, when I run the same service broker setup scripts at the machines that belongs to same domain .

any help appreciated.

Do you have anything picking up the messages from the queues? You have is_activation_enabled = 0. Have you tried associating an sp with a queue ?

Tim|||

Thanks Tim... I figured out the issue. The 2 servers we used are in different domain and have firewall. The ports open for service broker were not bidirectional.

Help: Messages stuck in sys.transmission_queue

For some reason the messages are stuck at sys.transmission_queue. The transmission status seems to be null. I verified all the Queues and they hae the values of (is_receive_enables = 1, is_enqueue_enabled = 1, is_activation_enabled = 0)

I have set up the service broker on different domain and have bidirectional ports open to receive messages.

I can send and receive messages, when I run the same service broker setup scripts at the machines that belongs to same domain .

any help appreciated.

Do you have anything picking up the messages from the queues? You have is_activation_enabled = 0. Have you tried associating an sp with a queue ?

Tim|||

Thanks Tim... I figured out the issue. The 2 servers we used are in different domain and have firewall. The ports open for service broker were not bidirectional.