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 --
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 --
Shelagh, Likely what happened is that whoever who deleted the DM database on SQL didn't have enough permissions on the disk level and the files did not get deleted, still using the full space and the name on disk.Which means any time you try to re-create the same DB name, it's going to complain...
I ran it ..the db is not in the list. I went back to configure and changed the name to DM2. Got a little further and now in the deployment log it says the disk is full. IT is working on that now. I will let you know what happens. Thanks so much. Shelagh -- Shelagh Esteb NA Stafford TX --
Try running this script on the SQL server and see if your ManagementReporterDM is listed in the result set: SELECT name, database id, create date FROM sys.databases; -- Sean Reynolds Accounting IT Manager & MS Dynamics GP System Administrator MIC Global Services Plano TX --