Hi Arpit, check whether ARAdmin user exists if not create one and then change the dbowner.
sp_changedbowner ARAdmin Regards/Vaibhav On Thu, Mar 21, 2013 at 8:32 AM, Arpit Nigam <[email protected]> wrote: > ** > Exactly Vaibhav.. > > Seems you have catch the issue. > > Can u let me know as how can I give correct permission to DB ? > > Regards > > Arpit > > On Thu, Mar 21, 2013 at 8:57 PM, vaibhav wadekar < > [email protected]> wrote: > >> ** >> Hello Arpit, >> >> It looks like the error you receive is something like below >> +++ >> Windows could not start the BMC Remedy Action Request System >> *Servername* on local computer. For more information, review the system >> event log. If this is a non-Microsoft service, contact the service vendor, >> and refer to service-specific error code 1064) >> +++ >> >> If that is the case, it appears you copied the db but did not apply the >> correct permissions to the DB once you had restored. A backup/restoration >> activity removes the permissions assigned to "ARAdmin" and these need to be >> restored before the ARServer process will be able to connect (as it uses >> the "ARAdmin" account to connect). >> >> Regards/Vaibhav >> >> >> >> >> >> >> On Thu, Mar 21, 2013 at 7:59 AM, Arpit Nigam <[email protected]> wrote: >> >>> ** >>> Hi Doug >>> >>> Thanks for your reply.Below are the details >>> >>> ARS 7.6.04 >>> >>> Windows :Windows Servers Service pack 2 >>> >>> Database : SQL Server 2008 r2 ( RTM ) >>> >>> Regards >>> >>> Arpit >>> >>> On Thu, Mar 21, 2013 at 8:17 PM, Tanner, Doug < >>> [email protected]> wrote: >>> >>>> ** >>>> >>>> How about some real details? Don’t be so lazy.**** >>>> >>>> ARS Version, Windows Version, Database, ETC.**** >>>> >>>> Doug **** >>>> >>>> ** ** >>>> >>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>> [email protected]] *On Behalf Of *Arpit Nigam >>>> *Sent:* Thursday, March 21, 2013 9:47 AM >>>> *To:* [email protected] >>>> *Subject:* Getting error 1064 while starting the server in windows >>>> environment**** >>>> >>>> ** ** >>>> >>>> ** **** >>>> >>>> Hi All**** >>>> >>>> **** >>>> >>>> I am getting the error as error 1064 while starting the ar server in >>>> windows environment.**** >>>> >>>> **** >>>> >>>> Pls help.**** >>>> >>>> **** >>>> >>>> Thanks**** >>>> >>>> **** >>>> >>>> Arpit**** >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ **** >>>> >>>> >>>> >>>> This email is subject to certain disclaimers, which may be reviewed via >>>> the following link. http://compass-usa.com/Pages/Disclaimer.aspx >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
