Hi all, @SeanReynolds @Beat Bucher @JohnBuchman Thank you for your help. The rebuild seems to be working now. I did not use the correct server name so the rebuild worked with errors as on the screen shot. My fault as I should know the server name. I called our GP partner and she spotted...
Thank you .. I will look at this tomorrow. I really appreciate the help! -- Shelagh Esteb NA Stafford TX --
Shelagh, Agree with Sean, MR 2012 specifically has to be setup with a domain Account, as directed in the installation guide from Microsoft. That same domain account has to be granted access on the SQL security side and given permission as 'db creator' in order to create a MR database and the DM...
In our environment, we have a separate SQL and MR console server for Management Reporter. We also use a domain account (noted in the screen shot) to run the Application and Process services. I would try updating the Dynamics GP credentials with your 'sa' creds (assuming the password hasn't...
This is what I see for the service account. If there is a better way to do this I am all ears. Thanks again. S -- Shelagh Esteb NA Stafford TX --
Are you all using a service account, not NT Authority, to run the Application and Process services? We have a specific named account which runs both services. -- Sean Reynolds Accounting IT Manager & MS Dynamics GP System Administrator Atlantic Aviation Plano TX --
Yes I am but it looks like it may need to be the NT Authority etc user? -- Shelagh Esteb NA Stafford TX --
Hi Shelagh - It looks like whatever credentials were configured to connect to the GP Database server are incorrect. Are you using the 'sa' credentials when recreating the connection? -- Sean Reynolds Accounting IT Manager & MS Dynamics GP System Administrator Atlantic Aviation Plano TX --
Update... the database has now been deleted and IT cleaned up the drive a bit. I was able to complete the rebuild but it didn't work. This apparently is way above my head. Can you look at the error below and give me any suggestions? THANK YOU! -- Shelagh Esteb NA Stafford TX --
Hi John, Thank you. I found the .mdf and .ldf files lurking about in another directory. I am going to attempt the rebuild shortly but right now IT is solving our space issue. I knew there had to be something else somewhere because the configure advanced once I changed the db name. There are...