Caveat - you may want to check with TAC on this, but I did find this information regarding problems with the SQL Enterprise Manager MMC console not initializing, which is what you are attempting to use to set the SA password:
1. Search the registry for the classid provided in the error you are getting. You will find a key
HKEY_CLASSES_ROOT\CLSID\ (guid related shown in the error message)
2. Under the key click on InProcServer32, you will find the dll, associated
with the GUID.
3. -Unregister the dll, regsvr32 /u dll name
4. -Replace it with the original dll from the CD (I would use Unity CD)
Dang! Sorry that did not work for you!! Since this is happening during the install, I would contact TAC. Reregistering a DLL is usually a safe thing to do (recommend), but having already tried this and not being successful, I would bring in the experts, especially one more versed in SQL than myself.
OK, I've gotten past that issue with a reinstall. Now I have another. When I try to open up the tree in SQL enterprise manager, it won't see anything past (LOCAL) (Windows NT). Have you ever seen this? Also, the SQL systray icon is not there and the service is not running.
So you are not seeing a + sign next to (local) (Windows NT)? Can you right-click it and select Properties? On the General tab, you should see the Autostart policies when the OS starts checked for all (autostart SQL server, the agent, and MSDTC). Did you reboot after the install?
Yes, there's a + and when I click it, below it says (Connection failed check sql server registration properties). If I right click on it and choose properties, it gives me a message that says "The sql server \\LOCAL is not known to be running. Are you sure you wish to connect?" I click yes, it pauses for a minute and then comes back with "A connection could not be established to LOCAL. Reason: SQL server does not exist or access denied."
You need to delete the local SQL Server Registration and create a new registration with the servername. It will be the defalt when you go to create one. Create one by right clicking SQL server group after deleting the local one by right clicking on it..
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...