ARS svr
MS 2003 std, SP1
Db svr
MS 2003 Ent, SP1
MS SQL 2005 std
I have tried using both the ARS 7.0.1 & patch 1 installers with the same
results. This new installation fails when it tries to create the ARAdmin
account on the database. It copies all the files onto the ARSystem server
and creates the database (*.mdf) and log (*.ldf) files on the remote
database server.
Viewing the database through the SQL 2005 client, I end up with an
installation that has a ARSystem database instance with dbo, but no ARS
forms/tables and no ARS admin account of "Demo". The installation ends
with a statement that I can import the forms manually, but I don't know
how since I have to have an admin account to use the AR import tool.
I believe there might be a some new SQL configuration setting that is
causing the creation of the ARAdmin account to fail, but I am new to
2005. The sa account to the database has full priveledges on the remote
database. I would appreciate any help. I started this process last
Friday and the BMC crew has only anwsered with questions to date.
Below are some snippets from the ar_install.log
-------------------------------------------------------
08:25:57 ----> _RunSQLQuery: Entering function <----
08:25:57 Running database script on MSSQL: queryfile.sql
08:25:57 User: ARAdmin
08:25:58 ****->[WARNING]: LoadDatabaseMS(ARAdmin, ****, MCPHA4001\FCCS,
queryfile.sql, arscript.err)
08:25:58 Database script returned: 2
08:25:58 ----< _RunSQLQuery: Exiting function >----
-------------------------------------------------------
-------------------------------------------------------
08:40:04 ----> _RunSQLQuery: Entering function <----
08:40:04 Running database script on MSSQL: ARSystem.syb
08:40:04 User: ARAdmin
08:40:05 ****->[WARNING]: LoadDatabaseMS(ARAdmin, ****, MCPHA4001\FCCS,
ARSystem.syb, arscript.err)
08:40:05 Database script returned: 2
08:40:05 ----< _RunSQLQuery: Exiting function >----
-------------------------------------------------------
-------------------------------------------------------
08:41:49 ----> _RunSQLQuery: Entering function <----
08:41:49 Running database script on MSSQL: queryfile.sql
08:41:49 User: ARAdmin
08:41:49 ****->[WARNING]: LoadDatabaseMS(ARAdmin, ****, MCPHA4001\FCCS,
queryfile.sql, arscript.err)
08:41:49 Database script returned: 2
08:41:49 ----< _RunSQLQuery: Exiting function >----
-------------------------------------------------------
08:41:59 ****->[ERROR]: Couldn't create the "Demo" user.
08:41:59 ****->[ERROR]: Failed to create a valid Admin user. This
installation cannot complete importing of forms or data. A valid Admin
user will need to be created and forms and data manually imported.
This error occurred after the installation of the AR System was completed.
To correct this error, import the sample applications from the samples
subdirectory.
08:43:41 Done importing forms.
08:43:41 ****->[ERROR]: Failed to complete AR Server installation.
Chuck Koch
[EMAIL PROTECTED]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
