Auto Refresh External data on Moss

Periodic refresh
By using Office Excel 2007, the workbook author can specify that data automatically refreshes at a specified interval after the workbook is opened for each connection in the workbook. For example, an inventory database may be updated every hour, and so the workbook author has defined the workbook to automatically refresh every 60 minutes. For more information, see Microsoft Office Excel 2007 Help.
A Web Part author can select or clear the Allow Excel Web Access Periodic Data Refresh property to enable or disable this periodic refresh operation, if the property has been defined by the workbook author. When the time interval elapses, by default, the following refresh alert prompt is displayed at the bottom of the Excel Web Access Web Part:
Refresh data for ? (Now) (Always) (Don't ask me again)
An Excel Web Access Web Part author can also set the Display Periodic Data Refresh Prompt property to control the behavior of the message that is displayed when Excel Services performs a periodic data refresh during a session:
Always means that the message is displayed with a prompt at each interval.
Optionally means that a user can choose to continue periodic refresh without displaying a message.
Never means that Excel Web Access performs a periodic refresh without displaying a message or prompt.

Free Sharepoint AD Password Change Webpart

http://userchangepassword.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=20130

Working with Recovery Storage Groups in Exchange 2007

http://www.msexchange.org/tutorials/Working-Recovery-Storage-Groups-Exchange-2007.html

Configure Incoming email in moss 2007

http://www.combined-knowledge.com/Downloads/Moss07incoming_e-mail.pdf

Fix Flash Player on Terminal Services

1. Download the latest Flash uninstaller on this page: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_14157&sliceId=1 and place it somewhere on your hard disk (C:\Temp is a good place)
2. Open a command prompt, navigate to the folder where you placed the uninstaller and run it with the "/clean" option, like this: "uninstall_flash_player.exe /clean" (without quotes - thanks Adobe for so clearly documenting any command line options for this tool...NOT !)
3. Click the Details button. If it lists any files as "Delete on reboot", then reboot now. Otherwise, just carry on.
4. Download the EXE installation package from here: http://www.adobe.com/support/flashplayer/ts/documents/tn_19166/Install_Flash_Player_9_ActiveX.zip 5. Use the Control Panel Add/Remove programs method to install it. This ensures that the Windows install notification API triggers correctly (as opposed to executing change user /install in a command prompt).
6. Use regedit and find the following key: HKCR\CLSID\{D27CDB6E-AE6D-11cf-96B8-444553540000} (on 64-bit Windows this one is located under HKCR\Wow6432Node\CLSID\{D27CDB6E-AE6D-11cf-96B8-444553540000})
7. Remove any permissions for the Everyone group. click Advanced and tick the box to propagate the permissions to all child objects.
8. Add the Everyone group and give it "Read" permissions on the key. Again, click the Advanced button and propagate the permissions to all child objects.
9. Repeat steps 6 to 8 on the subsequent key, called HKCR\CLSID\{D27CDB70-AE6D-11cf-96B8-444553540000}

Configuring RPC over HTTP on Exchange 2003

http://www.msexchange.org/tutorials/Outlook_2003_Connect_Exchange_2003.html

Why does it take so long for changes in mailbox quota limits to take effect?

This is very helpful.

http://sdrtech.weebly.com/exchange-2007.html

Cheap Tape media

Check this site for tape media, cheapest I can find.

http://www.digitaldevicesonline.com

Migrating from SQL 2000 to 2005

Really good article.

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html

Exchange Database Portability

http://www.msexchange.org/tutorials/Moving-Exchange-Server-2007-database-Mailbox-servers.html

DCOM Errors on MOSS Server

Dcom Errors after installing moss 2007

· Make sure that all your application pool identities are running as domain user or local user accounts, not "NETWORK SERVICE".
· On each Web server in the farm, make sure that the application pool user has the rights to activate the IIS WAMREG admin Service DCOM component. Follow the procedure below.
1. Start -> Run -> dcomcnfg.exe
2. Expand Component Servers -> Computers -> My Computer -> DCOM Config
3. Find IIS WAMREG admin Service, right click on it, and select "properties"
4. Click the "security" tab
5. Click the "edit" button in the "Launch and Activation Permissions" group
6. Add your application pool identity accounts here, and make sure they have local launch and activation permissions.
· IISRESET

Cannot access shares or printers across the LAN from Windows XP

http://support.microsoft.com/kb/841570/en-us?spid=3198&sid=216

Planning a Sites and Services Architecture for Exchange 2007

http://www.petri.co.il/planning-sites-services-architecture-windows-ad-exchange-2007-server.htm

Change SQL 2005 Collation

http://sdrtech.weebly.com/change-sql-collation.html

Moving a sharepoint SQL database to a new server

http://sdrtech.weebly.com/moving-a-sharepoint-db.html

Outlook 2007 does not close

http://support.microsoft.com/kb/946983

Improve performance on terminal server Windows server 2003

http://support.microsoft.com/kb/555741

Failover Clustering topics

http://msdn2.microsoft.com/en-us/library/ms190990.aspx

Transfer sql2005 logind to another instance

http://support.microsoft.com/kb/246133

Troubleshooting .NET 2.0 issues

http://support.microsoft.com/kb/908077

Set recovery for deleted items for all folders in Microsoft Outlook

http://support.microsoft.com/kb/246153

Disable KCC from creating automatic site links

http://support.microsoft.com/kb/244368

IIS Manager does not open

http://support.microsoft.com/kb/946517