11-06-2007 03:36 AM - edited 03-14-2019 01:30 AM
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
11-13-2007 06:51 AM
Resolution:
Reset 'db_cra' SQL user password back to 'db_cra'.
11-14-2007 04:54 AM
Hi,
how do you Reset 'db_cra' SQL user password back to 'db_cra'?
12-05-2008 06:37 AM
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
09-01-2009 07:00 PM
Hi,
Did you change the SQL Server authentication mode ?
Because the problem usually happens when you change the SQL Server authentication to "Mixed Mode".
09-07-2009 12:19 AM
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
09-07-2009 05:15 PM
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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: