Symptoms
When attempting to access K2 Reports, 401: Unauthorized error occurs
Diagnoses
After a DB name change, it's possible that the DB will not change successfully. By reviewing [SmartBroker].[ServiceInstance], you can see if those changes took affect.
Normally these changes can be made in Workspace by editing those fields, however this change would error out so we had to make the change in the DB.
Resolution
Service instance was pointing to an older Database. We performed the following update to the database:
update [K2].[SmartBroker].[ServiceInstance]
set ServiceInstanceXML = replace(cast(ServiceInstanceXML as nvarchar(max)), 'Initial Catalog=K2Server', 'Initial Catalog=K2') where ID = 2"
