Connect SQL Operations Studio For Mac to a SQL Server in Parallels VM


I’m slowly moving away from Windows. However, being a Microsoft Dynamics GP consultant, that’s not entirely possible. I’ve been working hard to overcome every single roadblock since the last couple of years.

One major gripe, among several others, was the inability to connect the SQL Server instance on my Windows 10 virtual machine, mounted using Parallels. Until now.

Microsoft released SQL Server Operations Studio, which is still under preview, for us to connect to a SQL Server from Windows, Mac OS or Linux. I now have the choice to work from either my Mac OS or my Windows 10 VM.

However, there are some steps we must follow to successfully connect to a SQL Server instance on a virtual machine. This post, from Anton Sizikov, is probably the easiest one to follow. Following the steps explained on this post, Connecting SQL Operations Studio to SQL Express Server in Parallels VM, I was able to successfully use my SQL Server Operations Studio to connect to my VM SQL Server. Below is the SQL Ops Studio in all its “dark theme” glory:

Screen Shot 2018-05-16 at 16.18.41

I couldn’t use my Mac more than pretty much for just browsing, emailing and other daily digital chores. This is one huge step forward to start utilising it well.

Vaidy

 

Advertisements

CredSSP Encryption Oracle Remediation Error – Remote Desktop Connection


Word of Caution: This article contains a procedure to edit/change Windows Registry. Please take necessary precaution before attempting this.

I received an error this morning while trying to connect to one my clients’ server. The message as follows:

Screen Shot 2018-05-10 at 09.45.07.png

With the help of one of my contacts at the client site, also upon searching and following the link provided in the message itself, couple of help pages stood out:

  1. CredSSP updates for CVE-2018-0886
  2. CredSSP encryption oracle remediation

For those who would like to see the solution immediately without having to go through the details from above links, I shall brief the solution itself here.

There are basically two solutions:

  1. Run “Windows Update” on the remote server (or the workstation) to which you are trying to connect. This will ensure that you have the latest patch on the remote box and you wouldn’t be facing this issue again. This would work provided your machine also has got the latest updates applied.
  2. For those who cannot update the remote box for some reason(s), you would have to create a new registry entry as shown below:

Screen Shot 2018-05-10 at 14.24.19.png

Once above registry key is created, you must restart your workstation / client / computer without fail.

All good now to successfully connect to the remote box again.

A note of thanks to Dave.

Vaidy

Off-Topic: Mac OS High Sierra Push Notification Banners Issue


I’m blogging after a painfully long time. And, I’d like to share something really interesting that happened on my MacBook Pro this week.

I reset my Mac with Mac OS High Sierra (10.13.4) and all of a sudden, all my notifications stopped working. The Dock labels would show, sound would be there, yet mysteriously, banners wouldn’t come. Upon checking the notification area, there wasn’t any recent notifications listed at all. Baffling, to say the least.

Screen Shot 2018-04-19 at 11.00.36 am.png

Then I chanced upon this apple support forum discussion, Mail notifications | Official Apple Support Communities.

Despite the discussion being for Mail App, the solution given on this discussion worked for me for all apps’ notifications.

Solution is quite simple; change the alert notification from “Alerts” or “Banners” to “None” and change it back. Easy, isn’t it? Not exactly. I had to do this for all of my apps, using the notification centre.

Screen Shot 2018-04-19 at 11.04.49 am.png

I can’t complain though. It’s working now, that’s all I need.

If someone’s having same issue and is looking for a solution, look no further. Check out the discussion on Apple Support Forum (link provided above).

Vaidy

 

Windows 10 Creator Update & Dynamics GP


An interesting issue/question was posted on our community forum regarding an error message popping up while exiting GP2015 R2 & GP2016 R2.

Specifically, GP2015/2016 R2 on Windows 10 Creator Update is what seems to be throwing this error while exiting.

Link to original forum post: Windows 10 Creator and GP2015 R2

One member, Ron Koendrink, figured out that it’s Mekorma MICR that’s causing this issue on his environment. Per his update, Mekorma had confirmed that it’s an issue for which a fix was available.

Anyone out there who use Mekorma MICR and planning to upgrade your OS to Windows 10 Creator Update, please contact them and get the fix.

A note of thanks to Ron.

Vaidy

GP2016 DAG Issue


I am wondering whether someone has already faced this issue and has shared his/her knowledge on this.

My issue is with GP2016 VS Tools Dictionary Assembly Generator (DAG), where it takes more than 10 mins to complete generating DYNAMICS.DIC assemblies. Not only that, it also doesn’t generate Application.MicrosoftDynamicsGp.dll in the first attempt itself.

Look at the following screenshot:

Screen Shot 2017-04-28 at 01.29.38 pm.png

First two “successful” attempts of running DAG created only the metadata files and not the actual DLL. I’m running the DAG for the third time, as I write this post.

UPDATE: Third time’s the charm. I am baffled, though.

I have no clue, whatsoever, about why this is happening.

My question(s) to all you guys:

  1. Have you faced this issue?
  2. If so, what did you do to resolve it?
  3. If you have not found any solution (other than running DAG till it creates the DLL), have you already reported this to GP dev team?

Please shed some light on this by sharing your thoughts on the comments section.

Vaidy

Install/Upgrade Error: Input string was not in a correct format


I had to apply GP 2016 YE2016 (16.00.0579) on my GP2016 R2 environment. I had several customisations deployed and wanted to remove them before applying the YE2016 patch.

Obviously, I’d upgrade my customisations to 16.00.0579 once my GP is upgraded. However, while trying to apply YE2016, following error message popped up out of nowhere.

Screen Shot 2017-04-27 at 03.32.02 pm

I had never seen this error before. It was certainly a bit baffling. Not even Google is good compared to our GP community forum to find answers. I came up with this: Installation error ‘Input string was not in a correct format’

Apparently, it was my DYNAMICS.SET that was causing this issue. I removed my customisation dictionaries from GP folder, removed all necessary entries from my SET file. However, I totally forgot to reduce the number of dictionaries at the top of my SET file. Silly me!

Once I corrected my SET file, I was able to apply the YE2016 patch. All was well.

One thing I would like to emphasise here: Those who post questions on our GP forum, please mark the response as “answer” without fail. You would help others who search for an answer. You’d also give due credit to the person who shared his/her knowledge.

Vaidy

Barry Crowell’s Next Post on Dynamics GP & Power BI


Another excellent article from Barry Crowell on Dynamics GP and Power BI:

During my last blog post, I walked you through creating a financial dashboard using Power BI with Dynamics GP data. I have created additional analysis and measures now. If you look closely at the bottom left, you will see two additional reports for Sales Summary and Customer Analysis. Sales Summary The data used from Dynamics […]

via Supercharge Your Dynamics GP Dashboards & Reports with Power BI — My quest in SQL, BI & Dynamics GP