User Query: QuickBooks Database Manager keep losing connection to remote server, what to do?

QuickBooks software is one of the most sought after accounting software that has captured a huge share of financial software market by providing users with top notch services and exemplary customer support team. Intuit has setup an impeccable support team qualified to handle all sorts of errors irrespective of the situation and causes of the issue.

However, there are always complex problems faced with Database Manager Stops Working Accessing Server Remotely that can stump the user for a long time resulting in loss of business as the issue is not resolved in time.

One such issue and query was inquired about by the QuickBooks user regarding the QuickBooks Server 2003 employed in multi-user mode. The query and issue was quite complicated and asked by many user for swift resolution.

Query: The users are running the Database Server Manager on their 2003 version of Windows Operating System. The issue is whenever they remotely access the server, Database Manager automatically stops running.

The user has to manually login to QuickBooks through server, change the mode to single user and then log-out of the system. Then access the software again and re-change the mode to multi-user and again log-out of the system. Once this process is complete, users have to start the Database manager all over again followed by scanning the company files in order to check whether the system is working properly or not. The user is asking whether there is a setting that causes interruption with the Database Manager along with how common is this issue and corresponding resolution for the same?

Sometimes, information about the company file is not visible in the QuickBooks. This can be because the network connection is not able to access to the file contiguously or for other reasons which we’ll discuss later. If your company file does not show up and you’re getting this error message, it might mean that connectivity is the issue.

• Can’t communicate with QuickBooks server
• QuickBooks desktop unable to connect to the remote server
• QuickBooks server and workstation communication problems.

Remote Screen:

There are various remote screen tools available, but their concept is very similar – you set up a Remote Desktop connection in order to connect to the system running QuickBooks. When connected, you send back feedback and interaction with the user’s screen.

This system gives in-person interaction, which can be a downside if you want to keep the whole system under wraps: “A remote user has access to the whole system and anyone with access to the system will be given permissions to see what the remote user is working on.”

Remote Access to My QuickBooks Cloud

QuickBooks remote access has a great potential for small offices. This requires multi-user access without any expense of an official QuickBooks solution or the inconvenience of being locked out of the system, when using a remote access tool.

• This product differs from the actual remote access accounts in that you don’t tie up the hosting system, so local users can still run applications on some desktop computers.
• If you’re looking for a QuickBooks solution that is more affordable, hosted web-based solutions might be your answer. However, remember that you are still providing your own hardware and this adds to the complexity of cost calculations. In case you’re using a variety of add-ons or have a product like Microsoft Excel or need data export, sync with QuickBooks on the Web.

Causes behind to QuickBooks unable to connect to remote server issue

There are a few factors that can cause the site to generate the 500 Internal Server Error message. The most common causes of this error are listed below:

• The first reason that this can happen is if the QuickBooks file you’re trying to import is incorrectly hosted or does not have sufficient permissions.
• When the QuickBooks database server manager is not working, the QuickBooks client cannot connect to the server.
• If the local area network is not available, it will not function.
• You could face the same issue if there is not a proper set-up of the QuickBooks server.
• Any third-party firewall can also be one such factor.
• Outdated QuickBooks versions can sometimes cause errors in reports.
• If there is a halt in the connection of the QuickBooks server, you might see an error message.

Methods to Resolve QuickBooks Database Manager Stops Working when Accessing the Server Remotely

Here are some methods you can use to fix the QuickBooks unable to connect to remote server error. Let’s take a look.

Method 1: Resetting Internet explorer settings to default

To reset Internet Explorer settings to default:Go to “Internet Options” on the desktop.Select “Advanced” tab and make sure the compatibility view is not selected.Click “Apply.”

• In this method, first open the internet browser.
• Click the tools or gear icon after that.
• Now, navigate to the internet options.
• Here’s how to adjust advanced settings if you need a different margin or padding size: Click on the advanced tab and then click on the “Restore advanced settings” button.

• Next step is to hit a click on the OK tab and also close the browser.
• Now check the error is gone or not.

Method 2: Checking settings webmail preferences

If the issue still persists, try checking the settings for your webmail preferences. The steps are as follows:

• Navigate to the QuickBooks edit menu and select preferences.
• Add forms to your site on the left pane.

• And then select an email account that you’ve been using and click on the Edit option under Notifications Preferences.
• Next, click on the SMTP server section and then set the server name and port to the settings for your email provider.
• Final step of the process is to set up email service in QuickBooks for a list of SMTP server and ports.

Method 3: Creating the network data file (.ND file)

In case the above two methods fail, one option would be to create a network data file. Don’t worry, this process is easy as follows:

• First, press the Windows key once. Then, type in QuickBooks database server manager.
• If you’re having difficulty finding the QuickBooks server manager in the program list, uninstall and reinstall the QuickBooks.
• Followed by confirming the installation process.
• Now go to the QuickBooks database server manager window and browse to the location of the folder containing the company file. You’ll have to hit a click on “add folder.”
• Again hit a click on scan now when all the folder is added.
• Next, scan QB company files.
• At the end of the process, make sure to verify that your .nd files are created for each data file.

Method 4: Updating QuickBooks to the latest release

QuickBooks errors can often be fixed by updating to the latest release. Updating your software can fix recent issues and increase the speed of your company’s operations, but there are some steps that need to be taken before installing it. The process includes:

• To update QuickBooks to the latest release, click the help menu and then click on update QuickBooks desktop.
• After clicking the options tab, select all options.
• The next step is to click on “Update now” and also wait to get updates.
• Wait for the app to close. Then, reboot your computer and restart QuickBooks.

Method 5: Organizing QuickBooks database server manager

If none of the three methods worked in your favor, then you might want to consider using QuickBooks Database Server Manager. The steps involved under this method are as follows:

• The last method for exporting QuickBooks data is called the QuickBooks database server manager. This tool is located in the “Import and Export” sub-menu.
• Open the QuickBooks database server manager and delete the existing folders.
• Add the QuickBooks company file folder in the database manager.

• And towards the end, scan the folder and make the notes of the errors in database server manager.

Method 6: Validating QuickBooks desktop file hosting

One of QuickBooks’ desktop file hosting services is the ability to share accounting documents with other team members. The steps involved are:

Step 1: Turning off hosting on all workstations

• To access QuickBooks’ utilities, go to the file menu and select “utilities.”
• For now, just make sure you choose the “stop hosting multiple users at once” option.
• If you see a prompt that says, “Host multiple users / Stop hosting multiple users,” confirm it by pressing Yes.

Step 2: Turning on hosting on the server computer

• To get started, press Windows Key + R. Then type taskmgr in the box that appears and press Enter.
• After that, click on the “more details” of the task manager window.
• In the file finder window, click the services list and place QBBDBMgrN.exe to begin installing it.

• Followed by, pressing Windows + R keys to verify the file.
• Next step is to open the run box and then type services.msc and click on OK tab.

• Now press Q to find the QBDBMgrN.exe.
• And lastly, start the service and select the automatic start option.

Another Solution QuickBooks Database Manager Stops Working when Accessing the Server Remotely

Answers regarding the three questions asked by the users are:

First of all there is no setting within the software because of which the Database Manager working gets interrupted. The issue is quite common with users employing Windows Server 2003 and there is a feasible solution for the same. However, before proceeding to that there are certain points to be kept in mind:

• First and foremost, user will be required to configure the settings from the console (accessible through Keyboard, Monitor or Mouse) through remote desktop option via “%windir%\system32\mstsc.exe /console”.
• Use the “administrator” credentials to login within the system.
• Customize or remove firewall software and settings on the server.
• Customize the server settings to automatically login as the ‘administrator’ user to the desktop using either “TweakUI” or “regedit”.
• Install a completely updated full version of QuickBooks (preferably the latest one) to the server.
• Configure the desktop to go to a screensaver and be password protected on resume. This will lock the desktop after the wait time passes, securing your server.
• Open the company file and login as Admin. Next setup the QuickBooks software access to Host Multi-user access, and then log-out of the software.
• Restart the server, remove the keyboard/mouse, watch the monitor to test the auto logon to the desktop, and then remove the monitor.
• Open QuickBooks on a client computer. Confirm that Host Multi-user access is turned off. Confirm that any firewall software is turned off. Then, open the company file to test network access to QuickBooks.
• This will ensure QuickBooks environment stabilized and working smoothly.

In case the user is apprehensive regarding the security in following the resolution, then the process of locking the desktop system ensures the server’s admin desktop is also secure. It is important to disconnect with the Console RDP and not just logging off. Another important point to keep in mind is that firewalls are generally located in the gateway to Internet hardware.

Conclusion!

If the above points of solution do not help to resolve and configure the setting of Database Server Manager in tandem with Windows Server 2003, then the user should immediately get in touch with the experienced QuickBooks experts. This issue can be dealt by the user alone or by contacting the QuickBooks experts for sure shot resolution. In the situation user still faces the same problems; it is recommended to approach the QuickBooks experts who are extremely knowledgeable regarding all things QuickBooks set up by Intuit. Moreover, if there is any issue in connecting with the team of QuickBooks for the same user can connect with us at our toll free number and live chat option on our website – fastfix247.com.