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

Error while connecting to Management Reporter 2012 CU13


This post just saved my day. Big time!

Ariston Javier Blog's

Error Messages:

System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://Server:4712/InformationService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. —> System.Net.WebException: Unable to connect to the remote server —> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.123.40:4712
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
— End of inner exception stack trace —
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()
— End of inner exception stack trace —

Server stack trace:
at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()
at System.ServiceModel.Channels.HttpOutput.Send(TimeSpan timeout)
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.SendRequest(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at…

View original post 162 more words

Upgrade to Windows 10 for free before time runs out


David Musgrave's Winthrop Development Consultants Blog

David Meego - Click for blog homepageWindows 10 was officially released on the 29th July 2015, and when it was released users of Windows 7 and Windows 8 were offered a free upgrade to Windows 10.

The free upgrade offer lasts for one year and so will expire on 29th July 2016. So this article is a reminder for everyone out there who has not upgraded yet to get a move on.

View original post 242 more words

Time to say Good Bye to OLE Notes


With Dynamics GP 2016, some of the conventional features are going away. One such major feature is OLE Notes. From Dynamics GP 2013 R2, Microsoft made it clear that they wanted to do away with OLE Notes. We got Document Attachment feature.

With GP2015 R2, Documents Attachment cemented its position firmly. We also got a utility namely “OLE Note Migration Utility” that would help us migrate OLE Notes to Document Attachment.

We now have the official word that OLE Note Migration Utility would no longer be provided with Dynamics GP 2016.

Anybody who is using OLE Notes must first migrate to Document Attachment while they are still on current version and then upgrade to Dynamics GP 2016.

More details are posted on the link above.

Good bye, OLE Notes!

VAIDY

GP2016 – Feature of the Day – Power BI Integration & Budget Import Enhancement


Another set of feature of the day posts reveal that Power BI is coming to GP.  Also we have got Budget Import enhancement. Links to the posts are below:

  • Duplicate Accounts Import Exception Report
  • Power BI Reports on Home Page – I would rather like to see Dynamics GP being added to the Power BI Connector Services. Don’t get me wrong. I love this feature, it’s great to have Power BI report widgets on GP home page. However, the ideal integration would be to see Dynamics GP Connector Service. I think that would possibly happen soon, considering the next feature.
  • Dynamics GP OData Service – This is going to be another important feature (HTML5 Web Client being the first one) that I have been waiting for. This will enable us to have an excellent Power BI integration. I am happy to see Power BI reports on GP Home Page, no doubt, but I am super excited about OData Service.

VAIDY

Management Reporter CU15 Available Now


We have got another cumulative update (CU), CU15, available for Management Reporter (MR). Dynamics CPM Team has posted the link to download CU15 with the list of new features.

Web Viewer Responsiveness and Data Mart Reset Through PowerShell are my favs.

Most important points to be note:

  • SQL Server 2012 or higher is mandatory now. Anyone who’s using a lesser version won’t be able to update MR anymore.
  • Installing .NET Framework 4.6.1 is mandatory and would require a reboot. We must make sure that proper downtime is added to the update schedule.

Direct Download Link (CustomerSource Access Required): Management Reporter for Microsoft Dynamics ERP Installs and Service Packs Overview

VAIDY

Time to say Good Bye to FRx…


If anyone out there still using FRx as their financial reporting tool, it’s time to migrate to Management Reporter.

Dynamics GP Support team has posted an article, Microsoft Dynamics GP 2016 is upgraded – What’s next?, on which they have announced that FRx is no longer supported with Microsoft Dynamics GP 2016.

Time to say good bye to FRx…

VAIDY