cleverbob - Thursday, December 27, 2007 10:02 PM:
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
PeterSchroer - Friday, December 28, 2007 9:29 AM:
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.
PeterSchroer - Monday, January 14, 2008 9:09 AM:
Doesn't sound right. Installation of Innovator should take 30 minutes or less. Drop me an email with your configuration at [email protected] 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.
PeterSchroer - Monday, January 14, 2008 9:09 AM:
Doesn't sound right. Installation of Innovator should take 30 minutes or less. Drop me an email with your configuration at [email protected] 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.
cleverbob - Sunday, January 13, 2008 2:43 PM:
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!snnicky - Monday, January 14, 2008 2:42 AM:
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
