Month: December 2008

Reporting Services 2008 book.

Today I would like to spend some rows about a great book I have purchased on www.Amazon.com. The book is Microsoft SQL Server 2008 Reporting Services and the author is Brian Larson, edited by MC Graw Hill. This is the direct link: book on amazon.

book01

Let’s spend just few words about.

  1. First of all in my opinion the book is really great because it covers all the section of reporting services, it doesn’t exclude nothing, really!
  2. Second point is the approach. Brian explain every report, step by step, by including some designer issue and trouble you can find during the execution of the tutorials. He also explain the SQL part, so if you have to run a GROUP BY, he will explain you what it is a GROUP BY.
  3. Third, the book is done from easy to hard. What does it mean? The first chapter is very easy and day by day by reading the book you will go to produce more complex reports.
  4. Finally the data sample. You can download from the web site the complete database sample that it’s really complex. This is great because when I started to read and use the tutorial, I spent just few minutes to install and run the database.

A very good job, a must into your shelf!!

Internet Explorer crashes with Sharepoint.

This is a known issue that I discovered this morning.

Symptoms

In my company we are using Windows Sharepoint Services 3.0 with Windows 2008.
The clients have windows XP SP3 with Office 2003 SP3.
The browser is Internet Explorer 7.0.

Some clients have also Office 2007 or some part of it or some compatibility pack.

When they: open a document, edit a document, check-in, check-out, Internet Explorer crashes.

Resolution

To solve the problem, Microsoft has realized a KB which must be downloaded here:

http://support.microsoft.com/kb/938888

This solved my issue in the network.

Time for changes.

Finally it seems I have found a way to have a full day of 48 hours. To do that you can just remove some hours of sleep, the kite-surf and stay all night long logged into your computer.

As many of you know, I’m a NET Developer (more than that) and I’m member (not active anymore) of one of the most famous Italian NET Community (http://blogs.ugidotnet.org). Reading the other blogs, I noticed that I’m the only one who is still working with the junky old system called Windows Form 2.0.

So, starting from today I will try to learn and use the amazing new framework released by Microsoft and called WPF (Windows Presentation Foundation). In my blog I will try, as usually I do also for the other products, to share with you my experience using this product.

I hope everyone of you will have suggestions and idea to improve day by day my knowledge.

Install TFS 2008 on Windows Server 2008

Last week I decided to buy the TFS license for the TFS 2008. After 2 days and a lot of headaches I decided to follow step by step the official guide which is available here: Team Foundation installation guide and to be honest, if you follow, step by step the guide, you will have a full working version of TFS. Also my MVP friend Simon Chiaretta suggested me to use the official guide.

This short guide will show you how to install a stand alone version, this means, a single server version which will contains: WSS 3.0, SQL Standard 2008 and TFS 2008. So first of all we need 3 licenses, SQL Server 2008 standard (the express edition is not working with TFS), WSS 3.0 and Windows Server Standard 2008 and TFS 2008.

Hey buddy, my suggestion is “spend more money and buy a x64 server with a SCSI disk system, otherwise everything will be very slow …

  1. First of all, install windows server 2008
    Probably this is the most straightforward step.
    1. I don’t suggest any particular installation here, just a couple of few points. Install Windows Server 2008 standard, configure it as an Application Server and a Web Server.
    2. Install IIS 7.0 and the NET Framework 3.5 with SP1 and verify it works, you can just point with the browser to http://localhost
    3. Create a dedicated account for the installation, you must have administrative rights with the account, otherwise you will encounter a lot of trouble …
  2. Install SQL Server 2008 Standard
    1. Lunch the setup for SQL Server 2008 Standard edition.
    2. You must install the Server components, the Client components, the Reporting Services, Full-text search, Analysis services and the Management Studio if you will work locally into your machine.
    3. For every service, specify at least, 1 account, otherwise after the installation you will not be able to login into SQL. I know it’s non sense but it’s how works … Also use only Windows Authentication.
    4. Remember to reboot the machine after the installation and verify the server is running by connecting with the Management Studio. Don’t configure the Reporting Services, this step will be done by TFS. Yeah, I tried to configure it like integrated with MOSS and nothing were working properly.
    5. If you receive during the installation process the error for the Power shell you did one of this wrong steps: you already have SQL 2005, you are using a CTP version of SQL which is coming with an old version of the power shell, you are using a wrong setup of SQL, you are using the Express with advanced services.
  3. Install WSS 3.0 on Windows server 2008
    1. If you are here this means that you have done your SQL installation (cool, it takes 3 times for me). Now download WSS 3.0 with SP1 from here: WSS 3.0 SP1. Don’t download the WSS 3.0, it doesn’t work with Windows 2008, no way!!
    2. Run the setup and choose the advanced installation. You have to choose the front-end installation and choose where you want to locate the installation directory.
    3. After the installation is done, choose to build a new server farm, then choose the local server name, leave the database name as is, and with this syntax domain\user provide the credential for the TFS administrator user. Check the box for the port, don’t use the suggested port and take a note of the port you will use, then choose the NTLM authentication.
    4. Check your settings and after you take a note of everything proceed with the configuration of WSS. It will take a while!
    5. Some prompt for WSS 3.0
      1. Now we need to play with the DOS. First open prompt and change directory to : Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\
      2. stsadm.exe -o extendvs -exclusivelyusentlm -url http://WSSServerName:80 -ownerlogin Domain\UserName -owneremail “admin@localhost” -sitetemplate sts -description “Default Web Site”
      3. stsadm.exe -o siteowner -url http://WSSServerName:80 -secondarylogin Domain\TFSSETUP
      4. The first will be the administrator of SharePoint, the second one the admin account for TFS. I use the same account …
  4. Install step by step Team Foundation Server 2008
    1. First of all, let’s install the TFS server. Choose the database server (local machine name) and go ahead.
    2. Warning. I have received the warning that my SQL Server is not working, because I need TFS SP1. Integrate the SP1 of TFS into the DVD is not easy, but you can find in the latest .chm the description.
    3. Configure the account for TFS and SQL Server.
    4. Choose the previous WSS address and site (did you take note of the port??)

The next post will be how to configure TFS 2008, when I will have time to do it.