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

Is the installer throwing the error or is the Aras Innovator login screen throwing the error?

It's installer throwing the MS SQL error when I click 'configure database'. Thanks.

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.