"john clarke" <jclarke@nospam.com> wrote in message
news:ephevV9$FHA.140@TK2MSFTNGP12.phx.gbl...
> Hi, I have made some progress in this.
>
> We have another SQL Active/Passive cluster set up (call them Active1 and
> Passive1) and I exported the two keys from both these Active and Passive
> servers and compared them through file comparison. This would give me
> clues as to what I should be looking for on my original Active0 and
> Passive0 servers.
>
> It seems that the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer] only
> sets up the parameters in the client network utility i.e. tcp/ip and named
> pipe alias for virtual instance. There is no difference between this key
> on both Active1 and Passive1 servers. So I left that key alone on Active0
> and Passive0.
>
> In relation to EM not opening up, I searched for the
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}on the Active0 server and
> found within it a reference to "Microsoft SQL Enterprise Manager SnapIn"
> details. I searched for "Microsoft SQL Enterprise Manager SnapIn" on the
> Passive0 server but could not find it!!!
>
> Why is that??? When [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer]
> was deleted on Passive0, did this cascade delete
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F} ???
>
> Well I exported the CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}key from
> Active0 server and imported it into the Passive0 server, and now EM works.
>
> In relation to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer], I
> compared this key on both Active1 and Passive1. There doesnt seem to be
> much of a difference. These are the differences:
>
> ----------------------------------
> Active1:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]
> "SsrpActiveServer"="JJJ"
>
> Passive1:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]
>
> Note: Here I guess I just remove the "SsrpActiveServer" reference on
> Passive0 ?
> ----------------------------------
> Active1:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\80\Registration]
> "DigitalProductID"=<removed>
> "ProductID"="<removed>"
>
> Passive1:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\80\Registration]
> "DigitalProductID"=<removed>
> "ProductID"="<removed>"
>
> Note: Will this cause issues??? Licensing is different on both servers.
> -----------------------------------
> Active1:
>
> "uptime_pid"=dword:00000d8c
> "uptime_time_utc"=hex:b1,48,31,c7,c4,ff,c5,01
>
> Passive1:
>
> "uptime_pid"=dword:00000ff0
> "uptime_time_utc"=hex:10,88,f5,ba,d0,ff,c5,01
>
> Note: I guess these don't really matter so I'll leave them alone
> ----------------------------------
> Active1:
>
> <nothing>
>
> Passive1:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\JJJ\MSSQLServer\SuperSocketNetLib\Lpc]
> "LPCVersion"=dword:080007f7
>
> Note: What do I do here? What is this LCPVersion? I cant find a reference
> to it on Google.
> ------------------------------------
>
> Any help most appreciated!
>
> Cheers,
> John
>
> "john clarke" <jclarke@nospam.com> wrote in message
> news:uNifJp8$FHA.3568@TK2MSFTNGP09.phx.gbl...
>> Hi, one of our network technicians accidently deleted both the following
>> registry keys on the passive side of our Active\Passive cluster
>> configuration for SQL 2000:
>>
>> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]
>> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer]
>>
>> Since we haven't at this stage started backing up the Passive server,
>> those registry keys can't be recovered from a backup.
>>
>> In trying to resolve this issue, I have exported those keys from the
>> Active server, and imported them onto the Passive server.
>>
>> This obviously isn't working as when I try to start Enterprise Manager, I
>> get a dialog box saying that:
>>
>> Snap-in failed to initialize.
>> Name: <unknown>
>> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
>>
>> Query Analyzer works however.
>>
>> What is recommended in this situation? How can I be guaranteed that the
>> cluster will failover correctly? I havent tested failover yet.
>>
>> Can anyone tell me what the specific differences are between registry
>> keys when comparing the Active server and the Passive server?
>>
>> Any help most appreciated!
>>
>> Many thanks,
>> John
>>
>
>

"john clarke" <jclarke@nospam.com> wrote in message
news:uNifJp8$FHA.3568@TK2MSFTNGP09.phx.gbl...
> Hi, one of our network technicians accidently deleted both the following
> registry keys on the passive side of our Active\Passive cluster
> configuration for SQL 2000:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer]
>
> Since we haven't at this stage started backing up the Passive server,
> those registry keys can't be recovered from a backup.
>
> In trying to resolve this issue, I have exported those keys from the
> Active server, and imported them onto the Passive server.
>
> This obviously isn't working as when I try to start Enterprise Manager, I
> get a dialog box saying that:
>
> Snap-in failed to initialize.
> Name: <unknown>
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
>
> Query Analyzer works however.
>
> What is recommended in this situation? How can I be guaranteed that the
> cluster will failover correctly? I havent tested failover yet.
>
> Can anyone tell me what the specific differences are between registry keys
> when comparing the Active server and the Passive server?
>
> Any help most appreciated!
>
> Many thanks,
> John
>