Did you also accept the defaults of where to install the database on the database server?
I had this issue when trying to create the database in any location other than the default location but once I successfully completed the installation (of all components) I was able to move the database to the location I wanted without it causing any issues on the ARS side. Thanks, Sharon ext. 2219 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of tina flores Sent: Friday, April 03, 2009 4: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 -- View this message in context: http://www.nabble.com/ARS-7.1-SQL-2005-Server-install-error-tp22874242p22874242.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
