Tuesday, 19 August 2014

Perform HP SIM 7.3 installation on Windows Server 2012R2

You will see management installation, not only client one.
You can easily get and install client for managing 2012R2 Server from other machine.

Problem with SIM installation on 2012R2 Server is because of two things:
1.Setup application have to be run with compatibility settings
2.Server needs to have SQL Server installed

Installation of SIM 7.3 step by step.

First run of Setup.exe

Unsupported OS error

Change setup.exe compatibility settings to Windows7

Another try to install

There are no active SQL server instances

Download SQL Server Express (here 2012 version)

Choose components: here SQL x64 and Management Studio_x64

Perform a new installation of SQL Server 2012

Choose instance name: here HPSIM

Choose service accounts and services startup type

Choose authentication mode and administrator account(you have to add one)

It goes

Instance is yet stopped and disabled

Change startup type to automatic and start service

Installation of management tools

Installation succeded

Run SQL Management Studio

Choose database engine and instance (here:HPSIM)

Go to server properties

Check "Allow remote conections to this server" and close MMS

Configure firewall rule to allow SQL port (default is 1433)

Add TCP rule

Select zones. You can select only one, for example the domain

Restart SQL Server instance

Did you know how to run SQL Sever Confirutaion Manager on 2012R2 Server?
No? You need to run mmc first and add snap-in

Enable TCP/IP connection and select desired port. Default is set for 1433.
Now you can run wizard again or just go on with one which was waiting for SQL database.
For this warning, just click OK.

Installation is in progress at last.
Click Next
Select No, click Finish and restart the server when you want.

Office 2013 and Exact Globe Next prior to 406 - cannot run Excel reports

When you have to upgrade your Office installation to 2013 version and using Exact Globe Next version before 406 then you cannot run Excel reports by default.
Office 2013 is not officially supported with Exact Globe Next version prior to 406.
But wait, there is a workaround to make both working, i.e. to run Excel 2013 reports on Exact Globe version 401 for example.

First you should try to install Office2010 on the top of the Office2013 and reinstall Exact Globe Next.
Just install Office 2010 as a second Office version and reinstall Exact Globe.
Then you can uninstall Office2010.

For me it worked for the two of three computers.

If you still cannot run Excel reports, then go to check your Windows registry:
1.Run regedit
3.Check if Excel.Application key is present.
4.If not, create it, and create subkey CLSID
5.Probably as option, but create the second subkey - CurVer
6.Go to HKEY_CLASSES_ROOT\Excel.Application.15\CLSID
7.Copy data value from (Default)
8.Go to Go to HKEY_CLASSES_ROOT\Excel.Application\CLSID
9.Paste data value to (Default) string
10.Restart the computer
11.Run Excel

12.Excel should ask if it should be default application for Excel file types
13.Answer yes, and select all file types as Excel 2013 defaults.
14.Run Exact Globe Next and check if reports works now

Monday, 28 July 2014

Outlook2013: Outlook hangs when loading profile

If your Outlook is trying to load the profile, but it lasts forever, check the following:

Run Outlook with Ctrl key pressed. This will run Outlook in safe mode.
If Outlook works, then do the following:

1. Run regedit 
2. Browse to HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common
3. Create a new key named "Graphics"
4. In graphics key, create a New DWORD (32-bit) Value named DisableHardwareAcceleration.
5. Enter Value data as 1

Powershell: Get list of installed applications

Enter this to retrieve list of installed applications:

Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\* |Select DisplayName, DisplayVersion, Publisher, InstallDate, HelpLink, UninstallString

Thursday, 17 April 2014

Windows Store doesn't work after upgrade to Windows 8.1

After moving from Windows 8 to 8.1 you may see that Windows Store no longer works.

To fix this, use this path:
1. Run CMD or powershell as an administrator
2. Enter this in cmd: powershell -ExecutionPolicy Unrestricted Add-AppxPackage -DisableDevelopmentMode -Register $Env:SystemRoot\WinStore\AppxManifest.xml
3. Type: start "" "ms-windows-store:"

Wednesday, 16 April 2014

Configuring SMTP relay for Office365 / Exchange Online

You've just migrated your mailboxes to the Office365. But what to do with copiers & printers which don't want to work with Office365 account, because they don't allow to use TLS?
Or how to send error or information events from your servers if you are using simple SMTP send?
Answer is - install SMTP server feature!
I will show you how to do this using 2012R2 server as a relay for SMTP.

First: you need to install SMTP on the server
1. Go to server manager, click Add roles and features and select SMTP Server feature. Standard installation is simple -after clicking 'Next' several times and 'Finish' in the wizard you will have SMTP server installed on your machine.
2. Go to the Server Manager again and click Tools: Internet Information Services (IIS) 6.0 Manager.

SECOND: configure SMTP server properties 3. Click on the [SMTP Virtual Server #1] and right click for properties

4. In the General tab in IP address section, select Advanced...:

Here you can configure port/ports on which your server will listen for connections
You can change it every time you will need it.
Click OK.

5. In the General tab you can limit connections to SMTP server to prevent flood of mails - for example from application which sent too much of them because of an error.
Use then "Limit number of connections to:" and put the number of connections.
I will leave this empty.

6. In the Access tab go to Authentication... Select Anonymous access only

Click OK.

7. Still in Access tab click Connection...I prefer to use "Only the list below".
Ir you are using this option, provide all IP addresses which will be using this SMTP server as a relay. Don't forget to add localhost:

8. Still in Access tab click Relay...Select hosts that will be relayed

9. In the messages tab you can configure message size, session size, number of messages per connection and number of recipients per message. You can change badmail directory too.

10. In the delivery tab you can play with retry, reply and expiration timeout intervals.
To configure delivery to Office365, go to Outbound Security..

11. In the Outbound Security window select Basic authentication and put your user name and password to the Office365 account, select TLS encryption. Click OK.

12. In the Delivery tab select Outbound connections...

13. In the Outbound connections window select 587 as a TCP port. Click OK.
You can configure here limit of outbound connections too.

14. In the Delivery tab, go to Advanced...Enter smtp.office365.com as a Smart host. Click OK

15. Click OK to accept all settings and close [SMTP Virtual Server#1] window.

THIRD: Add domain/domains that you are managing through the Office365

16. Go to the Domains section in SMTP Virtual Server - click Domains in the left pane.
In the right pane you should see only internal domain.

17. Add your domain that you are managing in Office365. Right click on the empty field in the right pane or on the Domain in the left pane and select New - Domain... 

18. Select Remote as a domain type, click Next

19. Enter domain name, click Finish

20. In the right pane you will see now new, added domain.

21. Click on this new domain in the right pane, do the right click and select Properties.

22. In the General tab select "Allow incoming mail to be relayed to this domain"

23. Still in General tab, select Outbound Security...

24. In the Outbound Security select Basic authentication, TLS encryption and fill in user name and password for Office365 account used to deliver mails in Office365. This is the same settings that was set in the step 11.

25. Click OK to leave the configuration menu.

26. It's always good to restart service after changes applied. So go to the IIS 6 Manager, right click IIS server name and select All Tasks - Restart IIS...

27. After service restart, refresh window with F5, click somewhere in the empty field, select [SMTP virtual server] and click Start

28. You can now test SMTP server and it's relaying function, for example using telnet.

Monday, 14 April 2014

IE 11 on 2012R2: Your security settings do not allow this file to be downloaded

When you try to download file on your new 2012R2 server, you could encounter a small problem - you cannot do it.

This time solution is really simple.
Go to the Internet options/Security
Click custom settings and select - Download-File download-Enable