Error- Exception during initialization

I am getting a error during login that says "InnovatorDatabaseException: Login failed for user '***************'. The user is not associated with a trusted SQL Server connection". This error is thrown even with the default login of admin/innovator. Is this just a problem with the way the db is setup? The install was fairly straight forward and I did not have any problems. I just thought maybe someone else has seen this error. Thanks, Bob

 

Bob - this is a database connection error.   2 steps to troubleshoot.   Look in the InnovatorServerConfig.xml file at the connection parameters for the database,   and then  use SQL Enterprise Manager to look at the permissions associated with the user (probably Innovator the default connection user).    Sounds like Innovator does not have connection privileges.   

The Innovator ServerConfig.xml file looks perfect. No problems there. Using SQL Manager it looks like all the different user name and pw combos I have tried have permissions. I have also checked the settings for IIS and everything looks fine there also. If anyone else has any ideas that would be great. I have followed the instructions for a default install perfectly but still no connection to Aras. This is at a point where to much time is being spent troubleshooting a default install. Smart team might be easier and less trouble!

Hello Bob.

Here is the first reference to the error found in Google:
"The user is not associated with a trusted SQL Server connection"

the search was
http://www.google.com/search?q=%22The+user+is+not+associated+with+a+trusted+SQL+Server+connection%22&ie=utf-8&oe=utf-8

Doesn't sound right.    Installation of Innovator should take 30 minutes or less.    Drop me an email with your configuration  at pschroer@aras.com    and I'll help.        Any chance your SqlServer installation is configured for Windows Authentication only?    Needs to be set to mixed mode,  so that a SQL connection can be made.     One of the trouble-shooting tricks is to drop to a DOS window on the Server and try

osql -Uinnovator -Pinnovator         where I am assuming that you specificed username is "innovator" and the password is "innovator" during the Aras Innovator installer.      This connects to the database server using a SQL connection instead of Windows Authentication.           If this command succeeds, you will see the Sql Server prompt.    Try: 

• Use InnovatorSolutions  
• Select * from [User]
• Go

 See if that query returns data from the user tables in Innovator.

Doesn't sound right.    Installation of Innovator should take 30 minutes or less.    Drop me an email with your configuration  at pschroer@aras.com    and I'll help.        Any chance your SqlServer installation is configured for Windows Authentication only?    Needs to be set to mixed mode,  so that a SQL connection can be made.     One of the trouble-shooting tricks is to drop to a DOS window on the Server and try

osql -Uinnovator -Pinnovator         where I am assuming that you specificed username is "innovator" and the password is "innovator" during the Aras Innovator installer.      This connects to the database server using a SQL connection instead of Windows Authentication.           If this command succeeds, you will see the Sql Server prompt.    Try: 

• Use InnovatorSolutions  
• Select * from [User]
• Go

 See if that query returns data from the user tables in Innovator.