Boro - Friday, January 9, 2009 3:06 AM:
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 FilesArasInnovatorInnovatorServer emp" />
<operating_parameter key="ServerMethodTempDir" value="C:Program FilesArasInnovatorInnovatorServerdll" />
<operating_parameter key="debug_log_prefix" value="C:Program FilesArasInnovatorInnovatorServerLogs" />
<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.
ross - Thursday, March 19, 2009 5:48 AM:
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"
Boro - Thursday, March 19, 2009 10:24 PM:
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
ross - Friday, March 20, 2009 3:43 PM:
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.Anonymous - Wednesday, March 25, 2009 4:16 PM:
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.
localhost/.../
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
Boro - Tuesday, March 31, 2009 1:41 AM:
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
