Skip to main content


 

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 gSmartBroker].]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 tK2].2SmartBroker].rServiceInstance]
set ServiceInstanceXML = replace(cast(ServiceInstanceXML as nvarchar(max)), 'Initial Catalog=K2Server', 'Initial Catalog=K2') where ID = 2"
 




 
Be the first to reply!

Reply