LP on .NET

May 28, 2009

Domain Account Login Problem on Virtual PC

Filed under: Microsoft,technology — Larry Parker @ 3:45 pm

I just tried logging into a virtual PC of mine (Microsoft Virtual PC 2007) using my domain account at my company and got the following error:


My domain account worked before, so something must have changed but I couldn’t figure out what.

A quick Google search turned up this article which describes the same problem I was having, including the solution.

Turns out that you just need to take the virtual pc off the domain and then rejoin.  Now I’m in business!

But you still need a way to log into the virtual pc with administrator rights, so it’s important to have a local account for that.

Hope this helps.


May 27, 2009

LINQPad Graphs

Filed under: .NET,LINQ — Larry Parker @ 1:22 pm

If you’re a LINQ user and haven’t already downloaded LINQPad, get it here.  It’s free, although I highly recommend purchasing a license (for a nominal fee) to get auto-completion support.  I really could have used that feature a couple of years ago when it first came out when I was learning LINQ (but I still find it useful now).

So here’s a nice feature in one of the recent LINQPad releases – LINQPad graphs.  After executing your query, if you click the ≡ symbol on the column header, you will get a nice horizontal bar graph of your data.

I’m actually using this for a quick-and-dirty dashboard to monitor packet load on a web server:


Pretty cool!

Installing BIDS after SQL Server 2005 SP2

Filed under: .NET,SQL Server — Larry Parker @ 10:27 am

Last Fall I set up a new machine with my usual development tools, but I forgot to install SQL Server 2005’s Business Intelligence Development Studio (BIDS) on top of Visual Studio 2005.  I had since moved on to other projects using Visual Studio 2008 that were keeping me plenty busy.

Yesterday, I needed to revisit an older project that used SQL Server 2005 Reporting Services and Analysis Services.  I opened up my solution in VS 2005 but got an error that it didn’t recognize the project.  This made sense because I never installed BIDS.

So I broke out my SQL Server 2005 CD’s and tried to install it.  Unfortunately, I had recently upgraded my client tools to SQL Server 2005 SP2, and the original install was blocking adding anything since a newer service pack had already been applied.

I figured I would need to uninstall SQL 2005 from my machine to undo the service pack, reinstall it with BIDS this time, and then apply SP2 after that.  But I found this post that made things much easier.

At the end of the thread (dated April 22, 2009) there’s a post by ubster that solves it quite nicely:

Situation: Installed SQL Server 2005 ages ago using an installer predating any of the service packs. I have since installed service pack 2. I went back to using the initial installer to add BIDS but of [course] the silly installer tells me that it’s already installed and won’t budge. I also happen to be running Vista for some masochistic reason.

Solution: Open Control Panel -> add/remove programs. Find Microsoft SQL Server 2005 and hit Change. Select Workstation Components found under SQL Server 2005 common components and hit next. Select Change Installed Components when you arrive at the option and choose to add Client Components -> Business Intelligence Development Studio. Continue through the rest of the installation and you will find a shiny new icon under Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Business Intelligence Development Studio. This solution does not require anything to first be uninstalled.

Problem solved!  Now I can open my reporting project under VS 2005, and I still have SQL Server 2005 SP2 without having had to uninstall and reinstall.

Hope this helps.

Blog at WordPress.com.