Windows Server 2008 R2 is as Router role

How to make Windows Server 2008 R2 as LAN Router device? It is very simple for everybody if we search the related information by Google or Microsoft.

(1).Add Server Roles --- Network Policy and Access ServicesIn Server Manager, click “Add Roles” to trigger the wizard
Click “Next > “ button
Enable “Routing and Remote Access Services” check box next to click “Next > “ button
Click “Next > “ button
Enable “Routing and Remote Access Services” check box so that Remote Access Service and Routing will be selected. To click “Next” button to continues the next step.
Click “Installation” button
If no any exception, the installation almost be succeeded.
Now, the system has already added a new roles “Network Policy and Access Services”.


(2).Configure and Enable Routing and Remote Access
When you expand the “Network Policy and Access Services” tree, the red arrow down icon express this function never be enabled.
To right-click it and select “Configure and Enable Routing and Remote Access” in menu,the setup wizard will show up.
Click “Next > “ button
Select “Custom configuration” option next to click “Next > “ button
Enable “LAN routing” check box next to click “Next > “ button
Click “Finish” and “Start service” button
Now the icon become green arrow up.


(3).Verify IPv4 setting
Right-click “Routing and Remote Access” next to select “Properties” in menu
You will see this computer pay a role as IPv4 Router now.


(4).View IPv4 Routing table
To expand "IPv4” tree and right-click “Static Routes” to select “Show IP Routing Table…”
The current IPv4 Routing information will show up

In the time, the computers in 10.10.101.x and in 10.11.101.x can communicate each other. Of course, the computer default gateway need to be set on the IP of Router interface.

Open firewall port for Computer join Domain & Account logon Domain

I want to understand which firewall port need to be opened if the computer will join and log on Domain. I use Microsoft Forefront Threat Management Gateway 2010 as firewall and assign two network segment for creating DC(VBHV-DC-01 in LAN3) and Workstation(VBHV-FS-01 in LAN4) role. And the network rules is route mode from LAN4 to LAN3.To create a new Access Rule from LAN4 to LAN3 and open the following protocols:
                              Microsoft CIFS/SMB: 445/TCP
                              Kerberos-Sec: 88/TCP, 88/UDP
                              DNS: 53/TCP, 53/UDP
                              LDAP: 389/TCP, 389/UDP
                              NetBIOS Datagram: 138/UDP
                              NetBIOS Name Service: 137/UDP
                              NetBIOS Session: 139/TCP
                              NTP: 123/UDP
                              RPC Endpoint Mapper(Custom): 135/TCP
                              ADLogon/DirRep(Custom): 50000/TCP
                              RPC Netlog(Custom): 50001/TCP
For limiting the special port for RPC to a single port(50000/TCP), we need to add a registry on each domain controller.
In “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTDS\Parameters\" registry key to new a DWORD (32-bit) Value
Rename the entry from “New Value #1” to “TCP/IP Port”
Double-Click this entry and select “Decimal” option –> enter “50000” in Value data field –> click “OK” button
After finish the above correct, please reboot DC so that the registry function will enable.
To force RPC port for client RPC traffic to a specific port, I need to do the same activity in “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Netlogon\Parameters\ ”
To new a DWORD (32-bit) Value type “REG_DWORD”, rename the entry from “New Value #1” to “DCTcpipPort” and name a Registry value “50001” next to reboot it
Now,I try to join Domain “dw.com” and the result is successful.
The computer can log on Domain “VBHV-DC-01”.
By TCPView Utility, you will see there is no any port limited now.

Computer cannot Log on AD by domain account

I don’t know when trust relationship has problem between DC and member server because I get a error message after keying in domain account.
Based on this error message, I search the related information by Google and try and error some method. Finally, the problem is resolved.

How to correct it?
Verify whether the value of servicePrincipleName of the computer exist or true!

Run ADSIEDIT.MSC and Right-Click the affected computer to select the property
In “Attribute Editor” tab, mark “servicePrincipalName” next to click “Edit” button
Add new value as “HOST/yourcomputername.yourdomainname” next to click “Add” button. (In our example, it is “HOST/vbhv-fs-01.dw.com”)
That is servicePrincipalName value = HOST/vbhv-fs-01.dw.com
Now I can log on in this workstation by domain account.

Install 64-bit Oracle Client on 64-bit Windows 7

Last time, I install 32-bit PowerPivot 2012 on 32-bit Windows 7 to replace PowerPivot 2010. When I open Excel 2010 and select PowerPivot item, the remind message show up and ask me whether want to upgrade the workbook.
Of course, you have to press “OK” button so that the PowerPivot workbook will be showed up. In the moment, I follow the previous activity to execute refresh worksheet for retrieving Oracle Data but the result fail.
In this Error Message, it give me a suggestion either upgrading to 64-bit version or increasing memory. I choose upgrading to 64-bit version because the original 32-bit environment before replace PowerPivot version is normal so that it will be not enough memory.

For 64-bit environment, I need to install 64-bit OS, Office 2010, PowerPivot and hotfix with up-to-date. When finish the related Microsoft Prerequisite, the Oracle Client need to be installed then.
Download “Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) from Oracle Website and extract “win64_11gR2_client” compressed file to the selected folder. The extracted path will be “\client” and its setup file is under this path.
Executing "setup.exe” to begin the installation process of Oracle Client.
In Select Installation Type,select “Administrator” option next to click “Next>” button
Click “Next> “ button if we don’t need to select another language.
Keep the default Oracle Base and Software Location next to click “Next> “ button
If no any problem in Perform Prerequisite Checks, click “Finish” button to begin to install Oracle Client Software now.
The installation of Oracle Client almost is successful if no any surprise.

In the moment, we need to add a “tnsnames.oRA” file under the installation path as “c:\app\davidwa_wang\product\11.2.0\client_1\network\admin\” for creating an entry in this file to allows the ODBC driver to establish network connections to an Oracle Database.
In this file content, need to define “Data Source Name”, "Host” (by FQDN or NETBIOS name or IP), “Port” (default = 1521) and “Service Name”
After saving this file and opening Excel 2010 to execute PowerPivot Data Refresh, its function will be normal now.

Install Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010

Microsoft PowerPivot for Excel is a exciting tool for analyzing data. It is very convenient for us to use in Excel because we almost don’t need to write any code for data analysis.
Since Microsoft Powerpivot for Microsoft Excel 2010 release, I have already used it in business work for a long time. Recently, I decide to change its version to 64-bit Microsoft SQL 2012 Powerpivot for Microsoft Excel 2010 because I get memory issue when run it. I think the 64-bit version can extend more memory than 32-bit one!

When I download “PowerPivot_for_Excel_amd64.msi” from this URL http://www.microsoft.com/en-us/download/details.aspx?id=29074 and execute it on Windows 7 64-bit version, I get a error message as follows:
I read PowerPivot Instructions and find out I forget to install “Visual Studio 2010 Tools for Office Runtime” in the moment.
So I download 64-bit version and install it next to update the last hotfix, I can install Microsoft SQL Server 2012 PowerPivot by Wizard now.
After installing PowerPivot next to open Excel program, I find out that PowerPivot item never show in menu.
I know need to do something to enable it.
Click “File” –>  "Options”, it will show up Excel Options window.
In Excel Options, click “Add-Ins” –> Select “COM Add-ins” in Manage menu –> Click “Go…” button and the COM Add-Ins window will show up.
In COM Add-Ins window, enable “PowerPivot for Excel” check box next to click “OK” button, the result is nothing happen --- that is “PowerPivot” item still disappear.
Why?
Because COM Add-Ins load behavior fail!
How to resolve this problem? Reinstall .Net Framework 4.0 again!
You can download .NET Framework 4 (Web Installer) or (Standalone Installer) from Microsoft Web Site.
After Installation is completed, don’t forget to check Windows Update again.
Redo the above process to enable “PowerPivot” check box, the load behavior is normal.
And PowerPivot item can be see now.
I think the key point is whether “Microsoft .NET Framework 4 Extended” exist.