Thursday, 16 August 2018

Unable to access SQL after straight install from Azure

So you get your new VM and you see SQL installed. You try to connect to SQL and dont know the sa password. So you use the Windows domain account but cannot get in either.

Reason is because the domain may not have been setup yet so you need to connect with the local admin account.


  • Thus you sign in to the machine as the local admin account. 
  • Sign in to SQL. 
  • Change the Properties to Mixed Mode. 
  • Then enable the sa user in security. 
  • Then set the password.

Saturday, 4 August 2018

GP Web Client First Log in - Error Received "A get/change operation on table 'syUserDefaults' failed accessing SQL data dynamics gp"

So you set up web client
Try to log in for the first time and get:

"A get/change operation on table 'syUserDefaults' failed accessing SQL data dynamics gp"
More Info : "The server principal "(username)" is not able to access the database "DYNAMICS" under the current security context."


To Resolve:
- Run grant scripts against Dynamics and Company Databases
-Give your web client sql user account DYNGRP access to DYNAMICS database.

Wednesday, 1 August 2018

Management Reporter - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only

So you are trying to install Management Reporter
You have installed the services
You are trying to deploy the data mart or the legacy and no matter how many times you put in the sa password you get the error above.

How to fix?
-Use a higher version of Management Reporter. The version you are using is possibly not compatible with your SQL version.