Yearly Archives: 2011

Limit SQL Server maximum memory SQL instance

  • Start SQL Server Management Studio
  • Connect to you SQL server instance
  • Start a “New Query”
  • And then put this into you SQLQuery1.sql window

sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 4096
reconfigure with override
go

  • Then push the execute buttom, this will limit you SQL instance to 4096MB or 4GB. Please beware of, if you have multiple instance each instance you wan’t to limit

Limit SQL Server maximum memory SQL of WSUS

  • Start SQL Server Management Studio
  • Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
  • Start a “New Query”
  • And then put this into you SQLQuery1.sql window

sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 256
reconfigure with override
go

  • Then push the execute buttom, this will limit you SQL of WSUS to 256MB, whitch should be enough.

TMG and Internet Explorer 9 – file:///C:/Program%20Files/Microsoft%20Forefront%20Threat%20Management%20Gateway/UI_HTMLs/Generic.htm?guid=

Hello

If you have Internet Explorer 9 and TMG / UAG installed on the same machine you need to apply this patch, else you will get:

file:///C:/Program%20Files/Microsoft%20Forefront%20Threat%20Management%20Gateway/UI_HTMLs/Generic.htm?guid=%7B1FC3773B-C941-450C-BA39-224904EFD093%7D

  1. * Open “C:\Program Files\Microsoft Forefront Threat Management Gateway\UI_HTMLs\TabsHandler\TabsHandler.htc”
  2. Search for the 3 lines which contain “paddingTop”, and remark-out each of them by adding “//” in the begining.
    Example: Change the line:
    m_aPages [niPage].m_tdMain.style.paddingTop = ((m_nBoostUp < 0) ? -m_nBoostUp : 0) ;
    into:
    // m_aPages [niPage].m_tdMain.style.paddingTop = ((m_nBoostUp < 0) ? -m_nBoostUp : 0) ;
  3. Save the file, and re-open TMG management console.

Windows cannot print due to a problem with the current printer setup

I have this error on my Citrix servers, where one user cannot print to one printers, while others user could.
“Windows cannot print due to a problem with the current printer setup”

The Danish error:
windows kan ikke udskrive pga. problemer med den nuværende printerindstilling

The fix was:

  1. Log on as the user have the problems
  2. Delete all printers in: devices and printers.
  3. Start regedit
  4. Navigate to: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices
  5. And delete all entry here, beware of not delete any entry that there still exist in devices and printers

The problems was that some printers are created with:

“\\\\server.domain\printname”=”winspool,Ne-01:”

will others are created with:

“\\\server.domain\printname”=”winspool,Ne35:” without the hyphen, and that seam to be the problems.

Get list of installed programs from dead disk ubuntu debian

If you have a dead installation, some will not boot you can use this commands, to get the list of installed programs.
grep -B 1 \
"^Status: install ok installed$" /media/recovery2/var/lib/dpkg/status | \
awk '/^Package:.*$/{print $2"\t\tinstall"}' | \
sort > package.list
And this command to install it on a new installation:
dpkg --set-selections < package.list
apt-get dselect-upgrade

Roles to be installed before Exchange 2010 SP1

Start powershell and run import-module servermanager

Then run

Add-WindowsFeature NET-Framework,RSAT-ADDS,Web-Server,Web-Basic-Auth,Web-Windows-Auth,Web-Metabase,Web-Net-Ext,Web-Lgcy-Mgmt-Console,WAS-Process-Model,RSAT-Web-Server,Web-ISAPI-Ext,Web-Digest-Auth,Web-Dyn-Compression,NET-HTTP-Activation,RPC-Over-HTTP-Proxy -Restart

Active Sync – Unexpected Exchange mailbox Server (Exchange 2003)

Unexpected Exchange mailbox Server error: Server: [server01.XXXX.XX] User: [[email protected]] HTTP status code: [503]. Verify that the Exchange mailbox Server is working correctly.

If you got this error, please follow this steps:

  1. Try disabling the firewall
  2. Reset Exchange Folder in IIS – http://support.microsoft.com/kb/883380 (Dont remove exchange-oma)
  3. Remove Exchange-oma and create it again http://support.microsoft.com/kb/817379
  4. Remove IPV6 from the server