Tonight, I’m trying to put together a few demos for my talk on Wed. As I’m working on it, I realized that one of my demos requires SQL Server and Northwind… I’ve faced this one before with SQL 2005, and thought I knew everything I needed to know. You might be scratching your head thinking “what the heck is he talking about.” I’m talking about how SQL 2005/2008 use a couple users that you might not be aware of. You find out about them when you go to attach an older DB like Northwind. What happens is that when you do the attach you get hit with an Access Denied error (which seems to make no sense at all). Eventually I realized that it was a file permission error (at least with SQL 2005). SQL 2008 is still giving me fits.. .I think I might just cheat and use SQL Express’ attachDB feature (but the whole ordeal really sucks and SQL Management Studio really could do a better job of telling you what might be the cause of the problem…
As a result I’m pretty tired from fighting SQL server for the last hour trying to get a demo that should have taken me 10 minutes to get going… I believe the word we often use in this context is “fail.”
BTW, if someone know what I’m missing please pipe in.. I only play a DBA “on stage…” The “A” stands for Administrator which is something I am not!
Print | posted on Saturday, March 07, 2009 12:00 AM