Its urgent:Please help me!

Hi All,

1) When I tried to install SQL 2000, i could only install client componets and unable to install server components because

i have windows xp professional edition installed on machine.So, I cannot connect to local server instance.

I am trying to install SQL server 2000 reporting services. But I am stuck in between, Reprting services installer asking

for SQL 2000 instance. But I cannot specfify the instance because I have only installed client componets of SQL 2000.

2) I have SQL 2005 express local instance running on my system. But Reporting services 2000 unable to accept it.

3) How unstall SQL service pack 4. because i want to install sevice pack 3a.

Please help me..

Thank you

Abdul

Why not install SQL2005 Reporting Services? There are components for working with SQL2005 Express.

|||

You will have problems if you are using Beta version or 2003 version SQL Reporting Service and later you decide to use SQL2005 Reporting Service running old version RDL files. They don't work, because the rdl definitions are different.

It is better to use the most up-to-date application. Nonetheless, even if you want to use SQL2005 Reporting Service with the old version reporting databases, you have to upgrade the databases first in Report Configuration.

|||

1) SQL Server 2000 will not be able to install on XP except express edition. Please refer to SQL Server 2000 installation guide.

2) SQL 2000 Reporting Service does not have next generation database driver so that it's not passible to connect to the higher version SQL Server than SQL Server 2000. Only backward compatibility will be implemented. Please read the white paper for SQL Server 2000 Reporting Services.

3) It's not able to down-grade the patch. By the way, the service pack 4 has already included in all the patches of service pack 3a. Please find the technical document on Microsoft Technical Sopport site.

As other person's reply, why don't you try sql server 2005 reporting services?

======================================================================

When you get help, please mark it to let people know you have been helped.