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

Event ID: 7001 - Source: VSS - Unable to create a shadow copy

When using Microsoft Windows Server, you may encounter the error message: "Unable to create a shadow copy."  In the Event Viewer, you may find the following Event: "Event ID: 7001 - Source: VSS - Unable to create a shadow copy."  This event involves the Volume Shadow Copy Service (VSS).  Most likely the Server was rebooted while creating a Shadow Copy.  Many websites describe deleting or renaming the C:\WINDOWS\SYSTEM32\WBEM directory used by Windows Management Instrumentation to resolve this issue.  This is not correct.  Following are the steps to resolve this issue: Double-click My Computer. Right-mouse click the Hard Drive causing the problem. Click the Shadow Copies tab. Select the appropriate Volume. Click Disable. Click OK. Click Start - Control Panel - Administrative Tools - Scheduled Tasks. Delete all tasks related to the Volume Shadow Copy Service. Reboot the Server. Double-click My Computer. Right-mouse click the Hard Drive causing the problem. Cl...
Post a Comment
Read more