Andrew Karcher's Bits o' Data

in

September 2008 - Posts

Free SQL Server 2008 E-Book

SQL Server gurus Peter DeBetta, Greg Low and Mark Whitehorn just released a new E-Book on SQL Server 2008 through MSPress and it is now available online.  And the best part about it is that it is FREE.  You can download the E-Book by going here: http://csna01.libredigital.com/?urss1q2we6.

Fall Tech Day by the San Diego .Net User Group

Are you a developer in the SoCal region that is interested in learning about some of the new technologies, the San Diego .Net User Group is hosting a Fall Tech Day featuring Jeffrey Palermo and Daniel Egan.  Jeffrey Palermo will giving a 1/2 day session on the ASP.Net MVC Framework to start the day. Jeffrey is a Microsoft MVP, INETA speaker and certified Agile Development expert.  He is also the author of the upcoming ASP.Net MVC in Action book.

In the afternoon, Daniel Egan, . INETA speaker, MVP and Microsoft Regional Director, will be giving everyone an overview of LINQ.  This is one technology that as a developer you will need to be up to speed on as all future data access technologies are integrating LINQ. The second speaker in the afternoon will be myself giving an overview of the new developer features in SQL Server 2008.

This is going to be an content filled day for any developer.  If you are interested in attending you can access the registration site here: https://www.123signup.com/event?id=tryjn

Look forward to seeing some of you there.

Setting up Reporting Services on Windows Vista

In the past I have tried setting up Reporting Services on Windows Vista with no success and always reverted to Windows XP.  Well I finally had to get this working and, of course, found some help on the web.  So I had to install both 2005 and 2008 so I got to have fun with both.

After installing SQL 2005, everything seemed to be fine.  However, opening up Report Manager left me with a page with only the Header and no ability to add folders or manage anything.  Luckily I found this article on TechNet that helps you get around this very problem.  http://technet.microsoft.com/en-us/library/ms159704.aspx#VistaAdmin.  Once I got that setup Reporting Services 2005 is all happy and I can open IE without having to Run As Administrator

So on to SQL 2008.  Since I was running side-by-side, I setup SQL 2008 to run as Named Instance "SQL2008".  So I install with the default configuration and after the install I fire up the Reporting Services Configuration Manager.  And I get this very helpful error "No Report Server Found - Invalid Namespace".  Hmm. Well let's see what we can find about this one.  Luckily I found this blog entry by Justin King.  Once I went through all the steps the Configuration Manager correctly saw my Report Server so I was pass that roadblock.   The last step was to apply the TechNet instructions above as well for SQL 2008

So I am now the proud new owner of Reporting Services Instances on Vista for SQL 2005 and SQL 2008.  Hope this helps someone else struggling through the same problem.