Error Message "Authentication failed for xxx"

Hello,

 Here is my InnovatorServerConfig.-----------------------------------------

<Innovator>
  <UI-Tailoring login_logo="../images/logos/innovator_splash.jpg" branding_img="../images/logos/banner_02.jpg" product_name="Aras Innovator" banner_url="../scripts/banner.aspx" banner_height="50" />
  <operating_parameter key="debug_log_flag" value="false" />
  <operating_parameter key="debug_log_limit" value="10000" />
  <operating_parameter key="debug_log_pretty" value="true" />
  <disabled_operating_parameter key="performance_logging" value="cpu" />
  <operating_parameter key="xslt_processor_debug" value="false" />
  <disabled_operating_parameter key="email_debug_option" value="file" />
  <License lic_type="Unlimited" lic_key="e57c6b956a6521b28495f2886ca0977a" />
  <Mail SMTPServer="queue" />
  <operating_parameter key="temp_folder" value="C:\Program Files\Aras\Innovator\Innovator\Server\temp" />
  <operating_parameter key="ServerMethodTempDir" value="C:\Program Files\Aras\Innovator\Innovator\Server\dll" />
  <operating_parameter key="debug_log_prefix" value="C:\Program Files\Aras\Innovator\Innovator\Server\Logs\" />
  <DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)" uid="innovator" pwd="Deleted" dbType="SQL Server" />
  <DB-Connection id="Innovator" database="Innovator" server="(local)" uid="innovator" pwd="Deleted" dbType="SQL Server" />
  <DB-Connection id="Test1" database="Test1" server="(local)" uid="innovator" pwd="Deleted" dbType="SQL Server" />
  <DB-Connection id="Test2" database="Test2" server="(local)" uid="innovator" pwd="Deleted" dbType="SQL Server" />
</Innovator>

 ---------------------------------------

I tried to set AD integrated authentication, but it didn't work.

so, I reset the configuration to default-setting. 

but now, I can't login database any user with Error Message "Authentication failed for xxx"

Maybe, it has happened after "Reset Authentication Passwords" from main-menu.

Also "admin" user can't login the database with default password(innovator). I have never changed "admin" password.

Has admin password changed by "Reset Authentication Passwords" ??

 

thanks.

Try to open Sql managment studio using uid="innovator" pwd="Deleted".

If you will not be able to do it. Use "sa" user and create "innovator" user with pwd="Deleted"

ross

Thank you for your reply.

I tried to log in SQL Management Studio using "innovator" user, Log in succeeded.

However, log in from ArasInnovator cannot be yet.

I have some databases in my innovator server.

The problem has occured in a specific database. Other databases operate correctry.

Maybe, it seems that the user configuration of the database has broken...

I will try to recreate the database.

Thanks

I think that this is no any reason to recreate databases. Look at your databases properties and confirm that user "Innovator" with password="DELETE" exists.

When you tried to set up Windows Authentication, you reset all passwords for users not defined in the tag

 denied_domain_users="^admin$|^root$|^vadmin$"

 I would try to log in as admin using the URL from the doc.

http://localhost/Innovatorserver/?username=admin

The password should still be the same if you used the steps outlined in the doc.  ("innovator" is the default password)

If you still cannot log in, then I have to assume there are no valid login credentials left.  You have two options:

1) Reset the password via SQL.

2) Restore the database from backup.  How To Restore a Database from BAK file.pdf

 

Hi Chris,

Thank you for your reply.

I think that I have made a mistake in the steps of Windows Authentication setup. I will confirm the mistake later.

Then I tried to restore the database. but I still can't log in.

I have a question in your option (1). May I change the password-row of the USER table by SQL UPDATE?

How do I reset the password via SQL ?

Thanks