Skip to main content

Intuit Quickbooks 2016 Database Server Manager Stopped + Windows Server 2012 + SQLAny Event ID 1

Today, I was contacted by a customer regarding the Intuit QuickBooks 2016 Database Server Manager running on their Windows Server 2012.  Since May of 2016, they have been able to start or restart their QuickBooks Database Server Manager without issue.  As of a day ago, QuickBooks Database Server Manager would not start.  The error logged in the Event Viewer was SQLANY Event ID 1, SQLANY 16.0 cannot be found.  This would lead one to believe the QuickBooks Database Server Manager needed to be reinstalled on the Server.  This was not the resolution to the issue.  A page on the QuickBooks Community website indicated the latest update for QuickBooks needed to be manually installed on the Server.  This was also not the resolution to the issue.  I was able to isolate the cause of the issue when I read on a third-party website that if you stop the Windows DNS Server Service and then try starting the QuickBooks Database Server Manager, you may find the QuickBooks Database Server Manager starts without issue.  I did as instructed and it did start without issue.  This would lead one to believe the problem is a port conflict between the port being assigned to the QuickBooks Database Server Manager Service (QuickBooksDB26) and the Windows DNS Server Service.  This was not the cause of the issue.

The issue was resolved by Intuit QuickBooks Technical Support instructing me to change the QuickBooks Database Server Manager Service (QuickBooksDB26) from logging on as QuickBooksDB26 to Local Account and Allow Service to Interact with Desktop.

So in effect, I was told by Intuit to change the LogOn settings of the Windows Service designed by Intuit from the default Intuit setting to a custom setting.  First, I am perplexed as to why this issue arose out of nowhere when there have been no changes to the Server.  Second, I find it odd that if this is a known issue by Intuit wouldn't the installer have set the LogOn to Local Account upon installation.  Third, what is the purpose of the installer creating QuickBooksDB26 if it is now not utilized by the Service?

Comments

Post a Comment

Popular posts from this blog

Access Denied (policy_denied). Your system policy has denied access to the requested URL. For assistance, contact your network support team.

While browsing the internet, you may encounter the message: "Access Denied (policy_denied).  Your system policy has denied access to the requested URL.  For assistance, contact your network support team."   This message indicates the internet traffic is being filtered.  The most common source of an internet traffic filter is in corporate environments that use a proxy server or a firewall appliance designed to filter web traffic.  Some businesses are configured as satellite locations using a VPN tunnel.  In these configurations, the VPN may be configured to filter internet traffic.  In rare instances, the Internet Service Provider is filtering internet traffic.  Typically though, your IT Department or a Network Management Team has configured your internet traffic to be filtered.  Isolating Source of Web Filtering In an environment that is unmanaged and the source of the filtering is unknown, following are some steps you may wish to peform: Th...
3 comments
Read more

How do you stop an unstoppable Windows Service?

You may encounter a Windows Service in Services that has the buttons for Start, Stop, Pause and Resume greyed out.  If you attempt to stop the Service using sc stop [servicename], you encounter the error message: "The requested control is not valid for this service."  To resolve this issue, please perform the following steps: Click Start - Control Panel - Administrative Tools - Services. Double-click the relevant Service. Change the Service Start-Up Type to Disabled. Click Apply. Click OK. Hit CTRL-ALT-DEL on your keyboard. Select Task Manger. Perform an End Task on the relevant Service. This issue has been resolved. http://www.smartnetadmin.com
Post a Comment
Read more

The L2TP connection attempt failed because the security layer encountered a processing error during initial negotiations with the remote computer.

You may encounter the following error message when using the L2TP/IPSec VPN Client that is native to the Windows Operating System: "The L2TP connection attempt failed because the security layer encountered a processing error during initial negotiations with the remote computer."  This error message typically occurs when you are using the wrong Pre-Shared Key for your L2TP VPN.  This error message can occur when other components of your configuration are incorrect but the first thing to confirm is that you are using the correct Pre-Shared Key. If you are using the wrong Pre-Shared Key, the L2TP VPN connection will say Connecting for a long period of time and then display the error message: "The L2TP connection attempt failed because the security layer encountered a processing error during initial negotiations with the remote computer." If you are using the wrong username or password, the L2TP VPN will immediately respond with: "The remote connection was denied b...
1 comment
Read more