Wednesday, December 14, 2011

Limit microsoft##ssee memory use in sbs 2011

Open SQL management studio as and administratror. This is the 2008R2 managemange studio, you must right click and run as admin. Once at the login screen type this in as the server:
\\.\pipe\mssql$microsoft##ssee\sql\query
and connect.

Once connected right click on the sql server DB, the very top thing and select properties.

Select the memory tab and adjust the max server memory.

Tuesday, December 13, 2011

GPO for WIndows Screen savers

If its a XP only enviroment you can do this from a 2003 server, if you have 2008 or Windows 7 machines you will either need to do it from a Windows 2008 server, or you will need to install the remote admin tools on a windows 7 machine so you have access to the admx files. The admx files need copied to the Windows 2003 server, they will go to the sysvol\your domain\PolicyDefinitions. The definitions should be under C:\Windows\PolicyDefinitions on your Windows 2008/7 machine.

From a 2008 server you can create your new GPO, the settings to change are:
User Config-Policies-Admin Templates-Control Panel-Personalization.
Enable Screen saver
Force Specific Screen Saver
C:\Windows\system32\scrnsave.scr (this is the one I use as its on all machines)
Password Protect (this locks the machine)
Prevent Changing
Screen saver timeout (in seconds)

If you are on a server 2003 machine with no Windows 7 machines:
User Config-Admin Templates-Control Panel-Display
The settings remain the same.