Hi,
I'm new to Innovator and trying to build a new AP for my company. I follow installation guide but have problem in creating a new database: it tells me SQL server error: invalid column name 'NAME'. I do have admin access of SQL server and test connect successfully. And I am letting install program create innovator user for me. Please help. Thanks.
cchuang
Okay, so you are trying to install the database, but you don't have dba credentials to install with?
I don't think so. Actually it's a test db so there is no password for sa account. Here is my inputs in 'configure database' step:
----------------------------------------------------------------
configuration option: create new database
DBA login option: Server authentication using the Login ID and password
loging ID: sa
Password: null (click 'connect...' without error returned)
database login options
login id: innovator
password: innovator
database option
database template: Innovator Solutions
database name: InnovatorSolutions
click 'configure database', then error comes out.
------------------------------------------------------------
The MS SQL error message, Invalid column name: 'NAME', seems to be more likely SQL problem, not dba privilege. Is it possible I can investigate the running SQL statement?
Thanks.
Well, I would choose the configure only option of the databse install. This will set up the connection string, and not the database. There is no one SQL statemnt that will set up the database for you, so the safest thing to try at that point is to restore the database from backup.
A solutions database backup is included in the installed code tree Innovator\Server\DB\CoreAndSolutions90.bak
You will need to create the innovator login before you proceed with this. process, though.
1) Open the SQL Server Management Studio
2) Enter the dba credential you have provided
Login=sa
Password=null
3) Right-Click on the Security Folder and select New-->Login from the context menu
4) Set the log and password to match the one you used in the Aras Innovator installer. (You may need to disable passowrd policies if you wish to use a simple password like "innovator".)
5) Select OK to complete adding the user.
You can restore the database from backup using this file and the steps found here
http://www.aras.com/university/TechNotes/How%20To%20Restore%20a%20Database%20from%20BAK%20file.pdf
Thank you , Bill. The installation is done after I follow your instructions. The only thing I can't get is why I restore backup db before creat it successfully. The installation guide I followed could not give me a success.
And now there is another interesting problem same as this post (invalid object name when first time login), and seems there is no specific answer to it. ><
http://aras.com/Community/forums/thread/870.aspx
For your reference, here is my product list
MS Windows Server 2003 (Chinese version)
Innovator 9.0.1 Build:5430
MS SQL: 2000 (version 8.0)
Thank you.