IMHO replication can be even more of a royal PITA, clustering is fairly smooth as long as you know\understand the technology!

not worried about the database, just need to enumerate the RS instance registry keys on the server where RS is installed, this will provide the info required

parthi-1705 (8/25/2010)

It is just the situation that was given to me, it may be due to some more data might have up added additionally or due...

Ya, wmi is good but you can get just about any info from the registry ( if you know which keys to find it in) and SQL Server provides a...

That doesn't really work if the RS database is remote to the RS instance. It also makes assumptions regarding the naming context of the RS database.

You're welcome 😉

Not just the OS but the version of SQL too. You'll have to select the sql server version and bind to the appropriate keys in the registry!

Not just the OS but the version of SQL too. You'll have to select the sql server version and bind to the appropriate keys in the registry!

You could use xp_regread and parse the RS instance name keys in the registry!

The thing is, in a multi node cluster the passive nodes are patched. The passive node has no active disk resources so it should only ever choose the C drive,...

I have compared these before and there seems little difference. You can check the comparisons at these links

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx#scalability

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

There are some items in Enterprise only but they werent there in 2005...

hmm, can't see anything wrong there. At this point i think i would be tempted to stop the ArcSDE services that use the sde user and do the following

1/ Drop...

Mirroring requires Standard or Enterprise editions of 2005\2008

No, that's not how clustering works. Separate storage is required for each instance and ultimately its...

are you connecting to the database engine with SQL Server or Windows authentication?