Charles, I had the exact same thing happen on a test box. Windows XP MS SQL Server 2k AR System 7.x
I had previously had 5.1.2 installed, and wanted a fresh install, so I went into SQL Server Enterprise Manager and deleted the AR System database. I then installed 7.x and had the exact same thing you had happen. I tried multiple times, and to no avail. Finally I installed 6.3 and it gave me a better error, it failed whenever trying to create the database because it already existed. This puzzled me because I had deleted it from SQL Server Enterprise Manager. Upon further investigation, what had happened was that it was gone from the SQL Server display, but the actual file itself was still there. I had to delete the mdf for arsystem. I then was able to install without incident. HTH -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Anonymous Sent: Wednesday, February 21, 2007 3:43 PM To: [email protected] Subject: ARS server 7.00.01 installation error 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
