bswfcw - Wednesday, January 24, 2007 12:53 PM:
No matter what I have tried I cannot login to the Innovator server. I am running SQL Express and have tried every trick I can but I still get an authentication error immediatly. I checked the configuration file and everything looked as it shoul according to the install doc. I give up!
Chris
Bill - Wednesday, January 24, 2007 1:25 PM:
No problem, I'm sure we can get this sorted out.
So, you installed Innovator to your server, and you were able to complete the install without errors.
After this, you set up a .NET security policy on the client machine using the Manual .NET Security Config Tool.
Next you followed the steps outlined in the Aras Innovator - Internet Explorer Client Machine Configuration
(See http://www.aras.com/support/documentation/documentation.aspx for the download of this doc.)
Finally you opened the link to the Innovator login screen.
Example: machine/InnovatorServer
You then enter the default login credentials on a new install:
Login: admin
Password: innovator
You then select the installed database from the dropdown and select login.
I assume this is when you recieve your error message. Could you tell me what the error message says, or if the error message happens at a different point (and what it says then)?
Thanks,
Bill
chintsys - Thursday, January 25, 2007 12:14 AM:
I have a similar problem in not being able to log in, except in my case all the fields in the login box are locked.
The database name appears ok in the drop-down (as configured during installation) and is locked as well. No errors during installation but I'm not sure if the Vault is configured correctly.
Any thoughts?
Chris
bswfcw - Thursday, January 25, 2007 9:17 AM:
You know Bill, I looked through all the documentation and I could not find anything on the admin login! Would you be kind enough to direct me to the document that contained this info?
Thanks, admin--->innovator worked.
Chris
Bill - Thursday, January 25, 2007 11:52 AM:
Chris (chintsys),
So the fields are loaded, like in my previous screenshot, but you cannot type in them?
I'm not sure what this is, yet, but I can start with a couple of recomendations.
1) Review your IE settings with the Aras Innovator - Internet Explorer Client Machine Configuration document.
(http://www.aras.com/support/Documentation/documentation.aspx)
2) Clean your internet cache (In case the file was corrupted during download.)
(http://aras.comhttp://www.aras.com/Community/forums/70/ShowThread.aspx#70)
Could you provide me with a few details about your client machine?
1) Operating system (Windows 2000 or XP)?
2) Internet Explorer Version (6 or 7)?
3) .NET version (2.0 or 1.1)?
Thanks,
Bill
Bill - Thursday, January 25, 2007 10:45 AM:
Chris W,
Glad it worked!
For future reference, connecting to Innovator for the first time is covered in section 6 "Connecting to the Aras Innovator Server" of the Aras Innovator - Installation Guide. However, I can see how you could overlook this when having to setup the client first. I have passed this feedback onto our documentaion people to help make this easier for others in the future. Thanks!
-Bill
chintsys - Friday, January 26, 2007 5:50 AM:
Hi Bill,
I'm running XP Pro / IE7 / .NET 1.1 on my local machine. The Innovator software is installed on a remote machine running WIndows Server 2003 with SQL Server 2000, IIS6 and.NET 1.1. I access this remote machine over a VPN. There is the same locked "login screen" using IE7 on the server as well as on my local machine. I have followed the recommendations in the Client Machine Configuration manual. The Internet cache has been cleared with no apparent change on my local machine.
I did have .ASP extensions disabled in IIS "Web Service Extensions" when I first started but have already corrected this (and restarted WWW Publishing Service). The database tables appear to be ok in SQL Server and I can see three login accounts in the User table (with all three enabled for login).
I'm wondering if this problem has something to do with the Directory Security settings in IIS. Right-clicking "Properties" under the "InnovatorServer" entry in "Default Web Site" and selecting the Edit button under the "Directory Security Tab" in my installation shows a user called IUSR_NEWSERVER enabled for Anonymous Access. The only other box checked on this page is "Integrated Windows Authentication". The dialog box looks a little different to the one shown in the Installation Guide manual which is presumably IIS5. Currently, IUSR_NEWSERVER is only a member of Domain Users and Guests on the Windows 2003 Server. The Installation Guide suggests this user should be an Administrator. Is this correct? I am a little hesitant to grant Administrator rights to an anonymous login.
Not sure if this is relevant, but the MDAC version on the our server is different to the one shown in the documentation:
HKEY_LOCAL_MACHINESoftwareMicrosoftDataAccessVersion =
2.82.1830.0Any thoughts you have on this would be appreciated.
Thanks,
Chris
natek64 - Friday, February 16, 2007 2:03 PM:
Hi Bill,
I'm having the same issue as Chris. I get the login screen with both Login and password fields "disabled" and the database pull-down grayed out. If you have a minute to review this, my client machine setup is:
OS = Win XP Pro
Browser = IE7
.NET version = 2.0
I first tried to set up a trusted connection for myself, but kept getting "Access Denied" messages when trying to create a Database. So I enabled windows & SQL authentication and changed the login to sa +password and that allowed the installation to complete. So, I think I'm almost there, but just need a little help on this.
Thanks,
~ n8
natek64 - Friday, February 16, 2007 1:08 PM:
Hey Chris,
Did you ever get this figured out? I've got the same problem. I'm thinking it might be something to do with the connection string, but I'm a complete novice when it comes to SQL Server/ASP.net. Any suggestions would be great.
Thanks,
n8
Bill - Friday, February 16, 2007 1:44 PM:
Hi nate64, and welcome to the forum.
Chris and I emailed about this issue, but we never put the result in the post. My apologies. Chris was able to work around this issue by using his machine IP address to connect, rather than his machine name.
Example:
192.168.168.16/InnovatorServer
Let me know if this helps.
-Bill
natek64 - Friday, February 16, 2007 3:29 PM:
Bill,
Thanks for the response. Is this in IE? I get a .NET error when I use the IP address in IE. Do I need to edit the web.config file?
Thanks,
~ n8
Bill - Friday, February 16, 2007 3:47 PM:
The .NET security policies are URL specific.
You need to set a new .NET security policy for the IP address.
1) Close all IE windows.
2) Run the Manual .Net Security Tool (sdns.exe) using the new URL (192.168.168.16/InnovatorServer)
3) Open a new IE Window and login.
-Bill
Please also see: http://aras.comhttp://www.aras.com/Community/forums/thread/66.aspx
natek64 - Friday, February 16, 2007 4:44 PM:
Hi Bill,
OK, Now the login fields are no longer greyed out. But no login that I've tried works:
admin+innovator
innovator+innovator
sa+password
myusername+password
I get an error in my connection string I think.
I'm pretty sure I've messed up the web.config file or the InnovatorServerConfig.xml file...
Suggestions where to start looking?
Thanks,
~ n8
natek64 - Friday, February 16, 2007 6:13 PM:
Hi Bill,
OK, got past that, now I'm getting the following error:
"Exception during initialization (InnovatorDatabaseException: Login failed for use "admin'.)"
Installation error?
thanks,
~ n8
Bill - Friday, February 16, 2007 5:04 PM:
What did you change in these files?
Roughly, if not exactly.
-Bill
Bill - Friday, February 16, 2007 6:42 PM:
This error message means that your connection string is wrong in the InnovatorServerConfig.xml. The database exists, but the sql login is wrong.
You should have something like this:
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="localhost" uid="admin" pwd="innovator" dbType="SQL Server" />
but you need to change the uid to the valid login:
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="localhost" uid="innovator" pwd="innovator" dbType="SQL Server" />
I can't tell you what you put in as the innovator login during install, but from what you have told me so far I feel this is a safe guess.
Please note, this is the login that the InnovatorServer uses to connect to it's database, this is not the login that you use in the Innovator login screen. That remains admin/innovator as previously explained in this thread.
-Bill
Bill - Friday, February 16, 2007 6:49 PM:
This error means the connection string is wrong in the InnovatorServerConfig.xml. The database exists, but the SQL login is wrong.
Your connection string looks something like this:
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="MACHINESQLEXPRESS" uid="admin" pwd="innovator" dbType="SQL Server" />
but it should be something like this:
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="MACHINESQLEXPRESS" uid="innovator" pwd="innovator" dbType="SQL Server" />
I can't know what login you put in when installing your database, but my example should be a good guess from what you have told me so far.
Please note, this is the login that the Innovator Server uses to connect to the Innovator database. This is not the login that you use in the Innovator login screen. That remains admin/innovator.
-Bill
natek64 - Friday, February 16, 2007 6:16 PM:
I had the <connectionStrings/> in the wrong section. Moved them out of the system.web section and now the login doesn't give me an application error... just a login failed message. I'll have another go on Monday.
Have a great weekend!
Thanks for your help--
~ n8
natek64 - Thursday, February 22, 2007 12:55 PM:
Hello Bill,
Thanks for your help. I went ahead and re-installed Innovator (hadn't documented what I'd set up for DBA or DB user very well in the previous installation, so couldn't remember...) and now I'm able to log in as Admin.
Thanks again,
~ n8
