PROBLEM:
- You have just installed MS CRM 4.0 Outlook 07 Offline Client and are receiving either of the following errors: “Action Microsoft.Crm.Config.Common.InstallDatabaseAction failed. CREATE DATABASE permission denied in database ‘master’” or “Action Microsoft.Crm.Config.Common.InstallDatabaseAction failed. The network path was not found.”
- The errors can appear when running the configuration wizard, when trying to access CRM or when trying to go offline.
- Error does not appear when using the web client.
- Server is running SQL Version 2000 or 2005 (could also happen with 2008)
- None of the rollups fix the problem
SOLUTION THAT WORKED FOR ME:
The error means CRM could not connect to the local database.
CRM 4.0 binds to a specific user when installed and set-up. The same user (the person who will use CRM on the client) needs to install AND run the configuration wizard. Since installing CRM requires administrator privileges, you need to give the user Administrator privileges on the local machine at least until the configuration wizard has completed and you have confirmed CRM is fully up and running. Not doing this means the CRM will fail to connect to the database (if it gets set up at all).
- If you have installed CRM under a different username to the one that will be accessing CRM, uninstall it completely, including the SQL databases (be careful when you uninstall the database as you could break other programs that rely on SQL). A reasonably good discussion about how to remove is here: http://bit.ly/aGCA33
- Ensure the user (who will be accessing CRM) has administrator privileges on the machine where CRM will be installed.
- After setting the user as an administrator, re-start the computer and start the installation again.
- Once you have installed CRM, run the configuration wizard under the same username as you used for the installation. Double check the server URL used in the configuration wizard. If that is misspelt, it will cause problems.
- After checking the operation of CRM, including the offline and online process, you can decrease the user’s privileges again and check the operation of CRM.
OTHER POSSIBLE SOLUTIONS:
If the above solution doesn’t work or only sort of works, it could be that the installation failed to set up the user as an administrator in SQL 2005 server on the client computer. So:
- Open SQL Server 2005 Surface Area Configuration on client computer (run under the client’s username with administrator privileges)
- Click Add New Administrator
- Most likely, only one role will be available in the left hand pane, the SysAdmin role for the CRM database. Add role to the right hand pane and click OK.
- Restart the computer
You should then be able to re-try the action that failed last time (whether it was the configuration wizard, offline process or accessing CRM).
NOTE: Sometimes the above process does not work, so you have to try again. Alternately, you can try creating the sysadmin user in SQL using command prompt:
- Ensure you are logged into the local machine as an administrator
- Click Start, type cmd or find Command Prompt in the start menu.
- Right click on cmd.exe / Command Prompt and select “Run as Administrator”
- Type cd c:\ (substitute appropriate drive letter). This should take command prompt back to the root directory of the drive
- Type sqlcmd -S .\crm and hit ENTER
- Type CREATE LOGIN [domain\user] FROM Windows and hit ENTER then type Go and hit ENTER again
- Type EXEC sp_addsrvrolemember @loginame = ‘domain\user‘, @rolename = ‘sysadmin’ and hit ENTER then type Go and hit ENTER again
- Restart the computer
Some other suggestions:
- Business Contact Manager and CRM are NOT compatible, so this error can occur when you fail to uninstall BCM before installing CRM.
- If the specific error message is “Action Microsoft.Crm.Config.Common.InstallDatabaseAction failed. Unknown user name or bad password”, follow instructions here: http://support.microsoft.com/kb/857505
-
Error could also occur if the CRM databases (and their containing folder) are compressed or if the user or Network Service does not have administrator control of them. Check properties of the folders and databases, which should be under one of the following in Vista and Windows 7, depending on the specific rollup installed:
- C:\Users\<username>\AppData\Roaming\Microsoft\MSCRM\Data (remember the AppData folder will be hidden, so you need to un-hide it), or
- C:\Users\<username>\AppData\Local\Microsoft\MSCRM\Data
- Run the diagnostic wizard and turn on tracing if not already enabled. If the wizard does not solve the problem, hopefully you can use the trace to track down where the failure is occurring. A good description of the diagnostic wizard and it’s functions can be found here: http://blogs.msdn.com/b/crm/archive/2008/01/22/introducing-mscrm-client-diagnostics.aspx
- If none of these work, call Microsoft Support, as it could be some hitherto unknown thing that will commit you to an insane asylum if you try to figure it out alone.
Categories:
CRM 4.0 Errors Tags:
PROBLEM:
- You are using MYOB accounting software (any version) and are receiving error “Print Error #5″ (printer error 5)
- You cannot open the Print Setup screen in MYOB
- Client is running Windows XP, Vista, Windows 7 or Windows Server / SBS 2003.
- The issue often presents itself when you first start or re-start the computer.
- It is most prevalent on computers that have networked and/or USB printers.
SOLUTION THAT WORKED FOR ME:
Close all programs then log off from Windows and log back in. Start MYOB within a few minutes of logging back in. Some people have suggested re-starting your computer however this doesn’t always work and of course, it takes longer.
If you have MYOB set up to prompt for printing of session reports upon exit, you will need to manually export the session report to PDF in order to print out later:
- Cancel out of the prompt window (either click the Session Report button or the red cross, then Cancel in the print window) to go back to MYOB without closing and enter into reports area
- click the Accounts tab then click Session Report at the base of the reports list
- click Send To then PDF
- choose location of report and click Save. You will receive the print error dialog again at that point but you can ignore this.
OTHER POSSIBLE SOLUTIONS:
MYOB support blames Windows software (refer to their rant here http://bit.ly/b7567j) but it’s actually an MYOB software design problem, as is the issue of having to run software as an administrator in Vista / Windows 7 not to mention the random crashes.
- Ensure you have a physical printer (not a network printer) set as your default printer in Windows.
- MYOB lazily recommend turning off UAC in Vista and Windows 7. You can do this but obviously, you lose the benefit of UAC. Not only that but many users have already tried this solution and failed, which is not surprising since Windows XP has exactly the same print issue and it doesn’t even have UAC – even if you have administrator privileges in Windows XP, you can still get this error.
- Uninstall MYOB, clear registry of any MYOB references and re-install. I haven’t found this useful but some people have.
- Update your printer driver, as it may be incompatible with MYOB.
- If running on Windows Server / SBS2003, check security permissions on the default printer. There is a reference to this here: http://w.e-e.com/qcCw7f (site requires a subscription but you can try free for 30 days to access this solution).
Categories:
MYOB Errors Tags:
PROBLEM:
- You have completed a full system backup in Windows Vista are need to restore individual files
- You are running Vista Ultimate, Enterprise or Business
SOLUTION THAT WORKED FOR ME:
Vista full system backup usually creates one VHD (Virtual Hard Disk) file per backed up drive. To restore individual files or folders, you need to read (or mount) VHD files. The best program to do that is WinImage, found here: http://www.winimage.com WinImage is a “shareware” product that can be used free for 30 days and costs about US$30 if used beyond that so it’s useful for restoring an important file in an emergency.
Before trying WinImage, if you need to restore a file that has corrupted or that you have accidentally deleted important information from, try to restore a shadow copy first. Right click on the file, go to the Previous Versions tab and see if there is a version that can be restored. If there are no shadow copies or recent enough copies, you will need to restore from a backup. If you use Vista Home versions, you can’t create shadow copies using Vista itself. Try Shadow Explorer to get around that limitation: http://www.shadowexplorer.com
Further information about this solution:
The Windows Vista backup utility (“Backup Status and Configuration” and “Backup and Restore Center”) enables you to backup user files or your entire PC. This utility presents a problem in that if you choose to backup just your files, individual files can easily be restored with the same utility later on but you can’t restore the entire system. However if you choose to backup the entire PC, you can restore the system but not individual files with the utility.
Microsoft suggest making a complete PC backup every so often and backup files in between that so individual files can be restored. That’s a silly idea that ends up complicating backup, which is at odds with their philosophy of simplification in Vista. Most users simply end up backing up their entire PC, unaware of the problem facing them should they try to restore an individual file later on – either to the same computer or to a different machine without the Vista backup utility. That’s why the need for WinImage.
OTHER POSSIBLE SOLUTIONS:
There are three other well known programs that read VHD files:
Some really good guides to using the Vista Backup and Restore utility are located here:
In Windows 7, you don’t need to go through this garbage. Just attach the VHD as an additional drive in the Disk/Computer Management utility. Easy instructions here: http://www.vistaclues.com/open-a-vhd-file-in-windows-7/
Categories:
Windows Backup Tags: