How to change e-mail address to a MOSS 2007 user

You can find the users e-mail address information for MOSS 2007 in the UserInfo table on the Content Database for your MOSS 2007 site. The field is tp_Email.

Using a simple SQL UPDATE statement you can change the value for the e-mail. Be careful to select only the record you need.

Cannot Remote Control a Windows 2008 Terminal server session

Follow the article http://support.microsoft.com/kb/976110. It seems that a Hotfix is needed but the workaround steps worked like a charm for me. Take into account that changing the Local GPO as suggested in the article and then running a gpupdate /force will disconnect the current TS sessions. Users need to connect again but no programs are closed.

How to import .nk2 files into Outlook 2010

Check MS KB article http://support.microsoft.com/kb/980542

Re-initialize an identity field seed

In order to re-intialize an identity field in a table, the following command is needed (SQL 2005):

dbcc checkident ('<<table>>',reseed,<<new seed>>)

MOSS 2007: cannot delete a question in a survey (Unknown Error)

Problem: In a MOSS 2007, when try to delete a question in a survey a message saying Unknow Error (before SP2) or Unable to validate data.   at System.Web.Configuration.MachineKeySection (after SP2) is displayed.

Resolution: in the web server browse to the path C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS, open the file mngfield.aspx (if MOSS is not installed in the default paths, browse for the file) in Notepad and add the following line:

<asp:Content ContentPlaceHolderId="PlaceHolderSearchArea" runat="server">
</asp:Content>

We have MOSS installed in a front end server and the database in a backend server. I don´t know if other configurations this solution could work.

Exchange 2007 mailbox room always Tentative Accepting reservations

Problem: when send a reservation request to an Exchange 2007 mailbox room, the resource always return a Tentative Accepted message saying: Your request was received and is pending approval.

Resolution:

Using an account with Full Access permissions over the mailbox room, access it using OWA, go to Options, Resource Settings, under Resource Scheduling  Permissions make sure the second and third options are selected to "Select Users and Groups"

Grant FullAccess permission to a group of mailboxes

Problem: In Exchange 2007 we have a group of users inside a particular OU named "Disabled Users". We want to grant full access permission to those mailboxes to the Domain Administrator so we can backup content to a PST file.

Solution: Run the following shell command. <<my domain>> is the AD domain used by Exchange 2007

get-mailbox -organizationalunit "Disabled Users" |Add-MailboxPermission -accessRights FullAccess -user <<my domain>>\Administrador

802.11 WLAN credentials are automatically stored by Windows XP

Problem: When configuring Windows XP in order to connect to an 802.11 wireless LAN, credentials are automatically saved to user profile. So, every time the computer restarts, they are used again. This is a problem for Helpdesk Technicians who test the connection using Administrative credentials and then deliver the machine to the end-user.

Solution: Check Microsoft article http://support.microsoft.com/kb/823731 which summary is:

To remove your cached user credentials that are used for PEAP authentication, delete the HKEY_CURRENT_USER\Software\Microsoft\dot3svc\Interfaces\{InterfaceGUID}\UserData\Profiles\ registry key. To do this, follow these steps:

1. Click Start, and then click Run.


2. In the Open box, type regedit, and then click OK.


3. Locate, and then click the following registry key:
   
   HKEY_CURRENT_USER\Software\Microsoft\dot3svc\Interfaces\{InterfaceGUID}\UserData\Profiles\


4. On the Edit menu, click Delete.


5. Click Yes when you are prompted to confirm the deletion.


6. Exit Registry Editor.


7. Reboot the machine (this step is mine)

MOSS 2007 LOG file is big

Problem: In our MOSS 2007 server log file for SharePoint_Config database is huge, almost 14 GB size. We need to shrink the file and recover hard disk space.

Resolution: Execute the following SQL Sentence for the database above

USE SharePoint_Config
GO
DBCC SHRINKFILE(SharePoint_Config_log, 1)
BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
DBCC SHRINKFILE(SharePoint_Config_log, 1)

Internet Explorer Enhanced security runs despite being turned off

Problem:
In a Windows 2008 Terminal server non-administrative users get IE ESC prompts despite it is turned off for such users

Resolution:

Put these lines in a batch

---------------------------------------------------------------

Rundll32 iesetup.dll, IEHardenLMSettings
Rundll32 iesetup.dll, IEHardenUser
Rundll32 iesetup.dll, IEHardenAdmin

rem Optional to remove warning on first IE Run and set home page to blank or anything else.
REG DELETE "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main" /v "First Home Page" /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main" /v "Default_Page_URL" /t REG_SZ /d "about:blank" /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main" /v "Start Page" /t REG_SZ /d "about:blank" /f

---------------------------------------------------------

Use the following article to run the batch in the terminal server: http://support.microsoft.com/kb/195461

For more information about the reason for this problem, check this: http://social.technet.microsoft.com/Forums/en-US/windowsserver2008r2general/thread/c5572fc7-6e92-46f8-824d-baca246e3106

disabling adobe updater from running

Extract from: http://blog.stealthpuppy.com/deployment/deploying-adobe-reader-9-for-windows

To disable Updater from running automatically you can run the following command line as an administrator (or an elevated command prompt in Windows Vista /2008):

REG ADD "HKLM\SOFTWARE\Policies\Adobe\Acrobat Reader\9.0\FeatureLockdown" /v bUpdater /d 0 /t REG_DWORD /f

Alternatively, to completely remove Adobe Updater, after installation, delete this folder:

• C:\Program Files\Common Files\Adobe\Updater6 (32-bit Windows)


• C:\Program Files (x86)\Common Files\Adobe\Updater6 (64-bit Windows)

If Adobe Reader is running as a standard (or limited) user account, Adobe Updater won’t run at all, so it shouldn’t be an issue if you don’t give users administrative access to their workstations.

If you are virtualising Adobe Reader, then disabling or removing Updater is a must.

Cannot see more than 4GB of RAM in task manager

Problem: You have a system with Windows Vista, Windows 7 or Windows 2008 with more than 4 GB of RAM. You can see in the System Properties that there is more than 4GB but when you see the Memory value in task manager you see only 4 GB of RAM

Solution: open an elevated command line window (run as administrator) and type the command

BCDEdit /set PAE forceenable.

Reboot the machine

Word and PowerPoint documents suddenly shows unformatted text and boxes

Problem: When you open a Word or PowerPoint document which had been correctly saved days ago, some text or text boxes looks unformatted or are not displaying as you remember when the document was saved.

Troubleshooting: Check your default printer, may be it was changed to an local offline or generic printer or, if it is a network printer, it was disconnected a lot of days from the print server. Word and PowerPoint are particular reliant on Printer settings in order to show document content.