QuickBooks R12 Update iAnywhere.SAClrClassLoader firewall settings
I have two or more articles covering different issues on the R12 updates.
When applications update you should always keep in mind your current security settings and compare them after any software has been updated. In this case iAnywhere.SAClrClassLoader which is part of the SQL database server application should only be.
The summary about says it all except for the last line.
SQL servers running on local machines should only be allowed to connect to safe networks.
In other words do not allow this connection to be accessible via the internet but do allow this application to be accessed from your local machine and if you use it over your local network you can allow it to connect to trusted networks which should be your local LAN.
If you do not use the SQL function with your program you might be able to block connections in and out. I haven't tested this but it shouldn't change anything if you connect to your company files using the standard C:\ location.
Test it and if it doesn't work then allow it on your local LAN which might be 192.168.0.1 or you can allow 127.0.0.1 or localhost.
The key is to make sure your security settings remain the same prior to the R12 and the iAnywhere.SAClrClassLoader update.
If you have any questions feel free to post a comment.
Quickbooks update can not update file due to permissions at location X.
Often Quickbooks will attempt to update a file that has specific security permissions assigned to it during the original installation. To correct this temporarily here is what you can do.
During the Quickbooks update if you see a message that shows permission issues you can change the folder permissions to finish the update and then return the permissions to how they were prior to the update.
Say you read a message "Unable to update filename in folder C:\Program Files\Intuit\QuickBooks 2010" Click Retry or Cancel.
You can take the easy route and assign "Everyone" to this folder during the installation and then remove the Everyone permissions after the installation has finished.
Image showing Everyone permissions added to folder during update.
After the update be sure to remove the Everyone Full Permissions from the folder you changed.
Have questions? You should start in the Intuit Community which offers great technical support. Remember that most configuration settings are for single computer not network connected. Also if you are using ROAMING profiles in your network you can not set the data location to your local profile unless your IT Admin has set the Global Security Policies to allow this. But that's for another post another day.
QuickBooks application corrupted after System Halt NDIS.SYS (Blue Screen)
It happens and when it does it's good to be able to troubleshoot based on the last 3 things that a person was doing before the Blue screen / system halt screen.
The following message isn't new to many people but it was new to me.
QuickBooks was unable to open the company file...
A possible reason for this may be that you don't have read/write permissions. ...
Error codes: (-6189,-101).
Resolved by taking the following action.
After following the help file instructions from Intuit and finding the error was still not allowing the company file to load I needed to check into if the application was part of the blue screen issue. (Not related)
The quickest method is to "Repair" the installation.
When I ran the Repair Application (QuickBooks) from the Add and Remove Software another error was reported.
That made it clear that the application was corrupted and at the time I was keeping my fingers crossed about the data not being corrupted.
I removed the QuickBooks 2010 and reinstalled it. Applying R12 update the company file then loaded just fine.
Moral of the story: If you don't see the fix and what you were told to try didn't work then remove or repair the software. (If not both) You might save time and find the same issue I found.