Thursday, 26 May 2011

List all users and email addresses in Exchange

Use this tool (VBS script) to generate the list:


http://exchangepedia.com/2005/09/how-to-export-all-email-addresses-from-a-domain.html


To get a list of users that have forwarding configured perform this Custom AD search


(&(mailNickname=*)(altRecipient=*))

Friday, 20 May 2011

Extact MSI files

Go here:
http://thebackroomtech.com/2007/08/23/howto-extract-files-from-a-msi-file-using-the-windows-command-line/

SQL Server: Database marked as suspect

If SQL Server thinks there is something wrong with a database - it will mark it as suspect to prevent any further damage, and refuse to mount it.

There are a couple of things we can to get things up and running again.

1. Instruct the server to mount the DB. This is done using the Query Analyser and feeding instructions to the server.
2. Check the database for corruption.
3. Put the system into production once we are sure the DB is 100%.

Refer to this for step 1: http://www.sqlservercentral.com/articles/Administration/unmarksuspect/137/

The reset command is:

sp_resetstatus @dbname = "db_name")

* replace db_name with the database name.

For the DBCC checks: http://msdn.microsoft.com/en-us/library/aa258278%28v=sql.80%29.aspx

The check command is:

DBCC CHECKDB('db_name')

* replace db_name with the database name.

Friday, 13 May 2011

Replace System Files - Windows 7

Windows 7 has very strict permissions on who can modify or delete files in the System32 and other critical folders. Do the following on particular files you need to replace to allow access:

Take ownership and grant permissions on the file

cd C:\Windows\System32\
TAKEOWN /F spoolsv.exe
ICACLS spoolsv.exe /grant administrators:F

You can now rename and replace the files as required.

Thursday, 21 April 2011

Reinstall RPC/HTTP Proxy in SBS 2008

This is generally if you are experiencing problems with the Outlook
Anywhere feature of Exchange - typically you get Exchange Server is down
type errors after authentication.

Disable Outlook Anywhere in EMC.

We are going to have to remove TS Gateway too - as it depends on the RPC
Proxy feature.

Backup the TS Gateway config then remove RPC Proxy feature - it will advise
that TS Gateway will need to be removed too.

Reboot server and uninstall will continue and complete.

Before re-installing the RPC Proxy and TS Gateway features add the
following registry key:
HKLM\SOFTWARE\MICROSOFT\RPC\RpcProxy
Under this key, create a new string value called "Website" and specify "SBS
Web
Applications" for the data.

Re-install RPC Proxy feature and after that install TS Gateway role.
Restore the TS Gateway configuration after installation.

Enable Outlook Anywhere in EMC. Wait around 15 minutes.

At this point you can restart the server to get things going - or restart
IIS and make sure all the Application Pools are running.

Outlook Anywhere should now be working.

Source URL:
http://microsofttoolbox.com/2009/12/how-to-reinstall-the-rpchttp-proxy-feature-in-sbs-2008/

Monday, 28 March 2011

Connect Apple iMac to SBS 2008 domain

Read this cheat sheet to connect Apples to Windows domains...

The only thing that got me was that the Directory Access (on OSX 10.6) is
NOT under Utilities - its now integrated under the Accounts in System
Preferences.

http://www.applesource.com.au/how-to/soa/Connect-a-Mac-to-Windows-Small-Business-Server/0,2000451082,339287478,00.htm

Thursday, 24 March 2011

Find email addresses in Exchange

Read the Thread here:
http://forums.msexchange.org/m_1800413517/mpage_1/key_/tm.htm#1800414154

Key suggestion:
"...Go to AD Users & Computers, right-click on
your Domain | Find | change the Find drop-down to "Custom Search" (you could
also change the "IN" drop-down to "Entire Directory" if you have more than 1
domains) | go to Advanced tab | type
type this into costum search box

proxyAddresses=smtp:user@domain.com ..."