Tag: Windows

How to map client certificates in IIS 7 through graphical user interface

This is a repost of a post from an old blog, made on July 20, 2012, that used to be on:

http://adminramble.com/map-client-certificates-iis-7-graphical-user-interface/

Original post:

As you may know if you want to map client certificates to IIS 7 for authentication purposes, you must use the editor by default, as described in this blog.

If you want to have the IIS 6 like option of mapping the certificates through UI, you cam checkout this blog, and download the ClientCertificateMapping extension for IIS 7.

After installing the extension you will get new Client Certificates option in the IIS right side window

 

which will open a window like this one

 

Msg 3154, The backup set holds a backup of a database other than the existing database

This is a repost of a post from an old blog, made on March 15, 2012, that used to be on:

http://wp.me/p25nt4-4A

http://adminramble.com/msg-3154-backup-set-holds-backup-database-existing-database/

Original post:

I got asked for help today at work by a coworker who got the following error when trying to restore a database to a different already existing database:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘database_name’ database. (Microsoft.SqlServer.Smo)

when trying to restore with script he would get something like this:

Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing ‘database_name’ database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

The solution for this is simple: you need to add WITH REPLACE option when restoring.

If you’re using script it should look something like this:

RESTORE DATABASE [database_name] FROM  DISK = N'C:\some_directory\backup.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 10
GO

If you’re using GUI you need to mark the on the Options section.

Hyper-V server Event ID 3112: The virtual machine could not be started because the hypervisor is not running – How to fix

This is a repost of a post from an old blog, made on March 25, 2012, that used to be on:

http://wp.me/p25nt4-5g

http://adminramble.com/virtual-machine-wont-start-hypervisor-isnt-running-fix/

Original post:

Today I was encountered with a problem with one of the computers that was running Windows Server 2008 R2 with Hyper-V. When I would try to start any of the virtual machines installed on it I would get the following error:

The virtual machine could not be started because the hypervisor is not running

I instinctively checked the BIOS if VT is enabled and it was.

When looking in the Event Viewer I would see Event ID 3112 so I started looking the Technet for other possible errors on that ID.

The problem for me was in BCD and Intel VT-d (Intel Virtualization Technology for Directed I/O), I needed to enable VT-d and put hypervisor in Boot Configuration Data to autolaunch with the following command (you need to runa cmd as an Administrator with elevated privileges):

bcdedit /set hypervisorlaunchtype auto

Here is a little checklist if you get this kind of error:

  1. Check if Intel VT or AMD-V hardware extensions are supported on your CPU and are enabled in BIOS
  2. Check if No eXecute (NX) for AMD and eXecute Disable (XD) for Intel CPU are enabled in BIOS
  3. Check your BCD with bcdedit (the problem with me was, that it was a classroom computer with dual boot Windows 7/Server 2008, and the BCD was changed with Win 7 reinstallation)
  4. Check if Intel VT-d is and Trusted Execution enabled/disabled (This one is little strange to me, because if you look here it states it needs to be disabled, but for me I had to enable VT-d in BIOS)
  5. Check if you enabled Hibernation or Sleep on your server, it changes your “hvboot” registry value. Try to start it in elevated Command Prompt with command:
  6. net start hvboot

Hope this helps somebody, because I got a little frustrated with this error today

Windows 2008 server hangs at “Applying user settings”, services not working

This is a repost of a post from an old blog, made on July 17, 2012, that used to be on:

http://wp.me/p25nt4-7f

http://adminramble.com/windows-2008-server-hangs-applying-user-settings-services-working/

Original post:

Today I had a problem with one of my test servers that was running Windows 2008, I was doing some work with IIS and certificates and after rebooting I wasn’t able to connect to it with Remote Desktop, also I wasn’t able to connect to the web sites that were on it, but it responded to ping requests.

When I tried to connect to it locally, after entering username and password it would just stay on the “Applying user settings” screen.

The solution to this is very simple:

  1. Either wait for you server to eventually finish the logon process or reboot it in the safe mode with F8
  2. Open registry editor with regedit
  3. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP and create the following Multi-string value: DependOnService
  4. Double click the entry, enter CRYPTSVC in the Value Data field and click OK
  5. Reboot your server to Normal mode

You can also solve the problem with the Hotfix available from Microsoft.

NOTE: the KB article states that this happens on Windows Vista and Server 2008 with Service Pack 2, but in my case I had Windows Server 2008 Service Pack 1.

How to convert batch of doc files to docx, this should also work for ppt and xls files

This is a repost of a post from an old blog, made on July 23, 2012, that used to be on:

http://wp.me/p25nt4-7r

http://adminramble.com/convert-batch-doc-files-docx-work-ppt-xls-files/

Original post:

Today I had to need to convert a bunch of old Office 2003 .doc files to a new Office 2010 .docx, file format, since it was a few hundred files that I had to convert I started looking for a easiest way to do it, after a few minutes of Google search through solutions with using macros I find one that doesn’t require any macros or programming on this blog.

You can do it using Microsoft Office Compatibility Pack and Microsoft Office Migration Planning Manager.

Here are the steps needed for a bulk conversion from .doc to .docx:

  1. Download Microsoft Office Migration Planning Manager (MigrationPlanningManager.exe, 2.7 MB)
  2. Download Microsoft Office Compatibility Pack (FileFormatConverters.exe, 37.0 MB)
  3. Extract Office Planning Manager (OMPM) to some directory (I used d:\doc2docx for example here)
  4. Go to Tools directory where you extracted OMPM (in my case d:\doc2docx\Tools)
  5. edit the ofc.ini file for following lines: 
    FullUpgradeOnOpen=1
fldr='path to directory with .doc files you want to convert'
DestinationPathTemplate='path to where you want to save converted files'

    Your ofc.ini file should look something like this:

    [Run]
LogDestinationPath=C:\OMPM\OFCLogs

TimeOut = 300

[ConversionOptions]
; FullUpgradeOnOpen: if set to 1, Word documents will be fully converted to the OpenXML format
;                    if set to 0 (default), Word documents will be saved in the OpenXML format in compatibility mode
; Not applicable to Excel or PowerPoint files.
FullUpgradeOnOpen=1

CABLogs=1

MacroControl=0


[FoldersToConvert]
fldr=d:\doc2docx\Files2convert

[ConversionInfo]
SourcePathTemplate=*\*\*\
DestinationPathTemplate=d:\doc2docx\ConvertedFiles
  6. open command prompt and run ofc.exe from Tools directory (in my case D:\doc2docx\Tools\ofc.exe), you should get a message like this one: 
    d:\doc2docx\Tools>ofc
Microsoft Office File Converter version 12.0.4518.1032
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
Automatically converts Office documents to 2007 Microsoft Office system file for
mat based on settings in the OFC.INI control file.
Converting files from folder d:\doc2docx\Files2convert
Converting: d:\doc2docx\Files2convert\4thFile.doc Writing converted file to: d:\
doc2docx\ConvertedFiles\4thFile(1).docx
Converting: d:\doc2docx\Files2convert\File1.doc Writing converted file to: d:\do
c2docx\ConvertedFiles\File1(1).docx
Converting: d:\doc2docx\Files2convert\FileNo3.doc Writing converted file to: d:\
doc2docx\ConvertedFiles\FileNo3(1).docx
Converting: d:\doc2docx\Files2convert\SecondFile.doc Writing converted file to:
d:\doc2docx\ConvertedFiles\SecondFile(1).docx
Converting: d:\doc2docx\Files2convert\ThisIsFile5.doc Writing converted file to:
 d:\doc2docx\ConvertedFiles\ThisIsFile5(1).docx
Start: 2012-07-23 16:05:12
End: 2012-07-23 16:05:17
Total time used to convert files (sec): 4
Total number of files processed: 5
Total number of files converted: 5
Conversion Complete.
d:\doc2docx\Tools>