Thank you for attending the Makati TechNet Session on DirectAccess, slides and links are here

Thank you for attending! It was great having you guys at the event and as we said in the event we will be posting the links and resources that we used for the labs and the demo that we created. So here ya go:

DirectAccess Design Guide:
http://www.microsoft.com/downloadS/details.aspx?familyid=647222D1-A41E-4CDB-BA34-F057FBC7198F&displaylang=en

Step by Step Guide:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8D47ED5F-D217-4D84-B698-F39360D82FAC&displaylang=en

Next Generation Remote Access with DirectAccess and VPNs: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=70723e47-3d57-415b-9182-744ceaf8c04a#tm

Technical Overview of DirectAccess in Windows 7 and Windows Server 2008 R2:
http://www.microsoft.com/downloads/details.aspx?FamilyID=64966e88-1377-4d1a-be86-ab77014495f4&DisplayLang=en

Microsoft Server and Tools solution site for Direct Access:
http://www.microsoft.com/servers/directaccess.mspx

And the community links that were flashed in the session:

http://msforums.ph
http://msforums.ph/blogs/phiwug
http://phiwug.org
http://technetphilippines.net

I also uploaded my slides in my SkyDrive here: http://cid-73c3edf52f56c741.skydrive.live.com/browse.aspx/TechNet%20Sessions

Thanks and see ya all in our next events!

Makati TechNet Session: Windows Server 2008 R2 DirectAccess

 

Guys, thank you for attending another Makati TechNet session! DirectAcess is a cool (really coooool!) feature of Windows Server 2008 R2 and Windows 7 and me including members of the Philippine Windows Users Group were very exited to share and demo this in front of you. I will be posting later our promised links but for now, here are some pictures that were taken in the said event.

 

 

 

Before the event, getting ready the machines that we are going to use.

   

Many thanks to Faelmar Tañada for the always and usual support to a PHIWUG event so Bong, thanks alot!

The event was very exciting, specially having to demo the latest feature of Windows Server R2 the Direct Access.

 

“The Windows Server 2008 R2 and Windows 7 operating systems support a new feature called DirectAccess that enables seamless remote access to intranet resources. Unlike traditional virtual private networks (VPNs), which require user intervention to initiate a connection to an intranet, DirectAccess allows any application on the client computer to have complete access to intranet resources while allowing the IT administrator to specify which resources or even client-side applications that are restricted for remote access.”

        

The demo was done over a machine running hyper-v. This hosts 7 virtual machines for a minimum direct access setup.

Demo on Direct Access deployment, installing and configuring.

      

Congratulations to those who won the raffle! 😀

   

Wow, this is a nice windows 7 booth! Picture Picture!

Many thanks to the members of PHIUWG for their usual support and attendance during these kinds of events. Thanks also to Pauvi from MS phil for her support and special thanks also to Bong for his great help on this event and to Jeo (Jay-R Barios) for his technical and moral help 😀

The whole album is here on high res:

 

See ya all in another event! Oh yea See ya all in the Windows 7 Launch!

Deploying SQL 2008 Express with Advanced Services SP1 on Windows Server 2008 R2

 

I can’t seem install MS SQL Server 2008 Express with Advanced Services natively on a Windows Server 2008 R2. Why use it? Primary its free like the SQL Express and it has advanced features like of the full SQL Server 2008 as described here: http://msdn.microsoft.com/en-us/library/ms365248.aspx

Cant install, mainly because as of this moment I have not found a downloadable copy of the MS SQL 2008 Express with Advanced Services SP1 from the Microsoft Download site. To install SQL 2008 on Windows Server 2008 R2, it must be already on SP1. I think that the only way I can install this is to do a slipstreamed copy.

Slipstream is a way of infusing the installer and its update so that the installer may already have the update in it upon install. This is very handy for mass deployment and for situations like this where it is required to have an SP1 copy to install. http://en.wikipedia.org/wiki/Slipstream_(computing)

So here is how I did it:

1. Download the installers:

SQL 2008 Express with Advanced Services installer from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SQL Server 2008 Service Pack 1 (SP1) update from here : http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

2. Merge the installers.

First you must extract the files from the SQL Express installer with the “/x” switch. In my case I put it on the root of my C:\. So to do this open your CMD prompt and type in without quotes: “en_sql_server_2008_express_with_advanced_services_x64.exe /x:c:\SQLServer2008_FullSP1”. Hit enter.

So the syntax goes <INSTALLER> /x:<PATH-TO-EXTRACT-TO>

That command extracts the installer files to the c:\SQLServer2008_FullSP1 directory.

After extraction, a message box will appear prompting us that the extract is now complete.

 

Now we extract the update and put it in the PCU directory of c:\SQLServer2008_FullSP1

Same syntax, so opening CMD and typing in: SQLServer2008SP1-KB968369-x64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU. Hit enter.

It is the same thing for the updates, a prompt will appear after extraction.

 

Then we must copy the setup.exe and setup.rll from the child PCU directory to the root c:\SQLServer2008_FullSP1 directory. We can use robocopy for this:

so with the command prompt still open:

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe”

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll”

Then we must copy everything from c:\SQLServer2008_FullSP1\PCU\x64 directory to c:\SQLServer2008_FullSP1\x64 except the Microsoft.SQL.Chainer.PacakgeData.dll. To do that, simply use robocopy with this command:

“robocopy c:\SQLServer2008_FullSP1\PCU\x64 c:\SQLServer2008_FullSP1\x64 /XF Microsoft.SQL.Chainer.PacakgeData.dll”

Please see the results if it looks like this: Note that we skipped one and copied 71 files.

We have to create now the DefaultSetup.ini file in the c:\SQLServer2008_FullSP1\x64 directory.

To do this open up your favorite text editor, mine is notepad then save it as DefaultSetup.ini. Make sure that you choose all files before saving to create the .ini extension and not have a .ini.txt file.

The DefaultSetup.ini file must contain the ff:

 

 

3. Run Setup

After the last step above, run the setup.exe in the c:\SQLServer2008_FullSP1 like nothing happend 😀

There ya go, the setup is now running without that prompt that you need to be updated ….

4. Checking

Check if you are really installing 2008 Express with Advanced Services:

After running the install process you may find that you also passed the  Update setup media language compatibility

After the setup is complete you may review the summary log of the installation by clicking the link highlighted in yellow as seen here:

 

Scroll down to the text file in notepad and look for the PCUSOURCE entry under User Input Settings.

The value must be our PCU directory under c:\SQLServer2008_FullSP1\. This verifies that our installer is already at SP1

 

There you have it, a slipstreamed install of SQL 2008 with Advanced Services SP1 ready for deployment.

RECAP: Here is the short story of the list of things and commands that we did:

 

Download the FF and copy to C:\ directory for easy access.

SQL 2008 Express with Advanced Services  http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SQL Server 2008 Service Pack 1 (SP1) : http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

Extract and merge the Installer with SP1 (with command prompt)

en_sql_server_2008_express_with_advanced_services_x64.exe /x:c:\SQLServer2008_FullSP1

SQLServer2008SP1-KB968369-x64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe”

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll”

“robocopy c:\SQLServer2008_FullSP1\PCU\x64 c:\SQLServer2008_FullSP1\x64 /XF Microsoft.SQL.Chainer.PacakgeData.dll”

Create DefaultSetup.ini file at c:\SQLServer2008_FullSP1\x64.

; SQLSERVER2008 Configuration File

[SQLSERVER2008]

PCUSOURCE=”C:\SQLServer2008_FullSP1\PCU”

 

Run Setup.exe from C:\SQLServer2008_FullSP1\

That’s it!

Have you seen the TechNet Flash Philippines September 2009 Issue?

Just got another newsletter email from TechNet Flash and upon reading to the bottom guess what I found at the Blog post of the Month:

It’s our previous blog post for a how to on Connecting to multiple remote desktops from a single MMC console and improve your productivity.

TechNet flash for this month also includes the usual topics on certifications, webcasts and how-to’s. To receive this monthly newsletter, you can register in this link 😀

Meet up with new PHIWUG officers @ Bubba Gump, Greenbelt 3

The new set of officers of Philippine Windows Users Group and the guys from Microsoft  Philippines met at Bubba Gump last September 04, 2009 for some chips, drinks, Windows topics and some planning for this year.

(From Left) There’s Ralph, Liezl, Pauvi from Microsoft. On the right, its (me) John, Bong (Faelmar), Jeo, Chris and our webmaster Felix.

  

Thanks guys for inviting me on our meet up. This will be one exciting year! Thanks Guys and See ya at all of our events!