Tuesday, January 24, 2012

To Exchange Online or Not

Planning

Education 

 

Friday, January 13, 2012

Simple backup script for SQL Express

in backup.bat

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd.exe" -S (local)\TOCTTARGPPC05 -i "C:\Documents and Settings\Administrator\Desktop\backup.sql"

In backup.sql

BACKUP DATABASE [ETLSPA] TO DISK = N'\\mbbk\backup_to_folder\mbppc\mbppc.bak' WITH RETAINDAYS = 5, NOFORMAT, INIT, NAME = N'ETLSPA-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

 

 

Install PPC on Citrix server where C is not the root drive

The root drive is Y on Citrix. Updating PPC from web or admin install will fail because there's no valid path for the installer.

Workaround:

  1. Map a temp C drive

  2. Run PPCWebMultiSelect.exe from Y:\program files\Common Files\PPC\PPCWebMultiSelectInstaller\

Thursday, January 5, 2012

GPO

Symptom: unable to R-click in Windows Explorer on Terminal server.
Solution:

  • User Configuration | Administrative Templates | Start Menu and Taskbar

  • User Configuration | Administrative Templates | Windows Components | Windows Explorer

  • User Configuration | Administrative Templates | Internet Explorer | Browser Menus


 

This action requires Windows administrator permissions - Quickbooks Enterprise issue

Running Quickbooks Enterprise on Microsoft Remote Desktop server (2018), users get "This action requires Windows administrator permissi...