EdBundy - Tuesday, July 3, 2012 2:44 AM:
Good day all
I'm quite new to the Aras community and would greatly appreciate any help in this regard.
I am trying to install Innovator and have the prerequisites done - IIS 7.5, SQL Express to which I can login using the "sa" account, and the license key. The configuration completes up to the "Configure Database" step where I select "Create a new databse", and enter the Login ID (sa) and password using server authentication. When I click on "connect", I get an error [Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied.
I can open SQL Management studio and connect to the database using "sa" and the password, so I'm not sure where the error comes from. (It gave me this error in SQL Expr 2008R2 and SQL Expr 2012)
Any help in this regard would be greatly appreciated.
Ed
Brian - Wednesday, July 4, 2012 7:18 AM:
Hi Ed,
When you get to the SQL configuration page of the installation you have to select or type the SQL server instance you are going to use. It defaults to (local) but does not specify an instance.
That would be my first guess.
Cheers,
Brian.
EdBundy - Thursday, July 5, 2012 5:50 AM:
Hi Brian
Thanks for the reply and sorry for the tardiness in my response.
It does default to (local) but there are no other instances to select. However, it seems that I had success in setting up the database by completely uninstalling the newer MS SQL's and installing MS SQL 2005. Created and configured database without a problem (it seemed).
Now, however, when I try to upload a file to the vault I get an error stating:
Failed to upload the files. Is the specified Vault Server URL ".... /vault/vaultserver.aspx" correct?
I installed Aras using the defaults so I'm at a loss as to why. If I navigate to /localhost/innovator/vault/ or /vault/vaultserver I get a "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable." error. In IIS the vault does exist.
Not looking promising at the moment :-(
Ed
Brian - Thursday, July 5, 2012 7:16 PM:
Hi Ed,
Sounds a bit funny.
Have a look in the install directory for Innovator and see what the "vaultServerConfig.xml" file says about the vault physical location. Makes sure this matches what you expect.
Navigating to the vault/vaultserver.aspx always gives a 404 error even on vaults that are properly configured. YOu are not supposed to access it directly in this manner.
I'd be tempted to uninstall Innovator and try again.
You may want to run the installer as Administrator. It could also be a permissions issue on the Vault directory although that seems a bit of a long shot
If you reinstall Innovator when you get to the config screen you type the SQL instance name after (local) to specify the SQL Server instance you are looking for. It doesn't seem to find installed instances on its own.
Sorry I can't be more direct help.
Cheers,
Brian.
EdBundy - Friday, July 6, 2012 2:14 AM:
Hi Brian
Thanks for the info; I suspected the vault won't be directly accessible but hoped it may give me an idea if whether the vault was properly configured or not. I did check the xml files and all seemed fine, I even changed some values (kept the original files though) but I didn't even get a different error, so searched further.
In the end, I found a forum post wherein guys were getting the same error for filesize restrictions - the fix proposed there was to change the max file size parameter and setting the .NET version, and lo and behold, Innovator was running on v4; when I changed it to run on v2, it worked.
I will, however, heed your advice regarding the reinstall, since there's been so much config changes behind the scenes that it may be easier to start fresh.
Again, thanks for the advice, Brian!
~Ed
