April 2007 - Posts

• Fix those SIDs!

  (I'm not sure why this isn't showing up under my blog, but I'm working on it!) Thanks to my good friend Jeremy McMahan for finding the suser_sid() function for me -- My original solution was a crazy mix of linked servers and the Directory Services provider for OLEDB! Ever migrate your SharePoint site to a totally new environment and discover that your efforts to re-create your Active Directory were all for nothing, since all the users got new SIDs?  Symptoms like: The administrator of the server can log in, but nobody else can, even though you're SURE their usernames and passwords are right. Here's a script that'll fix that up for you in a jif.  Open Query Analyzer and run it against the content database for your site, and it will update all the SIDs for your users to the SID that is reported for that user by Active Directory. Big fat disclaimer: Microsoft does NOT support ANY modifications to your SharePoint databases.  That's not to say they won't support your SharePoint site, but if this operation breaks your server, Microsoft won't help you.  I'm not responsible for the results, either, while we're on the subject of passing the buck.  BACK UP YOUR DATABASE. Okay, now that we've gotten that mumbo-jumbo out of the way, here's the code. DECLARE @login varchar(40), @systemid varbinary(128) DECLARE curUsers CURSOR LOCAL FOR SELECT tp_login, tp_systemid FROM userinfo where tp_deleted = 0 OPEN curUsers FETCH NEXT FROM curUsers INTO @login, @systemid WHILE @@FETCH_STATUS = 0 BEGIN PRINT 'Resetting user ' + @login + ' to new SID ' PRINT suser_sid(@login) UPDATE UserInfo SET tp_systemid = suser_sid(tp_login) WHERE CURRENT OF curUsers FETCH NEXT FROM curUsers INTO @login, @systemid END CLOSE curUsers DEALLOCATE curUsers GO Posted Apr 08 2007, 04:15 PM by Dustin Miller with 2 comment(s) Filed under: migration, active directory, database, sids, sharepoint

• Vote for Pedro! Er, I mean, me!

  Tech·Ed is coming!  One of the great things at this conference is a series of sessions called "Birds of a Feather".  These are not presentations, but more of an intimate round table focused on some topic of interest to attendees.  You can find sessions on accessibility in web design, MOSS publishing sites, Agile software development, and even non-technical discussions designed to encourage camaraderie with your fellow geeks.  In order for a session to land on the schedule, it needs votes!  You can visit the Birds of a Feather voting page now and cast your votes for Birds of a Feather sessions you think would make a great addition to the line up. I've submitted a session I'm calling "Geeks with ADD: It's an ADDvantage!".  Here's the abstract: During this BOF session, all attendees are welcome to join a discussion centered around AD/HD (attention deficit/hyperactivity disorder), also known as ADD. ADDers know that there are a lot of misconceptions about ADD, and we all face our own unique challenges with time and task management. Let's talk about how we can simplify our technological lives, and take ADDvantage of all the positives that ADD can give. Non-ADDers are welcome, you'll learn a lot about what ADD *really* means! Here's a hint: It doesn't mean that we can't pay attention! If you or someone you know and love has AD/HD or ADD (the terms are used interchangeably by some, though both acronyms are not really accurate!), or you just want to learn what being a geek with ADD is really all about, vote for this session!  Let's talk, and wipe away the common misconceptions about this "alternative brain wiring"!  You don't necessarily have to attend the session if you vote on it, but you can show your support for the topic by casting your vote anyway. See you in Orlando!   Posted Apr 04 2007, 03:20 AM by Dustin Miller with no comments

• Welcome to SharePoint Experts, Heather Solomon!

  Heather Solomon, the well-known SharePoint MVP and SharePoint design genius has recently joined the SharePoint Experts family.  She is continuing to expand her private SharePoint branding business, Solomon Creative (THE go-to company for your SharePoint branding needs), but has also joined forces with SharePoint Experts to create the first class devoted 100% to SharePoint branding! Yes, that's right.  Currently slated for 3Q 2007, SharePoint Experts will offer the SharePoint Branding Bootcamp, authored and delivered by Heather Solomon.  We're thrilled to have her on board!  Stay tuned to this blog (and, no doubt, her blog as well!) for more details on this class as it is written.  If you're interested in getting updates on the status of this class, or you want to be notified when we offer tickets for this great new training option, be sure to join the SharePoint Bootcamp training mailing list. It's going to be a great year, folks! And welcome aboard, Heather! Posted Apr 04 2007, 12:45 AM by Dustin Miller with 1 comment(s)