When you run the install you will see the option for client tools only. It takes care of the .NET stuff that you need and will install the Business Intelligence...

The big thing is putting your customer database in the proper spot per their recommendations and when you go to create that database you should be able to right click...

MDF is your data file and the LDF are the log files. When you walk through the install you can point where you want to put the default datafiles and...

Somewhat hard to answer that. First of all though can't the HBA's be load balanced? If so that would seem to be the best solution.

Ultimately your utilization of the...

I believe the proper place is http://jobs.sqlservercentral.com/ instead of the forums.

Hope that works well for you!

Check out these posts -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2277232&SiteID=1

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=45101&enterthread=y

Pretty sure your problem is similar to what is being described here.

Wow, sounds like a rough gig. :w00t: This link gives a brief overview of some of the key counters that you might want to look at - http://www.extremeexperts.com/SQL/Articles/SQLCounters.aspx

There really...

Agreed, most often the support agreements are rarely used to the extent that the expense is covered. I too really appreciate the price per call structure that MS offers, especially...

Perry, You would be correct about the logins. I make it a policy to leave default DB as master to avoid other issues in the event that the default is...

Sure. On the server Start > All Programs > Microsoft SQL Server 2005 > Congfiguration Tools > Reporting Services Configuration

You should be able to use Books On Line to...

David,

Ultimately you need to catch the blocking statement so that you can see what that is doing and then start to work through any tuning that is needed. There is...

I would walk through the configuration utility again and make sure you point to the current existing databases. Post a reply as to how this works. Thanks.

Is there a login for sa?

You can get some pretty decent understanding from here - http://msdn.microsoft.com/en-us/library/ms190764.aspx

Ultimately though it does depend on your environment as the amount of read / write activity really drives what configuration...

It's nice that you can start clean. There are probably several different suggestions that you could get but I would recommend building out the new 64Bit box with SQL Server...