SQL Server 2005 vs 2000 Components

When customers received from Microsoft the latest CDs it included GP 9.0, FRx 6.7 and SQL Server 2005.

A lot of questions had been asked in forums about the difference between SQL Server 2000 and 2005. Below is a table which shows the components of both versions:

Component	SQL Server 2000	SQL Server 2005
Extract, transformation, and load	Data Transformation Services (DTS)	SQL Server 2005 Integration Services
Relational data warehouse	SQL Server 2000 relational database	SQL Server 2005 relational database
Multidimensional database	SQL Server 2000 Analysis Services	SQL Server 2005 Analysis Services
Data mining	SQL Server 2000 Analysis Services	SQL Server 2005 Analysis Services
Managed reporting	SQL Server 2000 Reporting Services	SQL Server 2005 Reporting Services
Ad hoc reporting		SQL Server 2005 Reporting Services
Ad hoc query and analysis	Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)	Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)
Database development tools	SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other	SQL Server 2005 Business Intelligence Development Studio
Database management tools	Enterprise Manager, Analysis Manager	SQL Server 2005 SQL Server Management Studio

The SQL Server Web Data Administrator

I've been using Citrix Nfuse for years to access my SQL Server data but when Microsoft released a web interface that can help you manage your SQL Server databases, I downloaded it right away and never looked back. With this tool, called the SQL Server Web Data Administrator, you can:

* Perform ad-hoc queries against databases and save them to your file system.
* Create/edit databases in SQL Server 2000 or MSDE 2000.
* View, create, and edit stored procedures.
* Export and import database schema and data.
* Manage users and roles.

Where do I download?

You can download the SQL Server Web Data Administrator from Microsofts Web site. Before installing it, you must meet the following requirements:

* Windows 2000 SP4, Windows Server 2003, or Windows XP
* SQL Server 7.0 SP2 or higher
* Microsoft .NET SDK or Visual Studio.NET
* IE 5.5 or higher
* IIS

Note: These are the requirements of the machine that the product is being installed on.

Installing SQL Server Reporting Services

I started installing SQL Server Reporting Services today and saw a lot of required softwares including Visual Studio.Net, IIS and ASP.net. I wasn't prepared for all the software required but was able to complete the install.

On this test server I have Windows 2003 server, SQL Server 2000 Std Edition, SQL Server Analysis Services, MBS Great Plains 8.0 and Crystal Reports 10. Another test server I have my Active Directory, DNS,DHCP, IIS and Microsoft Business Portal 2.5.

I've named the other server TestPortal while this is GPSQLTest. I'll discuss more about the GPSQLTest server. I've been reading about SQL Server SP4 and like the other SP that came before, I will wait and see what others had to say.