Why you do not have Internet access when using static IP address in VM

Having ADIDAS being an Oracle VirtualBox VM running Windows Server 2016 with the following network configuration

C:\Users\Administrator.ADIDAS>ipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : ADIDAS
 Primary Dns Suffix . . . . . . . : shoes.local
 Node Type . . . . . . . . . . . . : Hybrid
 IP Routing Enabled. . . . . . . . : No
 WINS Proxy Enabled. . . . . . . . : No
 DNS Suffix Search List. . . . . . : storage.tucson.ibm.com

Ethernet adapter Ethernet 4:

Connection-specific DNS Suffix . :
 Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Desktop Adapter #2
 Physical Address. . . . . . . . . : 08-00-27-B3-26-28
 DHCP Enabled. . . . . . . . . . . : No
 Autoconfiguration Enabled . . . . : Yes
 Link-local IPv6 Address . . . . . : fe80::6164:77f5:e20c:8f75%8(Preferred)
 IPv4 Address. . . . . . . . . . . :
 Subnet Mask . . . . . . . . . . . :
 Default Gateway . . . . . . . . . :
 DHCPv6 IAID . . . . . . . . . . . : 285736999
 DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-20-AF-D9-C4-08-00-27-26-47-55
 DNS Servers . . . . . . . . . . . : ::1
 NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter isatap.{50BE229B-C2D8-414F-96A7-31062F6390D9}:

Media State . . . . . . . . . . . : Media disconnected
 Connection-specific DNS Suffix . :
 Description . . . . . . . . . . . : Microsoft ISATAP Adapter #2
 Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0
 DHCP Enabled. . . . . . . . . . . : No
 Autoconfiguration Enabled . . . . : Yes

Tunnel adapter Teredo Tunneling Pseudo-Interface:

Media State . . . . . . . . . . . : Media disconnected
 Connection-specific DNS Suffix . :
 Description . . . . . . . . . . . : Teredo Tunneling Pseudo-Interface
 Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0
 DHCP Enabled. . . . . . . . . . . : No
 Autoconfiguration Enabled . . . . : Yes


You still do not have Internet access.

Use ping menu option 7 from pFSense, and ping yahoo.com. See if it works.

Toggle the adapter name of the pFSense VM from Gigabit to TAP-Windows and click OK. Toggle back to Gigabit.

pFSense will change the WAN settings on that, and force a refresh.

Get back into VirtualBox settings for the pFSense and try again to see if you can ping yahoo.com address.

Back in Adidas you should have Internet access.



Posted in windows | Tagged , , , , | Leave a comment


Ceaiul care te ajută să slăbeşti 7 kg în 7 zile

Ghimbirul contine calciu, fier, magneziu, mangan, potasiu, proteine, carbohidrati, fibre alimentare, seleniu, sodiu, vitaminele C, E si B6. Uleiurile volatile din ghimbir au efecte analgezice, sedative si antitermice. Acestea ii dau gustul si aroma specifica si favorizeaza miscarea muschilor tractului gastrointestinal, contribuind la o mai buna digestie.

Exista mai multe variante pentru prepararea ceaiului de ghimbir:

Prima varianta: se adauga o felie de radacina de ghimbir la o cana de apa clocotita si se lasa sa infuzeze timp de jumatate de ora. Se bea cu inghitituri mici, de cateva ori pe zi, inainte cu 20 de minute de fiecare masa.

A doua varianta: se adauga jumatate de radacina maruntita de ghimbir, 60 g frunze de menta, un praf de nucusoara in apa clocotita si se lasa sa stea timp de jumatate de ora. Se filtreaza si se adauga 250 ml suc de lamaie si 80 ml suc de portocale, se amesteca bine si se bea rece.

Posted in misc | Tagged | Leave a comment

PowerShell Culture and Help



PowerShell session culture


## Test remote PS call from JACK on RHINO

$computerName = “lsc561.tw.ibm.com”
$remoteUser = “Administrator”
$remotePassword = “!Sp@-81#”
$credential = New-Object System.Management.Automation.PSCredential($remoteUser, (ConvertTo-SecureString $remotePassword -AsPlainText -Force))

invoke-command -ComputerName $computerName -Credential $credential `
-Authentication Credssp `
-scriptblock { `
function Set-Culture([System.Globalization.CultureInfo] $culture) { `
[System.Threading.Thread]::CurrentThread.CurrentUICulture = $culture; `
[System.Threading.Thread]::CurrentThread.CurrentCulture = $culture; `
}; `
Set-Culture (Get-ItemProperty ‘HKCU:\Control Panel\International’).LocaleName; `
# Set-Culture $(Get-Culture).ToString(); `
# Set-Culture de-DE; `
[system.threading.thread]::currentthread.currentculture; `
$env:computername; `
help Add-DpSqlPolicy -Full; `


$cult = get-culture | select-object *
out-string -inputobject $cult -width 100

System.Text.Encoding utf_8 = System.Text.Encoding.UTF8;

// This is our Unicode string:
string s_unicode = “abcéabc”;

// Convert a string to utf-8 bytes.
byte[] utf8Bytes = System.Text.Encoding.UTF8.GetBytes(s_unicode);

// Convert utf-8 bytes to a string.
string s_unicode2 = System.Text.Encoding.UTF8.GetString(utf8Bytes);


help Add-DpSqlPolicy -Full | select * -ExcludeProperty RunSpaceId | fl | out-string -Width 350
help Add-DpSqlPolicy -Full | select * -ExcludeProperty RunSpaceId | ft -autosize | out-string -Width 350


// Format from PowerShell Unicode to C# string
// Convert a string to Unicode bytes.
byte[] unicodeBytes = System.Text.Encoding.Unicode.GetBytes(text);
// Convert Unicode bytes to a string.
string text_string = System.Text.Encoding.Unicode.GetString(unicodeBytes);
Tm.TraceInformation(Tm.TraceFm, “text_string=” + text_string);
text = text_string;
Tm.TraceInformation(Tm.TraceFm, “text=” + text);


Posted in develop, windows | Tagged , , | Leave a comment

How to set the programming environment of Visual Studio

Q: I have set the programming environment of Visual Studio into C#. Now I want to change it to VC++.

A: To change the environment from C# to C++, please go to Tools menu >> Import and Export Settings >> Reset all settings.
Follow the instructions of the wizard and choose C++ as default development environment.

Posted in develop | Tagged , | Leave a comment

How to force restart the machine when you get A system shutdown is in progress.(1115)

shutdown /s /m \\hyper1vm6 /t 0
hyper1vm6: A system shutdown is in progress.(1115)

shutdown /a /m \\hyper1vm6
hyper1vm6: A system shutdown is in progress.(1115)

taskkill /s \\hyper1vm6 /U administrator /P password /im lsass.exe
>>> Causes a panic and the operating system HAS to restart

Posted in windows | Tagged , | Leave a comment

Legacy Restore INTO Behavior

It creates a new copy of the backup dbcomp. The new copy has the name specified in the INTO parameter.

For example,

tdpsqlc rest MARIADB Full /INTO=testmnt1

DPSQL trace shows the following T-SQL statement:

10/20/2017 10:09:54.096 [010124] [8996] : SqlApi.cpp (5525): Calling databaseH->ExecuteNonQuery()
wcslen(sqlWideCmdP): 265
sqlWideCmdSize : 4096


E. Copying a database using BACKUP and RESTORE
The following example uses both the BACKUP and RESTORE statements to make a copy of the AdventureWorks2012 database. The MOVE statement causes the data and log file to be restored to the specified locations. The RESTORE FILELISTONLY statement is used to determine the number and names of the files in the database being restored. The new copy of the database is named TestDB. For more information, see RESTORE FILELISTONLY (Transact-SQL).
BACKUP DATABASE AdventureWorks2012
TO AdventureWorksBackups ;

FROM AdventureWorksBackups ;

FROM AdventureWorksBackups
WITH MOVE ‘AdventureWorks2012_Data’ TO ‘C:\MySQLServer\testdb.mdf’,
MOVE ‘AdventureWorks2012_Log’ TO ‘C:\MySQLServer\testdb.ldf’;

Posted in data protection | Tagged | Leave a comment

How to setup an Active Directory domain controller in VirtualBox

Verbatim copy from http://www.fixedbyvonnie.com/2015/04/how-to-setup-an-active-directory-domain-controller-in-virtualbox/#.WeXhhWf6Uxl

How to setup an Active Directory domain controller in VirtualBox
Posted on April 20, 2015 by vonnie — 4 Comments

Over the next three days I’m going to show you how to setup Active Directory and join a PC to your new domain but I want you to know this isn’t something you can learn by reading. You need to do it.

You need to sit in front of a real Windows Server 2012 machine. You need to join a real Windows workstation to the domain. You need to interact with the software.

But how can you realistically do this? Well there are two options; no wait – three options:

You could completely abase yourself by buying your boss’s children Christmas presents so he would be more amenable to letting you setup a lab in the office.
You could cough up a butt load of money to buy real equipment
You could setup a free virtual environment on your computer in a completely isolated network. Then you could install Windows 8.1 and Windows Server 2012 virtual machines and configure a virtual switch to connect both computers.

Are you with me on option 3? I hope so! Let me show you how simple it is to pull this off.

“Simple” and “quick” aren’t synonyms. So although it’s easy to get going it will take a few hours to download all the files and configure your virtual environment.

Let’s get started.

If our virtual Active Directory Domain controller were a big juicy burger we would need a few ingredients to make it:

Windows 8.1 Pro
Windows Server 2012 R2

Snag VirtualBox

First, download and install Virtualbox on your host machine. Keep all the defaults. The install should zip by in seconds. This is the bun for our proverbial burger.
Filch Windows 8.1 Pro

Next, we need to obtain a real Windows 8.1 Pro ISO image. You can download the Windows 8.1 Pro media directly from Microsoft. In fact, if you can actually legally download every version of Windows for free. Consider this the lettuce and tomatoes.
Grab Windows Server 2012 R2

You can get the Windows Server 2012 R2 iso directly from the Microsoft Evaluation Center. Just signup and download. This is the 1/4 pound of grass fed organic beef. Without this our Active Directory burger is nothing.
Pilfer pFSense

pFSense will be the virtual router that gives us the liberty to connect our internal VirtualBox guest machines to the internet. pFsense is our special sauce.

Completing the above four steps could take several hours because of the sheer size of the Windows ISO files. These files are gargantuan (4GBs per file) so make sure you have ample space on your hard drive before you start the download frenzy.

Once you have all the ISOs on your computer we can setup the virtual machines.
Configuring the Virtual Machines

Setting up Windows 8.1 Pro in VirtualBox is almost identical to setting up Windows 10 in VirtualBox. The only difference is that under the Network tab in your VirtualBox Settings, Adapter 1 must be set to Internal Network. The name should also match for all hosts participating in the same internal network. I recommend the default intnet.

The internal network adapter names must match on your VirtualBox hosts

To setup your virtual machines, click the prickly blueNew button in the Oracle VM VirtualBox Manager and pick your OS version and memory size. Leave the Hard drive defaults alone and click Create.

Windows Server 2012 Virtual Machine

Click Create again on the next screen to keep all the defaults for the file size and physical hard drive type.

VirtualBox setting defaults

After creating the image, select it and choose Settings from the Oracle VM Virtualbox Manager screen.

Pick the Storage tab, and under the Storage Tree you should see a CD icon. We need to browse to the ISO we downloaded earlier so that the Virtual Machine will boot to it just like a real machine would boot to a physical CD.

Adding the ISO to VirtualBox

Now you can go through the installation just like a normal install. Install Windows 8.1 Pro in the same fashion.

After you have both operating systems installed you’re ready to setup pFSense.
Making sense of pFSense in VirtualBox

Getting pfSense to work in VirtualBox is basically the same except for a few differences:

Under Settings > System > Motherboard the Base Memory should be set to 256 MB. As you can see pFsense doesn’t need a lot of memory: 256 MB is sufficient.

pFSense in VirtualBox

Next, under the Network tab under Adapter 1, make sure it’s enabled and attached to your Bridged Adapter. This will be come your WAN (internet facing) interface in pfSense.

Setting the network settings for pFsense in VirtualBox

Then boot up the virtual machine and press Enter on the boot screen

boot up pfSense

Quickly press “i” to dive into the Installer setup.

Enter the pFsense Installer

In the blue Configure Console screen, choose .


Go with the

Quick and easy pfSense

Go ahead and erase the Virtual Disk. There’s obviously nothing on it.

Erase the virtual disk

Choose the Standard Kernel

Use the Standard Kernel

Then once the installation finishes, eject the virtual CD and reboot.

Eject the pFsense ISO

Boot to the main screen and skip the question about setting up VLANs.

Right now, we need to assign our interfaces so press 1.

pFsense mainscreen

You’ll be asked to enter the WAN and LAN interface names. Use em0 and em1 respectively. em0 should correspond to your bridged virtualbox interface.

em0 and em1 for pfSense

Great, when this finishes press the number 2 to configure the IP subnet for the LAN.

I used with mask (24 bit mask).

Configuring the adapters in pFsense

There’s no need to enable DHCP or revert to HTTP so just press enter to skip passed those options.

pFsense Configured

We’re done with our pFSense setup! Leave it running and minimize the virtual machine window.
Setting IP addresses on the Windows guests

Now we’re ready to configure the static IP addresses on our Windows guest machines.

Open up the Network Connection settings in your Windows Server 2012 machine and configure the following settings for your Internet Protocol Version 4 (TCP/IPv4) item:

Windows Server 2012 settings for VirtualBox

The DNS should be since we’re going to use the server itself as the DNS server.

On the Windows 8.1 Pro host, set the network settings as follows:

Windows 8.1 IP Settings

Also notice the DNS server is set to the IP of our Windows 2012 Server:

Now as long as both machines have network adapters set to Internal Network with the same name, you’ll be able to communicate.

Let’s just kick off a ping to verify…

Pinging the domain controller


Tomorrow starts your adventure setting up a Windows Server 2012 Active Directory environment.

You now have everything you need to follow along. You can do this. You will do this. I believe in you.

Posted in Uncategorized | Tagged , , | Leave a comment