Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCX 4.5 Historical Reporting

When trying to log into the historical reporting client I see the following message:

"Failed to login to database. Ask your administrator to check the database user id a password that is dynamically obtained from the application server."

I think this is something to do with the db_cra database login but I don't know what to do about it.

Any ideas?

Thanks

6 REPLIES
Silver

Re: UCCX 4.5 Historical Reporting

Resolution:

Reset 'db_cra' SQL user password back to 'db_cra'.

New Member

Re: UCCX 4.5 Historical Reporting

Hi,

how do you Reset 'db_cra' SQL user password back to 'db_cra'?

New Member

Re: UCCX 4.5 Historical Reporting

Dear smahbub,

In my case this usar (db_cra) has dissapeared. I will try to create it again, please confirm that both username and password should be "db_cra"

Thanks a lot

Amaia

New Member

Re: UCCX 4.5 Historical Reporting

Hi,

Did you change the SQL Server authentication mode ?

Because the problem usually happens when you change the SQL Server authentication to "Mixed Mode".

New Member

Re: UCCX 4.5 Historical Reporting

Hi,

I didn't change it. To solve it, we restarted the server and everything was right. It's something uncomprehensible.

Bset regards,

Amaia Lesta

Re: UCCX 4.5 Historical Reporting

Go into Sql Sever > enterprise manager

Select the machine your database is running on which. Right click and slect properties option.

properties > Security > Authentication > Slect Windows only. Restart Sql server engine then try.

188
Views
0
Helpful
6
Replies
CreatePlease login to create content