Query SQL Server Version

select
SERVERPROPERTY('ProductVersion') as ProductVersion,
SERVERPROPERTY('ProductLevel') as ProductLevel,
SERVERPROPERTY('Edition') as Edition

http://www.stopdoingitwrong.co.uk/server-2012-rds-there-are-no-remote-desktop-license-servers/

You verify your configuration is as expected, that you have valid CALs installed on a Server 2012 terminal server licensing server and that the RD Licensing Diagnoser doesn’t report any errors.

The issue may be that there is a bug with Server 2012 RDS session hosts where they will not look to the licensing server for CALs when the grace period ends. Microsoft are reportedly aware of this but as yet there is no KBA or hotfix for it.

The solution is to open the registry editor on the affected session hosts and browse to the following:

HKLM\System\CurrentControlSet\Control\Terminal Server\RCM

If the ‘GracePeriod’ key exists you will need to delete it.

How can an unauthenticated user access a windows share?

http://serverfault.com/questions/51635/how-can-an-unauthenticated-user-access-a-windows-share

In my case, enabling the guest account and adding Everyone did not help (with a share on an older box with Windows Server 2008 SP2 in a domain and a Windows Server 2012 R2 machine from outside of the domain).

After following the excellent guide posted by Nikola Radosavljevic, anonymous access finally worked in my scenario.

Summary of steps:

Adding Everyone, Guest and ANONYMOUS LOGON to the permissions of the share.
Open the Group Policy Editor (e.g. by running gpedit.msc)
- Computer Configuration -> Windows Settings -> Security Settings -> Local Policies -> Security Options
- Accounts: Guest account status: Enabled
- Network access: Let Everyone permissions apply to anonymous users: Enabled
- Network access: Restrict anonymous access to Named Pipes and Shares: Disabled
- Network access: Shares that can be accessed anonymously: YOUR_SHARE_NAME

Windows 10 Cannot Access SMB Network

1. https://www.itechtics.com/enable-gpedit-windows-10-home/

2. https://techjourney.net/cannot-connect-to-cifs-smb-samba-network-shares-shared-folders-in-windows-10/

SQL data Type to C# data Type

http://stackoverflow.com/questions/425389/c-sharp-equivalent-of-sql-server-datatypes

SQL CLR types for Report Viewer 2012 -Error

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

http://serverfault.com/questions/465722/install-sql-clr-types-report-viewer-2012-on-sql-2008-server

Troubleshooting: Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...'

Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
This error can occur when there are multiple versions of the .NET Framework on the computer that is running IIS, and IIS was installed after .NET Framework 4.0 or before the Service Model in Windows Communication Foundation was registered.

Resolution

For Windows 7 and Windows Server 2008, use the ASP.NET IIS Registration Tool (aspnet_regiis.exe,) to register the correct version of ASP.NET. For more information about the aspnet_regiis.exe, see ASP.NET IIS Registration Tool.

To register the correct version of ASP.NET

On the computer that is running Microsoft Dynamics NAV Web Server components, open a command prompt as an administrator as follows:
1. From the Start menu, choose All Programs, and then choose Accessories.
2. Right-click Command Prompt, and then choose Run as administrator.
At the command prompt, type the following command to change to the Microsoft.NET\Framework64\v4.0.30319 folder, and then press Enter.
Copy
cd\Windows\Microsoft.NET\Framework64\v4.0.30319
At the command prompt, type the following command, and then press Enter.
Copy
aspnet_regiis.exe -iru

Font Size Decreases When Export to PDF in Crystal Report

If barcode size is not what you expect when export to PDF in Crystal Report, you need to look no further for solution.

To fix the bug, just follow steps below by adding 2 registry keys.

1. Select Start > Run. Type regedit and click OK.

2. For Crystal Reports 2008, Expand HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\Export.

For Crystal Reports 11.0, Expand HKEY_CURRENT_USER\Software\Business Objects\Crystal Reports.

For Crystal Reports 10.0, Expand HKEY_CURRENT_USER\SOFTWARE\Crystal Decisions\10.0\Crystal Reports\Export

For Crystal Reports 9,0, Expand HKEY_CURRENT_USER\software\crystal decisions\9.0\Crystal Reports\Export

3. Right-click the Export folder and select New > Key. This creates a new folder. Name the new folder PDF.

4. Right-click the PDF folder and select New > DWORD Value.

5. Name this 'ForceLargerFonts' with no quotes and note that it is case sensitive.

6. Double-click ForceLargerFonts and change the Value data to 1 and click OK.

7. Close all the registry folders and expand the following registry For Crystal Reports 2008, HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0\Crystal Reports.

For Crystal Reports 11.0, HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0.

For Crystal Reports 10.0, HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.0\Crystal Reports

For Crystal Reports 9.0, HKEY_LOCAL_MACHINE\Software\Crystal Decisions\9.0\Crystal Reports

8. Right-click the Crystal Reports folder and select New > Key. Name this key Export.

9. Right-click the Export folder and select New > Key. This creates a new folder. Name this folder PDF.

10. Repeat steps 4 through 6.

11. Close the Registry Editor and restart Crystal Reports.

After adding these two registry keys, Crystal Reports won't have this font size problem any more.

However, if you want to generate barcode in Crystal Reports from IIS server, you need to modify permissions of these registry keys.

IIS security model prevents the application pool identity to read those registry entries by default.

Open Windows application Regedit and browse to

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\Export\PDF

Right click the key and choose “Permissions” from context menu.

Add in default IIS user account. Usually it's IUSR_MachineName.

How to solve Microsoft.Jet.OLEDB.4.0 and Microsoft.ACE.OLEDB.12.0 problem IIS 7, IIS 8

https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Excel data export to SQL database

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Error

Download and install the following link,

https://www.microsoft.com/en-us/download/details.aspx?id=23734

Public key authentication using Cygwin

Overview

Enabling public key authentication allows us to seamlessly, without having to interactively enter credentials, perform the following tasks...

scp files from one host to another
Execute commands on remote host
Log on to remote host

The Cygwin sshd server runs as a Windows service under the Local SYSTEM account created with special privileges to run the service. For a Windows 2003 Server, sshd runs under local account, sshd_server. The sshd server authenticates user logins using a public/private key-pair.

Configure Cygwin sshd

In this example, we configure password-less public key authentication to a remote Worklight host. We will leverage a user named "WorklightAdmin"

Install Cygwin.During installation, select the following packages...
- Admin --> cygrunsrv
- Net --> openssh
After installation, edit...
...add the following line...
For example...
Start a Cygwin terminal using "Run as Administrator"
Verify Cygwin is installed property...
All Cygwin help options should display on the screen.
From a bash shell, configure SSH...
You are prompted to answer the following questions:
At this point, for our example, we enter yes, and then plug in our WorklightAdmin user name and password...
If the configuration is successful, you will see the following message:
If you ever want to change the login ID of the Cygwin sshd service afterwards...
1. Open the Services panel
2. Stop the sshd service.
3. Next, select the Log on tab. Under the Log on as section or prompt, clear the Local System account radio button, and select This account.
4. Type .\WorklightAdmin as the ID and type the password for the account. Click Apply.
Grant additional rights to the WorklightAdmin account. Ensure that the account has the required privileges in addition to membership to the Administrators group.
1. From the Windows Start menu, click...
2. Verify the WorklightAdmin account has the following four rights:
  - Adjust memory quotas for a process
  - Create a token object
  - Log on as a service
  - Replace a process level token
  If not, add WorklightAdmin as a user with the four rights.
Close the Local Security Settings window.
From a Cygwin console panel, change ownership of the following directories and files to WorklightAdmin:
- chown WorklightAdmin /var/log/sshd.log
- chown -R WorklightAdmin /var/empty
- chown WorklightAdmin /etc/ssh*
Restart the Cygwin sshd service.
...or...
To achieve a password-less login from HostA --> remoteWLhost
1. Login to HostA as user WorklightAdmin
2. Copy contents of...
  If .ssh/id_rsa.pub does not exist, run..
  Leave passphrase blank.
3. Log on to remote host (remoteWLhost) and paste the public key to...
  If the directory and/or file do not exist, create them.
4. Set permissions...
You can now run commands such on HostA such as...

Non-admin userID

If you try to connect to the Windows workstation using a non-administrator user ID, you might get error...

...add the user account to the Administrators group...

Go to...
Add the Administrators group to the list of groups that this account belongs to.
From the admin console, click...

Change public location in sshd_Config

# The default is to check both .ssh/authorized_keys and .ssh/authorized_keys2

# but this is overridden so installations will only check .ssh/authorized_keys

AuthorizedKeysFile /home/.ssh/authorized_keys

Database cannot attached because it is already existed in MVC 5

PM> sqllocaldb.exe stop v11.0
LocalDB instance "v11.0" stopped.

PM> sqllocaldb.exe delete v11.0
LocalDB instance "v11.0" deleted.

Parse JSON in C#

Post your JSON in http://json2csharp.com/. Take the resulting classes and merge duplicates, and you get:

public class AddressComponent
{
    public string long_name { get; set; }
    public string short_name { get; set; }
    public List<string> types { get; set; }
}

public class Bounds
{
    public Location northeast { get; set; }
    public Location southwest { get; set; }
}

public class Location
{
    public double lat { get; set; }
    public double lng { get; set; }
}

public class Geometry
{
    public Bounds bounds { get; set; }
    public Location location { get; set; }
    public string location_type { get; set; }
    public Bounds viewport { get; set; }
}

public class Result
{
    public List<AddressComponent> address_components { get; set; }
    public string formatted_address { get; set; }
    public Geometry geometry { get; set; }
    public bool partial_match { get; set; }
    public List<string> types { get; set; }
}

public class RootObject
{
    public List<Result> results { get; set; }
    public string status { get; set; }
}

Deserialize your JSON with Json.NET like so:

    var root = JsonConvert.DeserializeObject<RootObject>(result);

There are multiple results returned for your query, so you need to loop through the locations returned like so:

    foreach (var singleResult in root.results)
    {
        var location = singleResult.geometry.location;
        var latitude = location.lat;
        var longitude = location.lng;
        // Do whatever you want with them.
    }

Qt Type Convertor

// int to QString
QString::number(int)

//

Qt Timer

3 down vote

Other way is using of built-in method start timer & event TimerEvent. Header:

#ifndef MAINWINDOW_H
#define MAINWINDOW_H

#include <QMainWindow>

namespace Ui {
class MainWindow;
}

class MainWindow : public QMainWindow
{
    Q_OBJECT

public:
    explicit MainWindow(QWidget *parent = 0);
    ~MainWindow();

private:
    Ui::MainWindow *ui;
    int timerId;

protected:
    void timerEvent(QTimerEvent *event);
};

#endif // MAINWINDOW_H

Source:

#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QDebug>

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);

    timerId = startTimer(1000);
}

MainWindow::~MainWindow()
{
    killTimer(timerId);
    delete ui;
}

void MainWindow::timerEvent(QTimerEvent *event)
{
    //qDebug() << "Update...";

    ui->label->setText(QString::number(m_count++)); 
}

Telnet server in IMX6 Linux OS

* mkdir /dev/pts
* mount -t devpts devpts /dev/pts
*telnetd -l /bin/login

TFTP Server in Ubuntu

Install following packages.
```
sudo apt-get install xinetd tftpd tftp
```

Create /etc/xinetd.d/tftp and put this entry

service tftp
{
protocol        = udp
port            = 69
socket_type     = dgram
wait            = yes
user            = nobody
server          = /usr/sbin/in.tftpd
server_args     = /tftpboot
disable         = no
}

Create a folder /tftpboot this should match whatever you gave in server_args. mostly it will be tftpboot
```
sudo mkdir /tftpboot
sudo chmod -R 777 /tftpboot
sudo chown -R nobody /tftpboot
```
Restart the xinetd service.
```
sudo /etc/init.d/xinetd restart
```
Now our tftp server is up and running.

## TFTP from Target

GET: tftp -l [local file name] -r [remote file name] -g [server Ip]

PUT: tftp -l [local file name] -r [remote file name] -p [server Ip]

Linux Commands

// Share Windows and VMWare
.. Enable and Create Share folder in VM -> Settings -> Share Folder >.......
.. linux command : mkdir /mnt ...if mnt doesn't exit
sudo mount -t vmhgfs .host /mnt

Set up Qt 5.2 Environment

Install curl program if system don't support
# apt-get install curl

To get repo script
#curl http://commondatastorage.googleapis.com/git-repo-downloads/repo
> repo

Change permission of repo
#chmod a+x repo

Create BSP folder and go in
#mkdir fsl-community-bsp
#cd fsl-community-bsp

Download BSP
#../repo init -u https://github.com/Freescale/fsl-community-bsp-platform -b dora
#../repo sync

Install SDK

Prepare the environment:
$MACHINE=imx6qsabresd . ./setup-environment build

Compile the SDK:
$sudo apt-get install texinfo
$sudo apt-get install gawk
$sudo apt-get install chrpath
$bitbake fsl-image-test -c populate_sdk //Take long time to install

//Fail

My Note

Query SQL Server Version

Windows Mobile Device Center no longer works after Creator's Edition in Win10

Server 2012 RDS ‘there are no Remote Desktop License Servers available to provide a license.’

How can an unauthenticated user access a windows share?

Windows 10 Cannot Access SMB Network

SQL data Type to C# data Type

SQL CLR types for Report Viewer 2012 -Error

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

Troubleshooting: Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...'

Resolution

To register the correct version of ASP.NET

Font Size Decreases When Export to PDF in Crystal Report

How to solve Microsoft.Jet.OLEDB.4.0 and Microsoft.ACE.OLEDB.12.0 problem IIS 7, IIS 8

Excel data export to SQL database

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Error

Public key authentication using Cygwin

Public key authentication using Cygwin

Overview

Configure Cygwin sshd

Non-admin userID

Database cannot attached because it is already existed in MVC 5

Parse JSON in C#

Qt Type Convertor

Qt Timer

Telnet server in IMX6 Linux OS

TFTP Server in Ubuntu

Linux Commands

Set up Qt 5.2 Environment

About Me