Enable single user multiple sessions windows server.

Follow steps below to enable single user multiple sessions in Windows server 2012 & 2016
1.Open registry editor using regedit from Run.
2. Navigate to path below.
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TerminalServer.
3. Select Terminal Server registry.
4. Update value of fSingleSessionPerUser from 1 to 0, which will allow to login multiple session for single user.

1. Log into the server using Remote Desktop.

2. Open the start screen (press the Windows key) and type gpedit.msc and open it

3. Go to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Connections.

4. Set Restrict Remote Desktop Services user to a single Remote Desktop Services session to Disabled.

5. Double click Limit number of connections and set the RD Maximum Connections allowed to 999999.

AX 2009 AIF

Collection of some useful link for AX 2009 AIF.

http://ellipsesolutions.com/microsoft-dynamics-ax-2009-aif-integration-ap-invoice-journals/

https://dynamicsuser.net/ax/f/technical/41593/help-with-configuring-aif-webservices

AIF Installation

https://docs.microsoft.com/en-us/previous-versions/dynamicsax-2009/developer/cc652581%28v%3dax.50%29

https://blogs.msdn.microsoft.com/aif/2008/12/16/creating-custom-dynamics-ax-services/

Transaction log backup

In this post, i want to populate good to know information about log backup in SQL Server.

Query to know the history of transaction log backup.

SELECT      bs.backup_start_date, bs.backup_finish_date, *
FROM        msdb..backupfile bf
JOIN        msdb..backupset bs ON bf.backup_set_id = bs.backup_set_id
WHERE       bf.File_Type = 'L'

OR using

select database_name, max(backup_finish_date)
from msdb..backupset
where type = 'L'
group by database_name

Detailed reference for above query : Link

How often we should take transaction log backup: Link

 Recover data from transaction log backup: Link

Import Export model Dynamics 365 for operations

Following model management commands i have tried on Demo VM downloaded from LCS, which i found working as per the expectations.

Export model in Dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -export -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement" -outputpath=c:\temp

Import model in Dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -import -metadatastorepath=C:\AOSService\PackagesLocalDirectory -file=C:\Test\XYZDevelopments.axmodel

Delete model in dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -delete -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement"

Object Server XX: Fatal SQL condition during login.

Message in event viewer on AOS server:

Object Server XX:  Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (11/10). Use a newer Microsoft Dynamics AX kernel."

select * from SQLSystemVariables
WHERE PARM = 'SYSTIMEZONESVERSION'

Execute query above and check value in field "VALUE", it should look like image below. Please note that message in event viewer is helpful to update this value.

Event viewer message shows kernel (11/10) means current value is 11 and supported is 10, so here we need to update value to 10 using query below. - in your environment it can be 8/7 instead of 11/10 or it can be anything. I don't come across any MS documentation for the same. Please share your experience for the same error, does it works for you or have you solved by any other way.

update SQLSystemVariables set VALUE = 10
WHERE PARM = 'SYSTIMEZONESVERSION'

How to give authorization in fiddler

Fiddler: Set username and password for basic authentication

1. Open fiddler, click Tools->TextWizard.

2. Select checkbox of "To Base64"

3. Input your user name and password in top textbox such as

myUsername:myPassword

4. Go back to fiddler composer screen, below Host: line add line for Authorization as shown in image below.

Authorization: Basic bXlVc2VybmFSDlaAOaptOIeVBhc3N3b3J

https://XXX.YYY.ZZZ.AAA:4444/user/auth

User-Agent: Fiddler
Host: XXX.YYY.ZZZ.AAA:4444
Authorization: Basic bXlVc2VybmFSDlaAOaptOIeVBhc3N3b3J

Composer window should look like image below.

5. Hit execute.

6.Observe Result column on left side as well as Inspectors tab.

SQL Administration

I want to maintain this post to make my day to day SQL administration activities easy.

1. SQL always on demonstration. - Link
2. Tracking page split in detail - Link