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.

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.

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.

Analytical Accounting Error - Assigned amount does not equal the distrbution amount

So you are posting a journal and get the error only when posting not when you print an edit list.

What is wrong? The distributions in the AA Work tables are mixed up.

Review these tables and manually update where you see the credit and debit or even the percentage allocation is incorrect.

Tables:

• AAG10000
• AAG10001
• AAG10002

Revalue vs Non Revalue Items

When an item is not set to be revalued the following happens.

Scenario A with Non Revalued Item:

• Item Purchased and Received into stock at $500.
• Some of the item is subsequently sold
• Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario A of Non Revalued Item:

• GL Updated with Inventory value of $500 from the Purchase Receipt
• GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
• Sub-ledger reflects the purchase receipt cost i.e. $500.
• Invoice difference is reflected in the purchase price variance account. This does not affect inventory sub-ledger as the cost remains the receipted cost and the inventory account matches this value in the sub-ledger as the difference is posted to the purchase price variance account instead of inventory.
• In the end the sub-ledger and GL balances but at the Receipt Cost.

When an item is set to be revalued the following happens.

Scenario B with Revalued Item

• Item Purchase and Received into stock at $500
• Some of the item is subsequently sold
• Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario B with Revalued Item

• GL Updated with Inventory value of $500 from the Purchase Receipt
• GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
• Sub-ledger reflects the purchase receipt cost i.e. $500.
• Purchase Invoice difference Debits the Inventory sub-ledger for the $50 as well as the GL (instead of the purchase price variance account used in Scenario A). 
• The system automatically creates a journal to update the cost of sale and inventory where sales transactions were posted from this receipt layer. 
• In the end the sub-ledger and the GL balances but at the Invoice Cost.

In the end it is all dependent on what you want to see in your General Ledger. 

And no - Revalue Inventory does not result in your sub ledger to general ledger being out of balanced.

Note the snip below is for the Revalued Item at 600 and not 500 as listed in the example scenario above.

Management Reporter Error - Change Tracking not enabled for tables GL00100, GL00102, etc

So you are deploying Management Reporter Data mart and get the change tracking error.

Now this would result in you having to set each table noted to have change tracking enabled.

Instead of doing this you can -
Go straight to GP,
Admin -> Setup-> Company-> Company, click the Options button, turn off Enable GL Reporting and Turn it back on. This will reset the change tracking and you can proceed.

Some tables your error would note:
GL00100
GL00102
GL00200
GL00201
GL10000
GL10001
GL10100
GL10101
GL12000
GL12001
GL20000
GL30000
GL32000
GL40000
GL40200
MC00200
MC40000
MC40600
SY00300
SY40100
SY40101

Unable to Mount iso image

Unable to mount iso image from a mapped drive, error received as below.

You need to move the file to the c drive and then try again. You are not allowed to mount an iso from a mapped drive..

Error: 'There was a problem mounting the file"