June 2008 - Posts

So what's TMG anyway?

Download details: Forefront™ codename "Stirling":
http://www.microsoft.com/downloads/details.aspx?FamilyID=65bd5f8a-d94c-457a-9f88-2046597130e1&DisplayLang=en

So if you want to see what TMG is all about..check out that beta (there's a Virtual one as well)

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

The Official SBS Blog : Software Assurance entitlement for SBS 2003 customers upgrading to SBS 2008:

The Official SBS Blog : Software Assurance entitlement for SBS 2003 customers upgrading to SBS 2008:
http://blogs.technet.com/sbs/archive/2008/06/30/software-assurance-entitlement-for-sbs-2003-customers-upgrading-to-sbs-2008.aspx

If you have any clients on Software Assurance... or you just sold them on Software assurance... or were thinking of selling them on Software Assurance.... you just might want to take a look at that blog post.

Junction Points and Access Denied

Man I hate it when I am looking for a document and can't find it, and I know I blogged about it.  It had to do with the changed folder locations in Vista and it made be go "oh, that's why users is where it is and why I get an access denied when I click on My documents".  But this will still give you an idea of what's going on.

This document on MSDN is a great grid of the changes in junction points that you might want to print out and take a look at your Vista workstation or Server 2008.

AC: Junction Points and Backup Applications:
http://msdn.microsoft.com/en-us/library/bb756982.aspx

One of the things I hear a lot from folks about Vista is that they can't find where things are or when they click on "my documents" they get an access denied even though they are an "Administrator".

Security: New ACLs Improve Security in Windows Vista:
http://technet.microsoft.com/en-us/magazine/cc138011(TechNet.10).aspx

The reason for that is there in that document.. the junction points are just placeholders and there's actually a deny in there.

Anytime you see a shortcut icon in the main root that's not a real directory at all but a means to 'trick' the sucky app vendors that still need time to move to Vista

Vista IE7 Cache & Cookies Folder, Temp Directory and History Location » My Digital Life:
http://www.mydigitallife.info/2007/05/26/vista-ie7-cache-cookies-folder-temp-directory-and-history-location/

Another great document that showcases what things have moved where.

If you edit the file properties to allow you to see hidden file locations, then you can see where "my docs" and all the other stuff really is at.

Once you do that, then you can see where cookies and other files end up.  First browse to Users, <profile name> and you can see the true Documents folder under there.  See that "My documents" with a shortcut?  Again, that's just a stub location. 

If you click on it, you'll get an access denied. 

And that is  EXACTLY what is expected because there's a deny there to ensure that it stays in place because the app vendors also expect it there.

 

And those three locations are based on the "risk" of where the data comes in from.  Roaming is where most of the main folders will end up.

But next time you get an "access denied" think of what is really going on under the hood in Vista.

Error 0x80070057 returned from call to Adding routers IP address

So Kevin hit an issue where he ran the CEICW on a brand new SBS 2003 computer and hit this:

http://groups.google.com/group/microsoft.public.windows.server.sbs/browse_thread/thread/ed5a595e5c3fd88c/50b71975e02617db?lnk=st&q=Error+0x80070057+returned+from+call+to+Adding+routers+IP+address+to+the+intranet+zone().#50b71975e02617db

Error 0x80070057 returned from call to Adding routers IP address to
the intranet zone().

So how did he fix this?  Two things.

He imported the registry key from a working computer

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings\ZoneMap

And then turned off Enhanced IE and bingo.. the CEICW wizard worked.

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

About that data portability

http://www.nytimes.com/2008/06/29/technology/29digi.html

So here's the reality.  Today we're running Community Server 2008 sp1 and the data is built and stored in SQL 2005.  As a result of this migration we've lost some attachments, images, and for the decorator in me, blog skins that work.  Not the greatest migration that I would have hoped for.  So I look around at other blogging platforms and the options I have to move the data, I realize that I'm not sure where to turn.  The content is in SQL 2005.  Wordpress and Typepad run in MySQL.  Quite frankly, unless things change, I'm not sure I have the braincells left to handle another database engine, especially one that I'd only use for the blogging platform.

So the article above that urges Microsoft to make a break with the past showcases to me how much the pundits don't understand that when it comes to data and business, one does not rip out and replace lightly.  It's the reason entire firms are not ripping out XP and migrating to Vista.  It's the reason firms are still on Office 2003.  One does not migrate lightly.  One HAS to ensure that once they get on migrated platform that the business is not adversely impact.

If this blog site was a true business and my "business" was impacted to the degree this migration impacted this platform I'd be concerned about the productivity and efficiency impact of my firm. 

Bottom line, migrations suck.  Upgrades are never without risk.  And for all that we'd love to rip out and start over, get real.  Real world doesn't work like that.  Once cannot rip out without major impact.

Slipstream XP sp3 and RWW Active X issues solved

A huge thank you for this follow up to an issue that impacted Remote Web Workplace.

The issue was that as you built a XP sp3 with IE7 slipstream install that you could not enable the Terminal Server Redistributable (Active X control) that RWW needs to function.  If you install XP sp3 it gets disabled as well, but with slip install you were sitting there stuck and couldn't figure out how to get it back enabled.

SBS 2003 RWW problem - TechNet Forums:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3427893&SiteID=17

XP SP3 Upgrades & Slipstream Install Issues with SBS RWW « Ramblings on IT:
http://blogit.dslee.org/2008/06/28/xp-sp3-upgrades-slipstream-install-issues-with-sbs-rww/

Thanks Dave for this info.

After you build your slipstream and deploy it.. "reset" IE 7 otherwise you'll get stuck getting into RWW and you can't "enable" the TS control because it's greyed out.

That's on Vista but the concept is the same.. Click reset

One more upgrade folks to CS 2008 sp1

 Community Server 2008, Service Pack 1 Now Available! : Community Server:
http://communityserver.com/news/team-blog/community-server-2008-service-pack-1-now-available/

One more bump up that hopefully this blonde can handle now that we're over the hardest hurdle.  Just announced yesterday.  At least I have great timing!

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

Wanted: SQL server savvy person to translate help files for blonde non SQL Savvy person.

Not sure if this is just getting too old to learn, too in over my head or what but for all of those folks that joke about how newbies or whatevers that need images and step by step instructions, sometimes get out of your comfort zone, go to something way over your head and read the instructions you end up going "Huh?"

I want do modify a stored procedure and the info says ...

http://msdn.microsoft.com/en-us/library/ms345356.aspx

Expand Stored Procedures, right-click the procedure to modify, and then click Design.

Sounds reasonably easy enough.

Expand Stored Procedures

Okay I did that.

right-click the procedure to modify

Check, so far so good.

and then click Design

...and this is located.... where?

 

Looks like I'm in query mode?  Do you mean Design query in Editor?  Is that really where you want me to be?

Why is it when one reads instructions it sounds reasonable and yet when one gets to the actual product you sit there for 30 minutes scratching your head, googling, and going ... is this really what I'm supposed to be doing?

Wanted:  SQL server savvy person to translate help files for blonde non SQL Savvy person.
Inquire via the blog contact box.
Will pay by paypal.

The Blonde fixed it.  Yes you hit on "Design Query in Editor" and plunk down your new code and then you click on "Execute".  Well it worked anyway as this post is now showing up on the main feed.

For those of you who missed the headlines...

Hyper-V RTM'd yesterday.

Now keep in mind that because officially SBS 2008 has not RTM'd, if you go to look for specific supportability statements, they "ain't" gonna be there.  Why?  Because SBS 2008 is not released.  Microsoft traditionally does not post support info about a beta product in a released product.  Ergo that's why when IE8 got a security patch the other day, the official Security bulletin doesn't list IE8 as an impacted product.

The support story will indeed be there in time for RTM.

Right now the key thing you need to remember is that "legacy nic" is the setting that works on SBS 2008 rtm.

Hyper-V RTM Packages

Windows Server 2008 x64 Hyper-V Parent Partition

This is the complete Hyper-V RTM package for Windows Server 2008 x64. This package must be installed on the Hyper-V Parent Partition. It includes the Hyper-V Server components for Full and Core installations. In addition, is contains the Windows Server 2008 Hyper-V Management components for Full installations. Note This package is permanent.  Once installed, it cannot be uninstalled.
http://www.microsoft.com/downloads/details.aspx?FamilyId=F3AB3D4B-63C8-4424-A738-BADED34D24ED 

Hyper-V Management

This is the Windows Vista SP1 x64 Management package. This package provides the management tools for Windows Vista SP1 x64.
http://www.microsoft.com/downloads/details.aspx?FamilyId=88208468-0AD6-47DE-8580-085CBA42C0C2 

This is the Windows Vista SP1 x86 Management package. This package provides the management tools for Windows Vista SP1 x86.
http://www.microsoft.com/downloads/details.aspx?FamilyId=BF909242-2125-4D06-A968-C8A3D75FF2AA 

This is the Windows Server 2008 x86 Management package. This package provides the management tools for Windows Server 2008 x86Note This package is permanent.  Once installed, it cannot be uninstalled. 
http://www.microsoft.com/downloads/details.aspx?FamilyId=6F69D661-5B91-4E5E-A6C0-210E629E1C42
 

--------------------------------------------------------------

UPGRADE CONSIDERATIONS

--------------------------------------------------------------

Windows Server 2008 Hyper-V RTM Upgrade Considerations (from RC0, RC1 Escrow, RC1, RTM Escrow)

If upgrading from Hyper-V RC0, RC1 Escrow, RC1 or RTM Escrow, you will not need to recreate your virtual machines or network settings.  All virtual machine information will simply persist once the upgrade is complete. However, the following upgrade considerations need to be followed to ensure a successful upgrade to Hyper-V RTM.

Saved-state files are not supported during the upgrade. 
All virtual machine saved-states should be discarded before upgrading to Hyper-V RTM (or prior to resuming virtual machines after upgrading to Hyper-V RTM).
Online snapshots contain virtual machine save-states and thus online snapshots are not supported when upgrading to Hyper-V RTM.
Either apply any online snapshots and shut down the VM or discard the virtual machine save-state associated with the snapshot before or after the update to Hyper-V RTM. 

New Integration Components (ICs) must be installed for your supported guest operating systems.
Integration Components are specific to the build of Hyper-V.
Hyper-V RTM Integration Components for all supported Windows Operating Systems are provided using the ‘Action’ à ‘Insert Integration Services Setup Disk’ action.

Hyper-V RTM Integration Components for ALL supported Windows Operating Systems are now part of the IC Setup Disk. This includes all of the new guest support being added at RTM such as Windows XP (x86), XP (x64), Vista (x64), Windows 2000 Server and Windows 2000 Advanced Server. Simply install the Hyper-V RTM Integration Components and you’re set. (‘Action’ à ‘Insert Integration Services Setup Disk’).

Note You need to close the found new hardware wizard before setup will begin on all Windows Operating Systems. 
 

Hyper-V Question of the Day: 
Q: My customer is looking for information about Hyper-V. Do we have any good public links?
A: Yes and a lot more on the way... Here are just a few website, blogs and webcasts. 

Websites
Microsoft Virtualization Home Page
http://www.microsoft.com/virtualization/default.mspx

Virtualization Case Studies
http://www.microsoft.com/virtualization/case-studies.mspx 

Virtualization Solution Accelerators
http://technet.microsoft.com/en-us/solutionaccelerators/cc197910.aspx

Windows Server 2008 Virtualization & Consolidation:
http://www.microsoft.com/windowsserver2008/en/us/virtualization-consolidation.aspx 

Hyper-V FAQ
http://www.microsoft.com/windowsserver2008/en/us/hyperv-faq.aspx 

Optimized Desktop Infrastructure (VDI and much more):
http://www.microsoft.com/windows/products/windowsvista/enterprise/default.mspx 

Virtualization TechCenter:
http://technet.microsoft.com/en-us/virtualization/default.aspx 

How to Install Windows Server 2008 Hyper-V RC
http://www.microsoft.com/windowsserver2008/en/us/hyperv-install.aspx 

Windows Server 2008 Hyper-V Performance Tuning Guide
http://www.microsoft.com/whdc/system/sysperf/Perf_tun_srv.mspx 

MSDN & TechNet Powered by Hyper-V
http://blogs.technet.com/virtualization/archive/2008/05/20/msdn-and-technet-powered-by-hyper-v.aspx 

MSDN & TechNet Powered by Hyper-V Whitepaper
http://download.microsoft.com/download/6/C/5/6C559B56-8556-4097-8C81-2D4E762CD48E/MSCOM_Virtualizes_MSDN_TechNet_on_Hyper-V.docx 

Blogs:
http://blogs.technet.com/virtualization/default.aspx
http://blogs.msdn.com/virtual_pc_guy/
http://blogs.technet.com/jhoward/
http://blogs.technet.com/roblarson/
http://blogs.technet.com/virtualworld/
http://blogs.technet.com/windowsserver/
http://blogs.technet.com/mapblog/
http://blogs.technet.com/stbnewsbytes/ 

Webcasts:
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032368894&CountryCode=US
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032372420&CountryCode=US 
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

Yoda says "We'll be offline for a planned maintenance to get ready for the upgrade to CS 2008."

Blogs will be offline from 10 p.m pacific - Yoda's Blog:
http://msmvps.com/blogs/yoda/archive/2008/06/28/blogs-will-be-offline-from-10-p-m-pacific.aspx

Yoda says... "We'll be offline for a planned maintenance to get ready for the upgrade to CS 2008."

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

Pardon the mess

Not all blog posts on blogs page - Community Server:
http://dev.communityserver.com/forums/p/498790/620234.aspx#620234

Pardon the construction zone around here..in making sure everything is working post upgrade to CS 2008 like it should I realized the main MSMVPS.com feed page is not updating.  In looking on the Community Server site that's the fix I found.  The blog site is up on CS 2008 now and we're working through a few issues.

Kudos for the folks from www.4-roads.com who did the heavy lifting.  There comes a time when working on technology projects that doing everything yourself is possibly not good for the project, or for you.  When that time comes, the best thing an IT person can do is realize that they've gotten to that point and outsource appropriately.  Fortunately for me www.4-roads.com offer term service and they do this really cool agreement process where they send an agreement and it's "e-signed". 

Whenever working with SQL I am vastly overwhelmed, so it's always nice to know a firm to call upon and go "can you handle this?"

Needless to say when they get to stuff like "Be sure to at least back up the original assembly and the original procedures in your database."... I'm like... oh William... it's that SQL stuff that freaks me out. 

But the recent SQL injection stuff and even this blog server points out the fact that many/all of us have this powerful database right under our noses and have no idea how to do the basics with it.

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

netsh int tcp set glo aut=nor to you too!

It seems like when I reload Vista (in this case rebuilding for a hard drive failure) I have to dig out this post to disble the auto tuning as I'm behind a funky router that doesn't quite work as it should.

Tonight I was trying to get to www.sierrawireless.com to get the software for the wireless aircard and the web site wouldn't resolve... but would ping just fine.

http://blogs.technet.com/steriley/archive/2006/11/21/windows-vista-vs-hotels.aspx

netsh int tcp set glo aut=nor

to be exact is the command that needs to be done.. and all is well.

About those Server icons

Administrative Logon in SBS 2008 or any Windows Server 2008:
http://www.sbstraining.net/post/2008/06/Administrative-Logon-in-SBS-2008-or-any-Windows-Server-2008.aspx

I complained about this very thing...

What no girl administrators out there?

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

EXCEL.EXE is not a valid Win32 application

Vista SP1 now even more reliable! - Nick Whittome - The Naked MVP:
http://msmvps.com/blogs/thenakedmvp/archive/2008/06/26/vista-sp1-now-even-more-reliable.aspx

What caught my eye.... 

This update improves the reliability of Windows Vista SP1-based computers that experience issues in which large applications cannot run after the computer is turned on for extended periods of time. For example, when you try to start Excel 2007 after the computer is turned on for extended periods of time, a user may receive an error message that resembles the following:
EXCEL.EXE is not a valid Win32 application



A reliability and performance update is available for Windows Vista SP1-based computers:
http://support.microsoft.com/?kbid=952709

Man I've seen that on my Home PC but not at the one at the office

I gave up torturing my Sister

I finally gave in.  I wanted to see how long JohnQPublic (aka my Sister) would have to wait on their Dell OEM laptop before being offered Service pack 1.  Tonight when the SigmaTel audio driver kept flipping to the codec that wouldn't work, I said forget this.  I'm manually installing Vista SP1.  So far every OEM HP and Dell laptop I've touched (okay so that's not thousands and thousands, but certainly a fair amount of friend, families, and personal machines) that have been OEM laptops, none of them have been offered up Vista sp1 through Microsoft Update.  Every single one of them I finally said "Oh forget this" and installed the Vista SP1 from the manual download site.  At which time once the Service Pack was fully installed, all the drivers were just fine.

So it begs the question, how many HP and Dell laptops are like my sister, never being offered Vista SP1?  And how many never will get Vista SP1 because Dell and HP are lame and Microsoft not helping the situation either.

Installed Vista SP1 manually, no runs, no drips no errors, and sound is working.

New hard drive, same 'ol laptop

Well here I am finding the necessary drivers for my rebuilt/new hard drive Acer Travelmate C110 that I love.  If you remember the hard drive in it did the lovely click click click of death.  So here I am setting my baby laptop back up and one thing you have to dig up from somewhere is the special button program that ensures you don't crash a plane and interfere with their navigational system because the wireless stays on otherwise.

The trick (if I remember it right from the last time I did this) was to find the Vista button launch manager program from a different Acer product and use it/edit the buttons to control the wireless button.

http://support.acer-euro.com/drivers/notebook/tm_c310.html

It's telling me I have to reboot to see if I did this right..

Oh yeah, that's the right one.... Good I won't be responsible for crashing a plane..

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

Why isn't SBS available as a hosted service

"Why isn't SBS available as a hosted service? It goes on and on."

http://windowsitpro.com/mobile/pda/Article.cfm?ArticleID=99554&DepartmentID=723

Paul.. SBS is available as a hosted platform now.  Granted I think it makes more sense when you host the desktops as well as the server, because otherwise you just have SharePoint and Exchange.. but vendors are hosting SBS now.  Sometimes I'm not sure Microsoft has to do EVERYTHING.. you know what I mean?

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:

URLScan 3.0

Windows Server Division WebLog : UrlScan 3.0 Beta and Tools to Help Mitigate SQL Injection Attacks:
http://blogs.technet.com/windowsserver/archive/2008/06/24/new-guidance-and-tools-to-help-mitigate-sql-injection-attacks.aspx

Running on this very server is URLScan 3.0.

..should it be run on a SBS 2003 box?  Hmm....not ready to come out and say yes as I haven't tested it yet.  And you have to watch and if needed edit the SQL strings.. I've had to remove create, select, and delete from the string filters.  Try to leave in "exec" and "/*" as those are key filters.

But try it on a test box, see if everything works... add the SQL injection string to the ini file.  If a page gets blocked, then edit out the string by going into urlscan.ini and editing it.

 [SQL Injection Strings]
--
%3b        ; a semicolon
/*
@          ; also catches @@
char       ; also catches nchar and varchar
alter
begin
cast
cursor
declare
drop
end
exec       ; also

So how did they break in?

Here's my "theory".  I put it in quotes as there's some parts of the puzzle I'm missing because of not large enough log files..but I'm pretty sure based on what I've seen to come to this conclusion.

So where did I go wrong?

By assuming that my biggest target of the blog/web was where the attacks would come in from.  Thus I spent most of my energy ensuring that passwords were proper, that the Microsoft software was patched.

And that's not where they got me.

But where I went wrong was making and taking a risk assumption.  And before I detail out that risk I took, it reminds me of this morning on CaliforniaEdition.org where the folks in Lake Tahoe that got their houses destroyed in the Angora fire, many of them ensured they got building permits before December of 2007 so that they wouldn't have to be impacted by the new fire building codes.  They wanted to have the flexibility in their budgets to make risk decisions even though they personally know what the risks are.  Yet they choose to accept the risk of the older, vulnerable building code rather than the newer, stricter code.

Humans have a natural condition to not thing the worst but think the best.  I'm guilty of that as well.  The glass is half full, not half empty.  As such there are times we don't make the right risk decisions.  The human condition that "I'm not big enough"... or "it won't happen again".  I took a chance based on the needs of a certain application to leave on the system vulnerable code.  I had to for management and adminstrative reasons.  But where I failed was not making and taking remedial actions to counter that risk.  I made the decision because I didn't think that I the risk I was taking was big enough.

In that sense I was no better than the folks running the Death Star...you see behind this blog server was a weakness.  My decisons were made regarding a piece of software running some listserves that are housed on this server.

There was a known weakness in my defense system. 

IceWarp Web Mail Multiple Vulnerabilities - Advisories - Secunia:
http://secunia.com/advisories/17046/

I knew about it.  But had to be on this older version because when Merak first came out with the new version they broke a key funcationality of the way the listserves that are administered.  There's a confirmation means that can be done via email and when they came out with the updated version, it broke this.  And they didn't come out with a new version for a long time.  Then, everytime I went online to check to see if they had a new version, I failed to see that they already had 9.1 out which fixed it.  So I stayed back on an older vulnerable version because at first it wasn't fixed, and then when it was, I didn't realize that the issue I had with the funcationality finally had been fixed.

Where I failed ..was that I should have taken remedial action.

I should have at least gone into the firewall and ensured that the Webadmin port for Merak was limited to those listserve admins (not only myself but others) had access.  You can do this with any firewall including the build in one on any server.  If I would have merely done that, the hack would not have been able to be accomplished.  I also failed because I didn't enable Merak to keep logs for that particular access long enough and I'm not sure I can tell exactly who got in.

So how did I determine this?  As part of the analysis done by Microsoft support, there a script that runs that grabs the date and time of every file on the system. 

 In looking at that report I noticed that the folder that dropped the netsrv.exe service (the funky netbios service that was the entry point) was as follows:

 Directory of c:\Program Files

06/06/2008  05:40a      <DIR>          networ~1        networking

If anyone knows me, they know that there's no way I'm up at 3:40 in the morning unless I'm up to get on a plane.  So that wasn't me for obvious reasons, let alone the fact that from the prior visual image of the netsrv.exe service was pointing to that location that appeared to be the entry date/time/point.

So in looking more down this file report I spotted the following:

 Directory of c:\Program Files\Merak\html\admin\wizards\data\domain

08/03/2007  07:55p      <DIR>                          ..
08/03/2007  07:55p      <DIR>                          _inc
08/03/2007  07:55p      <DIR>                          .
08/03/2007  07:55p      <DIR>                          _xml
05/27/2008  03:22p                 292 wizard~1.php    wizard.domain.php
06/06/2008  05:39a               2,462                 config.php  <<<<<<<

Bingo.  That folder is the Webadmin location for the web access to the listserves.  And a minute before the config.php file was accessed.

Still going down the file listing I see this....

 06/06/2008  05:40a           1,558,528 wmupda~1.exe    wmupdatesrv.exe  <<<


06/06/2008  05:40a             152,734                 auto.exe
06/06/2008  05:40a               4,096                 cll.exe
06/06/2008  05:40a              45,171 backdo~1.exe    backdoorinstall.exe
06/06/2008  05:40a               6,656                 bw.exe
06/06/2008  05:40a              39,936                 filedate.exe
06/06/2008  05:40a              25,600                 inx.exe
06/06/2008  05:40a              24,064                 openp.exe
06/06/2008  05:40a              45,056                 psinfo.exe
06/06/2008  05:40a             171,008                 pd.exe
06/06/2008  05:40a                 591                 sec.cmd
06/06/2008  05:40a              30,208                 rgv.exe
06/06/2008  05:40a              28,160                 tcp.dll
06/06/2008  05:40a              40,448                 uptime.exe
06/06/2008  05:40a                 581                 bw.log

Dumping a backdoor, media sharing and sysinternal tools to get information off the drive.  Psinfo.exe is a system info tool.

06/06/2008  05:41a      <DIR>          drwats~1        dr watson
               0 File(s)              0 bytes

 Directory of c:\WINDOWS\system32\config\systemprofile\Local Settings\Application Data\Microsoft\Dr Watson

06/06/2008  05:41a      <DIR>                          ..
06/06/2008  05:41a      <DIR>                          .
06/06/2008  05:41a             263,364                 drwtsn32.log
06/06/2008  05:41a              54,483                 user.dmp
               2 File(s)        317,847 bytes

Looks like they bluescreen the box, or forced a user.dmp file.

(By the way for all of the blog authors who got a bit upset that the blog server was down for 4 days, this was the reason why... I wanted to ensure that there was every opportunity available for an investigation into the how this happened.  This is why I delayed in getting the server back online.  The important thing was to understand HOW, because if we don't understand how we run the risk of setting the server right back up in a flawed manner)

Lessons to be learned...

1.  Don't assume that a little crack in your armor won't be the very thing someone targets.

2.  They aren't going after Microsoft software as we're getting pretty good at patching that.

3.  When you make the decision to run older software, review and take mitigations to protect yourself from the vulnerabilities it now brings.

4.  If you don't take the time to learn, and instead rebuild the system as is, you just may set the box back up with the same vulnerabilities. 

5.  Review your options for getting an image of the vulnerable system. 

I can't go into details but lets just say that you have to ensure that the OS license you have allows to grab an image, or get a little creative.  I didn't need an image of the server for bare metal restoration, I just needed to grab an image in case we didn't get a log file off the box.  Thus I used a free image tool to grab a backup that I could later mount and view  http://www.runtime.org/driveimage-xml.htm   In addition, I had to keep the box up long enough to grab the needed log files and review tools for Microsoft.  To ensure that no additional damage to the database was done, I shut off the web site and closed down access between the two servers.  The actual time to image the system after I got and overnighted a hard drive (in lovely bright yellow I might add), to then flatten and rebuild the server only took several hours.   If you have an event, you cannot "clean the system back up again".  You have to be prepared to flatten and rebuild.  But before you do that, keep a copy.  If this had been a real physical box in my office I would have yanked the harddrives and saved them.  In this case I couldn't, but came up with an alternative.

To paraphrase a comment on this blog...

http://weblogs.asp.net/steveschofield/archive/2008/06/23/sql-injection-information-for-iis-admins-and-developers.aspx

Hi Steven,

In theory, once you plug a box on the internet, it's not secure, no matter what you do.  All you can do is do the best you can and follow best security practices.  Validating request variables and not trusting user input is probably the one thing that will help the most.  It might cause some issues with your application, but if it's done with security in mind, it should be sufficient of a reason.

Good luck,

Steve

In theory, once you plug a box on the Internet, it's not secure, no matter what you do.  All you can do is the best you can and follow best security practices.  If you make a risk decision to accept the risk of vulnerable software, ensure that you counter that risk with a corresponding action to best limit that risk.  Don't assume for one moment that your little flaw in the exhaust port is too small in our case to have some Bad guy crack into it.  For every risk you take, stand back and make sure that it's an appropriate decision.

And may the force (the good force) be with you....

Win a free trip to SMBNation



Calyptix Security

 

 If you find yourself downing multiple shots of espresso to stay awake for those late night tech support issues, Seattle may be beckoning you.  Not only can Seattle claim to be the birthplace of the coffee revolution, it also boasts an organization known as SMB Nation.  Their conferences draw the best in the IT world for three days of professional workshops and peer networking.  This year's 6th annual SMB Conference promises to be the best in SMB Nation history . . . and Calyptix would like to help get you there.

Win a FREE SMB Nation 6th Annual Fall Conference Registration ($999 value)!
Register here today for a chance to win courtesy of Calyptix.   Drawings to be held periodically until August 25

Join your peers and enjoy an incredible learning environment for techincal & business insights to take your business and skill set to the next level.  Hear from industry thought leaders and your peers on critical issues, new products and future trends.  

Seattle is rich with adventure.  While you may be happy slurping an iced coffee at the original Starbuck's cafe, you may also choose to

  • Watch the fish tossin' at Pike Place Fish market.
  • Discover if food tastes better while revolving at 500 feet on top of the Space Needle.
  • View Seattle from a different angle . . . at the top of Mt. Rainier.
  • OR . . . simply gather insight on how to grow your business with Microsoft's Small or Essential Business Server 2008 AND Calyptix Security's AccessEnforcer (this last option comes highly recommended).

Whether you favor coffee, seafood or volcanoes, don't forget to register to win!

 

SMB Nation Fall 2008  (Event Details)
Saturday, October 4, 2008 - Monday, October 6, 2008
Bell Harbor International Conference Center
Pier 66
2211 Alaskan Way
Seattle, WA  98121-1604
United States

find out more: www.calyptix.com

 

I have a better reason to go... meet up with Ben, Lawrence and the rest of the great team from Calyptix.  Truly a great bunch of folks.

Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
More Posts Next page »