// // Leave a Comment

Fix: Fatal Error: Failed to start and configure the WSUS service in Windows Server 2012 and Server 2012 R2

I ran into a Windows Update Server configuration problem a few days ago at a customer’s site.  I was were trying to install/configure Windows Update Server on Windows Server 2012.  The error was "Fatal Error: Failed to start and configure the WSUS service"  while configuring WSUS.

Capture1
Then I opened the temp log file of WSUS server as shown below. I was getting below marked error i.e. The request failed with HTTP status 503: Service Unavailable.
 Capture2
Actually issue was with the IIS WSUS Administration Website. So in IIS manager console I  deleted the "WSUS Administration" website as shown below.
 Capture3
Click Yes to remove selected site.
 Capture4
Now Complete the WSUS installation.
 Capture5
Read More
// // Leave a Comment

[Fix] Microsoft Outlook 2012 and 2013 hangs or stuck during startup while loading profile in Windows 8

Issue symptoms:- While opening Microsoft Outlook 2007, 2010, 2012 and 2013 it stucks at startup and shows Loading profile message as shown below.
Fix Microsoft Outlook hangs or stuck during startup while loading profile 01
Solution for above issue is very simple and its to scan your Outlook pst file for errors. ScanPST is a tool to scan and repair corrupted pst file.
What is the location of scanpst.exe?
Scanpst.exe location is different for each version of Office and below are the location of Scanpst for different version of Microsoft Office Outlook.
SCANPST IN OUTLOOK 2010 32-Bit
Windows 32-Bit   C:Program FilesMicrosoft OfficeOffice14
Windows 64-Bit   C:Program Files (x86)Microsoft OfficeOffice14
SCANPST IN OUTLOOK 2010 64-Bit
Windows 64-Bit   C:Program FilesMicrosoft OfficeOffice14
SCANPST IN OUTLOOK 2013 32-Bit
Windows 32-Bit   C:Program FilesMicrosoft OfficeOffice15
Windows 64-Bit    C:Program Files (x86)Microsoft OfficeOffice15
SCANPST IN OUTLOOK 2013 64-Bit
Windows 64-Bit  C:Program FilesMicrosoft OfficeOffice15
Windows 32-Bit    C:Program FilesMicrosoft OfficeOffice15
Windows 64-Bit  C:Program Files (x86)Microsoft OfficeOffice15
In my case for Office 2013 below is the location of Scanpst.exe,
 Fix Microsoft Outlook hangs or stuck during startup while loading profile 02
Open Scanpst.exe and browse the location of pst file which you want to scan. By default scanpst.exe will find location of your pst file.
 Fix Microsoft Outlook hangs or stuck during startup while loading profile 03
Scanpst will check your pst file for error.
 Fix Microsoft Outlook hangs or stuck during startup while loading profile 04
After scanning pst file it will ask to repair the pst file. By default it will create pst backup file.
 Fix Microsoft Outlook hangs or stuck during startup while loading profile 05
Once pst file repair completes you can open the Outlook without any issues.
 Fix Microsoft Outlook hangs or stuck during startup while loading profile 06
Read More
// // Leave a Comment

[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox and VMware Workstation

You can update your current Windows 8.1 Operating System to Windows 8.1 Update 1 by applying the update.
Windows 8.1 Update 1 9600.16610 Features,
Context menu changes
Live Tiles with resize, unpin options
Microsoft is planning to boot Windows 8.1 non-touch PC users to the desktop interface by default (but its still not clear)
Windows 8.1 Update 1 will support just 1GB of RAM and 16GB of storage will help to bring down price.
Microsoft will now release Windows 8.1 Update 1 to existing machines on April 8th
Be sure to install the files in the correct order,
1. Install Windows 8.1 Virtual Machine on Virtualbox / VMware Workstation.
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 01 2. Install all below updates for Windows 8.1.
· KB2883200
· KB2884846
· KB2887595
· KB2903939
· KB2911106
· Any other previous or released Windows Updates.
3. Install Windows8.1-KB2919442- .msu update,  This is required to install before you install the Windows 8.1 Update MSU update.
4. You must restart the PC to complete any pending update actions.
5.  Install the Windows8.1-KB2919355 to the image by double-clicking on the file.  This update will take time to install & machine will freeze in between.
6. Restart your PC.
Read More
// // Leave a Comment

Hands-on Windows 8.1 Update 1 Build 9600.16610 Spring Update

Windows 8.1 Spring Update 1 build 9600.16610 leaked onto the web for download in .MSU file format. This new  build included new and exciting features like
Context menu changes
Live Tiles with resize, unpin options
Microsoft is planning to boot Windows 8.1 non-touch PC users to the desktop Interface by default

Windows 8.1 Update 1 will support just 1GB of RAM and 16GB of storage will help to bring down price.
Microsoft has started sharing Windows 8.1 Update 1 with partners and PC makers ahead of its release next month. Microsoft will release Windows 8.1 Update 1 to existing machines on April 8th, following the company’s Build developer conference in early April.
So lets check new and exciting features on Windows 8.1 Update 1,
1. Live Tiles with resize, unpin options – Now you can resize tiles with new Windows 8.1 update1.
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 02
Microsoft has added new feature for start screen i.e go to the desktop instead of start, So that you will always see the desktop when you boot into your Windows 8.1 PC.
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 03
 Power buttons – New quick power buttons on the Start Screen to shutdown or restart PC.
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 04
Multiple selection of tiles to Resize tiles, to pin to taskbar
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 05
Now you can sort application by name,by date installed, by most used and by category.
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 06
Microsoft recently announced that SkyDrive is being renamed to OneDrive due of dispute with BSkyB. With Windows 8.1 update 1 you will see the new name of SkyDrive i.e. OneDrive
 [Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 07
Microsoft has added Disk space management option in PC setting. 
[Guide] How to Install Windows 8.1 Update 1 Build 9600.16610 on VirtualBox 08
Read More
// // Leave a Comment

Solved: Windows 8.1 Shows as Windows 6.3 in WSUS

After upgrading Windows 8.0 to Windows 8.1, the PC now appears in WSUS server with Windows 6.3 as the operating system. The workstation appears to be pulling updates for Windows 8.1 from WSUS, but it's listed as 6.3.
Windows 8.1 Shows as Windows 6.3 in WSUS 1 Nothing surprising there for me as Windows 8.1 is the product name and 6.3 is the version number. As expected.
But if you like to show the correct OS name in WSUS you have to follow below workaround.
First you need to download and install below patches on WSUS server,
KB2720211
KB2734608
Once you installs above patches, install
Microsoft ODBC Driver 11 for SQL Server
SQLCMD Microsoft Command Line Utilities 11 for SQL Server

Now you will need to Re-index the WSUS 3.0 Database, to do the same download Re-index the WSUS 3.0 Database script
In my case I have created SQL.sql file on c:\ and copied Re-index the WSUS 3.0 Database script in to the same and at the end I have copied below script,
 
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 8.1'
WHERE [OSMajorVersion] = '6'
AND [OSMinorVersion] = '3'
AND [OldProductType] = '1'
AND ([OSDescription] <> 'Windows 8.1' or [OSDescription] IS NULL)
Windows Server 2012 R2 :
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2012 R2'
WHERE [OSMajorVersion] = '6'
AND [OSMinorVersion] = '3'
AND [OldProductType] <> '1'
AND ([OSDescription] <> 'Windows Server 2012 R2' or [OSDescription] IS NULL)

So that it will change OS name from Windows 6.3 to Windows 8.1 and same for Windows Server 2012.
At the end my whole script will look like as below (i.e. SUSDB)
/******************************************************************************
This sample T-SQL script performs basic maintenance tasks on SUSDB
1. Identifies indexes that are fragmented and defragments them. For certain
   tables, a fill-factor is set in order to improve insert performance.
   Based on MSDN sample at
http://msdn2.microsoft.com/en-us/library/ms188917.aspx
   and tailored for SUSDB requirements
2. Updates potentially out-of-date table statistics.
******************************************************************************/
USE SUSDB;
GO
SET NOCOUNT ON;
-- Rebuild or reorganize indexes based on their fragmentation levels
DECLARE @work_to_do TABLE (
    objectid int
    , indexid int
    , pagedensity float
    , fragmentation float
    , numrows int
)
DECLARE @objectid int;
DECLARE @indexid int;
DECLARE @schemaname nvarchar(130); 
DECLARE @objectname nvarchar(130); 
DECLARE @indexname nvarchar(130); 
DECLARE @numrows int
DECLARE @density float;
DECLARE @fragmentation float;
DECLARE @command nvarchar(4000); 
DECLARE @fillfactorset bit
DECLARE @numpages int
-- Select indexes that need to be defragmented based on the following
-- * Page density is low
-- * External fragmentation is high in relation to index size
PRINT 'Estimating fragmentation: Begin. ' + convert(nvarchar, getdate(), 121) 
INSERT @work_to_do
SELECT
    f.object_id
    , index_id
    , avg_page_space_used_in_percent
    , avg_fragmentation_in_percent
    , record_count
FROM 
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'SAMPLED') AS f
WHERE
    (f.avg_page_space_used_in_percent < 85.0 and f.avg_page_space_used_in_percent/100.0 * page_count < page_count - 1)
    or (f.page_count > 50 and f.avg_fragmentation_in_percent > 15.0)
    or (f.page_count > 10 and f.avg_fragmentation_in_percent > 80.0)
PRINT 'Number of indexes to rebuild: ' + cast(@@ROWCOUNT as nvarchar(20))
PRINT 'Estimating fragmentation: End. ' + convert(nvarchar, getdate(), 121)
SELECT @numpages = sum(ps.used_page_count)
FROM
    @work_to_do AS fi
    INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
    INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id
-- Declare the cursor for the list of indexes to be processed.
DECLARE curIndexes CURSOR FOR SELECT * FROM @work_to_do
-- Open the cursor.
OPEN curIndexes
-- Loop through the indexes
WHILE (1=1)
BEGIN
    FETCH NEXT FROM curIndexes
    INTO @objectid, @indexid, @density, @fragmentation, @numrows;
    IF @@FETCH_STATUS < 0 BREAK;
    SELECT 
        @objectname = QUOTENAME(o.name)
        , @schemaname = QUOTENAME(s.name)
    FROM 
        sys.objects AS o
        INNER JOIN sys.schemas as s ON s.schema_id = o.schema_id
    WHERE 
        o.object_id = @objectid;
    SELECT 
        @indexname = QUOTENAME(name)
        , @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END
    FROM 
        sys.indexes
    WHERE
        object_id = @objectid AND index_id = @indexid;
    IF ((@density BETWEEN 75.0 AND 85.0) AND @fillfactorset = 1) OR (@fragmentation < 30.0)
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE';
    ELSE IF @numrows >= 5000 AND @fillfactorset = 0
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD WITH (FILLFACTOR = 90)';
    ELSE
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';
    PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' + @command;
    EXEC (@command);
    PRINT convert(nvarchar, getdate(), 121) + N' Done.';
END
-- Close and deallocate the cursor.
CLOSE curIndexes;
DEALLOCATE curIndexes;
IF EXISTS (SELECT * FROM @work_to_do)
BEGIN
    PRINT 'Estimated number of pages in fragmented indexes: ' + cast(@numpages as nvarchar(20))
    SELECT @numpages = @numpages - sum(ps.used_page_count)
    FROM
        @work_to_do AS fi
        INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
        INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id
    PRINT 'Estimated number of pages freed: ' + cast(@numpages as nvarchar(20))
END
GO

UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 8.1'
WHERE [OSMajorVersion] = '6'
AND [OSMinorVersion] = '3'
AND [OldProductType] = '1'
AND ([OSDescription] <> 'Windows 8.1' or [OSDescription] IS NULL)

UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2012 R2'
WHERE [OSMajorVersion] = '6'
AND [OSMinorVersion] = '3'
AND [OldProductType] <> '1'
AND ([OSDescription] <> 'Windows Server 2012 R2' or [OSDescription] IS NULL)

--Update all statistics
PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121) 
EXEC sp_updatestats
PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121) 
GO



Now save above script on c:\ as sql.sql and open Command prompt and run below command,
Default path of sqlcmd is C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn. So go to C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn folder and run below command,
 
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn>SQLCMD.EXE -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -i c:\SQL.sql >c:\output.txt
Capture 2 you can check the output in output.exe for errors/results.
Windows 8.1 Shows as Windows 6.3 in WSUS 3
Now run the WSUS server clean up wizard and restart WSUS server. Now your Windows 8.1 workstation will be shown as Windows 8.1 in WSUS server as below.
Windows 8.1 Shows as Windows 6.3 in WSUS 4

Read More
// // Leave a Comment

Guide: Recover Permanently Deleted Emails Microsoft Outlook 2013 in Windows 8.1

Whenever you delete an email in Microsoft Outlook it directly goes to the Deleted Items folder in MS Outlook and this gives you a chance to recover if you delete an email by mistake.
If your organization is using an Microsoft Exchange server, then Exchange Server stores deleted emails for a length of time, and its called the Retention Period. Exchange Administrator can set the retention period, before exchange server permanently deletes the emails.
The Exchange servers have a Retention Period of 60 days.


Below steps will explain how to recover deleted Emails from Microsoft Outlook. You can recover deleted emails from Deleted Items folder in MS Outlook. But if you deleted emails permanently then how to recover it?
Open Microsoft Outlook 2013 and Navigate to Folder->Recover deleted items,
 
How to recover permanatley deleted emails from Outlook 2013 01
Select Emails which you want to Recover & click on Recover button as shown in below screen shot.
How to recover permanatley deleted emails from Outlook 2013 02
Now recovered Email will be available in Inbox folder in Microsoft Outlook 2013.
How to recover permanatley deleted emails from Outlook 2013 03







Read More