Category Archives: Other

Other stuff ( wordpress / day-by-day / and more )

[FIXED] The System Administrator has set policies to prevent this installation

This error usually occurs on Windows Server 2012 even if you are logged with an local admin.

2014-10-13_22-26-01

Solution: 

1. Open a CMD (run as administrator)
2. Run (in the folder you have the installer. Change install.msi with the name of your .msi file):

 msiexec /i install.msi

How to delete a windows service (Windows Server 2003/2008/2012)

If you need to delete a Windows Service, you just have to open a new command prompt (run as administrator) and run the following command:

Command: sc delete NameOfService 

2014-10-13_21-40-13

How to import photos in Active Directory

AD
There is a minor schema modification required in order to enable the use of photos in AD. The change is to change the thumbnailPhoto attribute to make it replicate to the Global Catalog. If you do not have Exchange 2010 Service Pack 1 (SP1) installed (which automatically makes this Schema change), you do need to follow these steps: 

    • If you haven’t registered the Schema MMC snap-in on the server you want to make this change on, go ahead and do so using the following command: Regsvr32 schmmgmt.dll
    • Open an MMC console (Start/Run/MMC) and add the Schema snap-in.
    • In the Active Directory Schema snap-in, expand the Attributes node, and then locate the thumbnailPhoto attribute.
    • In the Properties page, select Replicate this attribute to the Global Catalog, and click OK.

Then you are ready to import photos into AD. This is done with a Powershell command, for example:

Import-RecipientDataProperty -Identity "Aurel Proorocu" -Picture -FileData ([Byte[]]$(Get-Content -Path "C:\pictures\AurelProorocu.jpg" -Encoding Byte -ReadCount 0))

The recommended thumbnail photo size is 96×96 pixels, and by default, the maximum size of photo that can be imported with the Import-RecipientDataProperty command is 10-KB. There are also options to force inclusion of the photo in the offline address book, see the ‘links for more information’ below on how to make those and other advanced changes related to AD photos.

Add created date and last modified time in a cell in Excel

If you want to add the last save time and/or creation date in Excel cells follow this steps (via VBA scripts):

date

1. Hold ALT + F11 keys, that will open the Microsoft Visual Basic for Applications window:

2. Click Insert > Module, and paste the following macro in the Module Window:

Sub Workbook_Open()
Range(“A1”).Value = Format(ThisWorkbook.BuiltinDocumentProperties(“Creation Date”), “short date”)
Range(“B1”).Value = Format(ThisWorkbook.BuiltinDocumentProperties(“Last Save Time”), “short date”)
End Sub

3. Press F5 key to run the macro.

Then it inserts the created date in Cell A1, and inserts the last modified date in Cell B1.
(you can modify the cells by simply editing the script and replacing A1,B1 with the desired cells)

Enjoy !

Blog is back online / Hosting problems

Because of some serious problems with the hosting provider I had to move the blog, and took it offline for a few months to move it to another host. 

Thanks BlueHost for support. Really a super professional hosting company. 
logo

Thank you all for the support & in the next days I am going to upload new materials with Windows 8 / Exchange server 2013  & other interesting things. 

How to open .jnlp files ?

1. You have to install / or update your Java for browser ( http://java.com/en/download/index.jsp )
2. Go to the *.jnlp file, and open with / Select “Java web Start” / click OK / and the application will run:

ENJOY.

And if you encounter any problems feel free to comment / contact me.