UCCX 4.5 Historical Reporting

dcornwell · ‎11-06-2007

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

smahbub · ‎11-13-2007

Resolution:

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

CSCO11117246 · ‎11-14-2007

Hi,

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

amaia.lesta · ‎12-05-2008

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

regi_firnanda · ‎09-01-2009

Hi,

Did you change the SQL Server authentication mode ?

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

amaia.lesta · ‎09-07-2009

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

Sheraz Saeed Lodhi · ‎09-07-2009

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.