Error adding Logger

[iMarkJavier]

I am getting an error when adding a logger to my lab set up. error seems to be connected with the logger db but i'm not sure.

I've attached the logs i was able to get.

[david.macias]

Is SQL installed on the server? Is it the right version? Did you run icmdba?

david

[iMarkJavier]

Yes. I followed the instructions in the Installation and Upgrade Guide.

It is already listed as a logger but it doesn't start.

[iMarkJavier]

Hi David,

I tried installing 12.5 on server 2016 and sql 2017. I followed the install guide and still getting the same error. I must have missed something but the error message doesn't make it clear.

8: roggerb.uccelab.com: May 15 2021 12:30:42.132 -0700: %ICM-ERROR-DBUtils.runSQLSelectInt: Error encountered while running SQL script script=SELECT count(*) FROM sysusers where name = 'uccelab.com_imuccSBMaintB' errorCode=0.
9: roggerb.uccelab.com: May 15 2021 12:30:42.133 -0700: %ICM-EMERGENCY-: [com.cisco.icm.websetup.backend.exception.WebsetupDBException]Error encountered while running SQL script script=SELECT count(*) FROM sysusers where name = 'uccelab.com_imuccSBMaintB' errorCode=0.
com.cisco.icm.websetup.backend.exception.WebsetupDBException: Error encountered while running SQL script script=SELECT count(*) FROM sysusers where name = 'uccelab.com_imuccSBMaintB' errorCode=0.

[david.macias]

Hmm. Are you using SQL standard or enterprise 64 bit version and Windows standard or data center?

david

[iMarkJavier]

I'm using server 2016 standard and sql 2017

this is deployed in VMware workstation 16.1.2 build-17966106

Host Name: CASJCROGGER01A
OS Name: Microsoft Windows Server 2016 Standard
OS Version: 10.0.14393 N/A Build 14393
OS Manufacturer: Microsoft Corporation
OS Configuration: Member Server
OS Build Type: Multiprocessor Free
Registered Owner: Windows User
Registered Organization:
Product ID: 00377-60000-00000-AA934
Original Install Date: 5/26/2021, 4:33:28 AM
System Boot Time: 5/25/2021, 3:11:10 PM
System Manufacturer: VMware, Inc.
System Model: VMware Virtual Platform
System Type: x64-based PC
Processor(s): 4 Processor(s) Installed.
[01]: Intel64 Family 6 Model 158 Stepping 10 GenuineIntel ~2592 Mhz
[02]: Intel64 Family 6 Model 158 Stepping 10 GenuineIntel ~2592 Mhz
[03]: Intel64 Family 6 Model 158 Stepping 10 GenuineIntel ~2592 Mhz
[04]: Intel64 Family 6 Model 158 Stepping 10 GenuineIntel ~2592 Mhz
BIOS Version: Phoenix Technologies LTD 6.00, 7/22/2020
Windows Directory: C:\Windows
System Directory: C:\Windows\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (UTC-08:00) Pacific Time (US & Canada)
Total Physical Memory: 6,143 MB
Available Physical Memory: 3,606 MB
Virtual Memory: Max Size: 7,807 MB
Virtual Memory: Available: 5,197 MB
Virtual Memory: In Use: 2,610 MB
Page File Location(s): C:\pagefile.sys
Domain: ingrammicro.lab
Logon Server: \\WINSERVER
Hotfix(s): 4 Hotfix(s) Installed.
[01]: KB3192137
[02]: KB4013418
[03]: KB4054590
[04]: KB4016635
Network Card(s): 2 NIC(s) Installed.
[01]: vmxnet3 Ethernet Adapter
Connection Name: Ethernet0
DHCP Enabled: No
IP address(es)
[01]: 10.1.1.200
[02]: vmxnet3 Ethernet Adapter
Connection Name: Ethernet1
DHCP Enabled: No
IP address(es)
[01]: 192.168.100.1
Hyper-V Requirements: A hypervisor has been detected. Features required for Hyper-V will not be displayed.

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)

[Muhammed Ashiq]

Could you check BUILTIN\Administrators user is created in the SQL users ?

[senthilnatarajan]

Looks like permission issue on the MS side. You way want to

1. check if the install account you are using is a local administrator

2. Check if the install account is also part of the SQL "dbcreator" or "sysadmin"(if its lab)

3. Check if the install account has access to the logger DB. which it should if #2 above is satisfied.

HTH

Senthil

[iMarkJavier]

Hi Senthilnatarajan,

I've created a user 'ucceadmin' with local admin access to the rogger. I also delegated full access to Cisco_ICM.

This is the user account I've used for the installation of ICM and SQL. 

After installing SQL, the ucceadmin account is already configured with sysadmin role when I checked SQL Management Studio.

Is there anything else I can check?

Thanks for helping me with this.

[senthilnatarajan]

have you checked any firewall port blocking on that server?

-Senthil