Unity 3.13 setup 2 failed unable to open SQL conn

[admin_2]

I did a new install with the software image downloaded from CCO. I went throught he entire process according to release notes and installation instructions including SQL MSDE SP1 and hot fix, Win2K patch, and NIMDA. After I reboot the server and started the configuration wizard gave me an error "unable to open a SQL connection to the Unity database". I ran syscheck and it shows that it failed on test suite Doh with comments "Unexpected error occured in e:\views\Unity3.1.2.41\un_Doh2\syscheck\DohTests\GetTheDoh.cpp, line:45,hr=:HRESULT 0x80004005.<br>It also failed on Exchange2K test and the Comments are "unable to open a SQL connection to the Unity database"<br><br>First off I did not use E drive to install UNity. The Unity 3.13 image is on my C drive. Where did it refer to drive E? What happens to SQL connection?<br><br>Thanks!<br><br>Chris<br><br>

[#2]

the E drive is a reference to the source code paths, not the path to the install on your hard drive (i.e. our build machines have the source for that module on the E drive).

Couple things come to mind. Can you check via the SQL enterprise manager to see if the UnityDB got created at all? This can happen if you're logged in as a domain admin but that admin is not a member of the local admins group. SysCheck should catch that before the install goes through but I think there's still possible loopholes in there if your a member server if memory serves.

If the UnityDB database isn't there at all, you can create it manually using ConfigMgr found in \commserver\. It has a series of radio buttons on it and the updated version now automatically selects the correct configuration script for each one (which is nice). Just run down through all of them from the top through the routing rules configuration and it should create the DB and allow you to try the 2nd part of setup again.


Jeff Lindborg
Unity Technical Lead/Answer Monkey
Cisco Systems
lindborg@cisco.com
http://www.AnswerMonkey.net (new page for Unity support tools and scripts)

[#3]

Here is what I did:
1. I logon on ad AD Domain administrator account, which is also a member of Local Administrators group

2. There is no UnityDB in the SQL Server Enterprise databases.

3. Ran ConfigMgr.exe. It passed the first two scripts -Database schema and Database Extended scripts. But it failed on the third- configure database scheme. I looked at the log and it shows:
2002-04-28 14:10:03 (AvLogMgrSvr_MC,10007,diag file opened,) LOGMGR OPENDIAGFILE
14:10:03:894 (AvLogMgrSvr_MC,10001,-1,-1) LOGMGR INITIALIZE
14:10:03:895 (AvLogMgrSvr_MC,10002,-1,-1) LOGMGR RUN
14:10:03:894 (AvSystemConfig_MC,1092,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::SetSystemId(void)] entered
14:10:03:895 (AvSystemConfig_MC,1093,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::SetSystemId(void)] exited with [0x00000001]
14:10:03:894 (AvSystemConfig_MC,1159,SystemConfig,10) [ConfigureSQL] component initialization successful.
14:10:03:895 (AvSystemConfig_MC,1091,SystemConfig,0) Trace Level [HIGH]: COM Method [CAvConfigureSQL::Initialize(IAvLogMgr*)] exited with HRESULT [0x00000000] [S_OK]
14:10:03:894 (AvSystemConfig_MC,1090,SystemConfig,0) Trace Level [HIGH]: COM Method [CAvConfigureSQL::ConfigureSchema(void)] entered
14:10:03:895 (AvSystemConfig_MC,1092,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::SetLocalizedAdminsGroup(void)] entered
14:10:03:894 (AvSystemConfig_MC,1092,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::GetWellKnownSidUserName(GROUP_SID | CAvString& | CAvString&)] entered
14:10:03:895 (AvSystemConfig_MC,1250,SystemConfig,10) Found the well known SID for user 'Administrators' in domain 'BUILTIN'
14:10:03:894 (AvSystemConfig_MC,1093,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::GetWellKnownSidUserName(GROUP_SID | CAvString& | CAvString&)] exited with [0x00000001]
14:10:03:895 (AvSystemConfig_MC,1092,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::GrantDbAccess(CAvString& | CAvString&)] entered
14:10:03:894 (AvSystemConfig_MC,1092,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::InitializeRdbSvr(void)] entered
14:10:06:478 (AvSystemConfig_MC,1161,SystemConfig,10) Method IAvRdbConnection::Initialize(HP-PAV) returned [0x80048807]
14:10:06:479 (AvSystemConfig_MC,1093,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::InitializeRdbSvr(void)] exited with [0x00000000]
14:10:06:478 (AvSystemConfig_MC,1093,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::GrantDbAccess(CAvString& | CAvString&)] exited with [0x00000000]
14:10:06:479 (AvSystemConfig_MC,1093,SystemConfig,1) Trace Level [LOW]: Method [CAvConfigureSQL::SetLocalizedAdminsGroup(void)] exited with [0x00000000]
14:10:06:478 (AvSystemConfig_MC,1091,SystemConfig,0) Trace Level [HIGH]: COM Method [CAvConfigureSQL::ConfigureSchema(void)] exited with HRESULT [0x8004020B] [E_SYSCONFIG_PERMISSIONS_NOT_INIT]
14:10:06:479 (AvLogMgrSvr_MC,10004,-1,-1) LOGMGR STOP
2002-04-28 14:10:06 (AvLogMgrSvr_MC,10008,diag file closed,) LOGMGR CLOSEDIAGFILE

[#4]

now that the database is there, try running the part 2 setup again and see if it goes through. I don't have a test system handy to bang on here, unfortunately.


Jeff Lindborg
Unity Technical Lead/Answer Monkey
Cisco Systems
lindborg@cisco.com
http://www.AnswerMonkey.net (new page for Unity support tools and scripts)

[#5]

I still do not see the UnityDb database. Where did you see that it was created successfully? maybe I missed it in the log. However, I did go ahead and try the 2nd part of config and still got the same error.