[There's a reason that Yoda is the unofficial mascot of SBS.  Size indeed matters not.] June 2008 - Posts - THE OFFICIAL BLOG OF THE SBS "DIVA"

June 2008 - Posts

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 Mon, Jun 30 2008 12:19 by bradley | 1 comment(s)
Filed under:

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.

Posted Mon, Jun 30 2008 12:11 by bradley | with no comments
Filed under:

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.

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 Sun, Jun 29 2008 15:00 by bradley | 3 comment(s)
Filed under:

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.

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

 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 Sat, Jun 28 2008 12:16 by bradley | 1 comment(s)
Filed under:

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.

Posted Sat, Jun 28 2008 11:34 by bradley | with no comments
Filed under:

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 Sat, Jun 28 2008 6:46 by bradley | with no comments
Filed under:

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 Fri, Jun 27 2008 19:05 by bradley | 2 comment(s)
Filed under:

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 Fri, Jun 27 2008 19:01 by bradley | with no comments
Filed under:

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

netsh int tcp set glo aut=dis

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

(P.S.  and when typing up a blog post late at night... make sure you copy and paste the right string)

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 Thu, Jun 26 2008 12:21 by bradley | 5 comment(s)
Filed under:

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 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.

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 Wed, Jun 25 2008 22:13 by bradley | 3 comment(s)
Filed under:

Testing out tonight a new URLScan beta 3

Information is here http://blogs.iis.net/nazim/archive/2008/06/05/using-the-new-rules-configuration-in-urlscan-v3-0-beta-part-1.aspx and http://blogs.iis.net/wadeh/archive/2008/06/05/urlscan-v3-0-beta-release.aspx and having to make a few tweaks to balance out making the blog site work with the URLScan feature enabled.

If you get to a page that doesn't work and should let me know.  As some of the rule sets have blocked legitmate folks from accessing content.

In the meantime looking at some of the items hitting the site is indeed interesting... this from the urlscan.log file just a few moments ago...

[06-21-2008 - 02:15:39] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:15:48] Client at 65.55.209.198: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:15:53] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:16:09] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:16:09] Client at 211.197.107.208: Rule 'SQL Injection' detected string ';' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/library/errorpages/smarterror.aspx'
[06-21-2008 - 02:16:11] Client at 211.197.107.208: Rule 'SQL Injection' detected string ';' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/errorpages/smarterror.aspx'
[06-21-2008 - 02:16:24] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:16:25] Client at 65.55.209.183: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/SearchResults.aspx'
[06-21-2008 - 02:16:50] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:16:54] Client at 195.75.146.228: QueryString contains sequence '%%3C', which is disallowed. Request will be rejected.  Site Instance='983214064', Raw URL='/search/SearchResults.aspx', QueryString='q=generic+viagra+online+%%0d%%0a+%%3ca+href%%3d%%22http%%3a%%2f%%2fwww.hackint0sh.org%%2fforum%%2fmember.php%%3fu%%3d67677%%22%%3egeneric+viagra%%3c%%2fa%%3e+%%0d%%0a+http%%3a%%2f%%2fwww.hackint0sh.org%%2fforum%%2fmember.php%%3fu%%3d67677+%%0d%%0a+%%5burl%%3dhttp%%3a%%2f%%2fwww.hackint0sh.org%%2fforum%%2fmember.php%%3fu%%3d67677%%5dgeneric+viagra%%5b%%2furl%%5d++%%0d%%0a+%%3ca+href%%3d%%22http%%3a%%2f%%2fwww.epinions.com%%2fuser-dr-lerman%%2fshow_%%7eView_Profile%%22%%3eorder+viagra%%3c%%2fa%%3e+%%0d%%0a+http%%3a%%2f%%2fwww.epinions.com%%2fuser-dr-lerman%%2fshow_%%7eView_Profile+%%0d%%0a+%%5burl%%3dhttp%%3a%%2f%%2fwww.epinions.com%%2fuser-dr-lerman%%2fshow_%%7eView_Profile%%5dorder+viagra%%5b%%2furl%%5d+&tag=General+Chatter&orTags=0&o=Relevance'
[06-21-2008 - 02:17:19] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/Searchrss.aspx'
[06-21-2008 - 02:17:20] Client at 74.6.8.100: Rule 'SQL Injection' detected string 'end' in the query string. Request will be rejected.  Site Instance='983214064', Raw URL='/search/SearchResults.aspx'
[06-21-2008 - 02:17:22] Client at 195.75.146.228: QueryString contains sequence '%%3C', which is disallowed. Request will be rejected.  Site Instance='983214064', Raw URL='/search/SearchResults.aspx', QueryString='q=generic+viagra+online+%%0d%%0a+%%3ca+href%%3d%%22http%%3a%%2f%%2fwww.hackint0sh.org%%2fforum%%2fmember.php%%3fu%%3d67677%%22%%3egeneric+viagra%%3c%%2fa%%3e+%%0d%%0a+http%%3a%%2f%%2fwww.hackint0sh.org%%2fforum%%2fmember.php%%3fu%%3d67677+%%0d%%0a+%%5burl%%3dhttp%%3a%%2f%%2fwww.hackint0sh.org%%2fforum%%2fmember.php%%3fu%%3d67677%%5dgeneric+viagra%%5b%%2furl%%5d++%%0d%%0a+%%3ca+href%%3d%%22http%%3a%%2f%%2fwww.epinions.com%%2fuser-dr-lerman%%2fshow_%%7eView_Profile%%22%%3eorder+viagra%%3c%%2fa%%3e+%%0d%%0a+http%%3a%%2f%%2fwww.epinions.com%%2fuser-dr-lerman%%2fshow_%%7eView_Profile+%%0d%%0a+%%5burl%%3dhttp%%3a%%2f%%2fwww.epinions.com%%2fuser-dr-lerman%%2fshow_%%7eView_Profile%%5dorder+viagra%%5b%%2furl%%5d+&tag=General+Chatter&orTags=0&o=Relevance'

Which brings to me to my theory and speculation at this point of what happened, so please treat this accordingly.  Whether this theory turns from the speculation that it is now to actual fact may or may not be able to be proven if the IIS log files are too much a needle in a hay stack, but putting on this URLscan 3.0 that has a rule set that specifically looks for SQL Injection attacks is part of the new changes on the blog.

I hesitate a bit to be this honest about the speculation I'm doing for a couple of reasons.  First... as someone in MSRC once said in a TechEd presentation, early information is usually wrong and very speculative.  So I hesitate to make any conclusions at this point, especially with the Security folks still looking at the raw data. 

So until they confirm (again assuming that there is log files enough on the box to be clear as to what happened, we may not find the smoking gun), based on the current threat levels, activity out there on other web sites, even if I think what may have happened, didn't happen, it's wise that we're putting this prevention in place.

Ergo why I'm putting a urlscan filter on the server that specifically looks for SQL injection attacks.

So here's the sequence of events that I think should not and cannot be overlooked. 

On June 4th, search broke.  I thought it very odd but when you are getting ready to upgrade, sometimes the wheels start falling off the car. (or so I reasoned with myself... Failure number 1, don't look at an upcoming upgrade and put it down to computers that realize their days are numbered [even though it seems like it and they start acting up]).

On June 5th, I went to the SQL database, ran a command to clear out the "isindexed" in the database and began a reindexing.  I then went on a quick trip (on behalf of WindowsSecrets.com) to Seattle and didn't pay attention to the growing size of the indexing that wasn't stopping.  (Failure 2 - The lack of attention to these early indicators are a key failure on my part and lesson learned).  On the night of the 6th, the blog outgrew it's D: drive and got stuck.  The server was hard rebooted to gain RDP access and I logged in to find a near full 400gig hard drive.  Quickly stopped the indexing and cleaned up[ the drive. 

When the box was rebooted, the tcp/ip service didn't start.  (Failure number 3 on my part to notice the failure and not realize that this wasn't a real service.)

To get the sbot/rbot on the system, the intruder gained access.  At this point in the security logs, there is no evidence at all that anyone gained access through RDP (there's an interesting story about that that will be in part two of my brain dump analysis).  So the $64,000 question that at this time I really can't answer with an absolute certainty is How did someone gain access and at this time I have to say "I don't know".  When they put sbot/rbot file on the box, that was a merely an effect, not a cause.

So I'll draw my line in the sand at speculation at right there but I will say that my obvious failure was lack of monitoring.   I wonder if I wasn't trying to travel, and do all the other stuff I was doing at the time that I would have paid more attention to what was going on.  This is/will definitely be remedied and increased accordingly.

But I'll tell you one thing.... I really think it would be wise to put this URLScan 3 on any public facing site you have out there.  It required some tweaking on this blog site, but so far it's making for some interesting log reading.  No matter what this turns out to be, there's enough nasty stuff that this is wise to do.

Next up in part two, hang on to your hats to see what fun can be had with a little RDP.

Posted Wed, Jun 25 2008 0:10 by bradley | with no comments
Filed under:

"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 Tue, Jun 24 2008 23:14 by bradley | 1 comment(s)
Filed under:
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

Posted Tue, Jun 24 2008 22:28 by bradley | with no comments
Filed under:

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 few 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....

More Posts Next page »