Thursday, 22 January 2015

Enable Remote Connections for SQL Server Express 2012

  1. Run SQL Server Configuration Manager.
  2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
  3. Make sure TCP/IP is enabled.
Then,
  1. Right-click on TCP/IP and select Properties.
  2. Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
  3. Scroll down to IPAll.
  4. Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)
  5. Make sure that TCP Port is set to 1433. (Mine was blank.)
If follow these steps, it's not necessary to enable SQL Server Browser, and only need to allow port 1433, not 1434

After all, go to Windows Service Manager and RESTART the SQL SERVER service to apply the changes.



Wednesday, 21 January 2015

Soild State Hard Disk Performs Very Slow in Windows 8.1

To fix this problem, execute the following command and restart the computer:

Start > Run > Winsat Format


Sunday, 18 January 2015

Opening Excel File using Task Scheduler

It might be the DCOM permissions issue. One solution is to set Excel to run as a specific user through DCOM permissions.
  1. Open Component Services: Start > Run > DComcnfg
  2. Drill down to: Component Services > Computers > My Computer > DCOM Config
  3. Right-click on 'Microsoft Excel Application' and choose Properties
  4. In the 'Identity Tab', select 'This User' and enter the username and password of an interactive user account (domain or local) and then click Ok
Keeping it as the interactive user or the launching doesn't work with the task scheduler, even when setting the task to run under an account that has admin rights to the machine.


Tuesday, 13 January 2015

React

A JavaScript library for building user interfaces. more...


Bootstrap

Bootstrap is the most popular HTML, CSS, and JS framework for developing responsive, mobile first projects on the web. more...


Tuesday, 30 December 2014

HTC ONE M7 Battery Issue

In case the HTC One M7 mobile phone:
  • Takes long time to charge the battery
  • Phone gets too hot during charging the battery
  • Battery drained very fast even on a simple task
Take the following steps:
  • Turn off (uncheck) the Fast Boot option under Settings > Power
  • From Settings > About > Software Information > More, tap on Build Number until put the phone in Developer Mode
  • Reset the phone and go to Recovery Mode (press Vol Down and Hold Power button)
  • Clear the Cache and restart the phone

 

Analysis Service in Power BI Report Server

 We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link