Is this a new install or an upgrade? I would expect to see these messages on a New since the user, database, and login do not already exist. I would then expect to see messages about creating the user, database, and login (as well as creating the objects, ...)
Is there anything in the arerror.log? What happens if you try to start the services? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of tina flores Sent: Friday, April 03, 2009 3:31 PM To: [email protected] Subject: ARS 7.1 SQL 2005 Server install error I'm installing ARS 7.1 (Server) on SQL 2005 on Windows Environment. Installation is completed with error: "Unable to start the AR System service. The AR System Server could not be started. You can start it manually using the Services in the Control Panel. " Checking the DB logs, it says: 10:39:38 ============== Query Results ============== Command successful sp_dropuser "ARAdmin" ERROR: SQL operation failed User 'ARAdmin' does not exist in the current database. (SQL Server 15008) drop database "ARSystem" ERROR: SQL operation failed Cannot drop the database 'ARSystem', because it does not exist or you do not have permission. (SQL Server 3701) sp_droplogin "ARAdmin" ERROR: SQL operation failed 'ARAdmin' is not a valid login or you do not have permission. (SQL Server 15007) I used the SA account and a valid SA password when I installed the ARS Server. Also tested connection in SQL with the SA password and tested successful. I am also logged in as an "Administrator" to the server where AR System is installed. I also accepted default values for the ARSystem DB Name = ARSystem; ARSystem DB User = ARAdmin and ARSystem User Password = AR#Admin# I've done installation with the client's DEV environment on SQL 2000 and didn't see this error. Client upgraded to SQL 2005 for the TEST server installation (where I am currently installing). Have you seen this error before? Are there any additional things to conside when doing the install in SQL 2005 not documented in the Installation document? Thanks for your help. Tina -- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
