Can't apply Sql 2k server service pack 4 on XP workstation.

After install sql 2000 server - client tools on Win XP workstation, it won't
allow to install sql 2000 server Service Pack 4 (it will quit to desktop
immediately without any error or warning) But we can intall it on win2000
workstation.
- Is it normal that can't apply or not need to apply service pack on winXP
clients?
- How can I check which sql 2000 server service pack applied on clients?
No that wouldn't be considered normal. You do want to apply
the service packs to PC where the client tools are
installed.
You can open Query Analyzer and go to Help, About to
determine the build number of the client tools.
Build numbers and corresponding service packs are listed in
this article:
http://support.microsoft.com/kb/321185
-Sue
On Thu, 14 Jun 2007 09:46:14 +0800, "Pleo"
<pleoel@.hotmail.com> wrote:

>After install sql 2000 server - client tools on Win XP workstation, it won't
>allow to install sql 2000 server Service Pack 4 (it will quit to desktop
>immediately without any error or warning) But we can intall it on win2000
>workstation.
>- Is it normal that can't apply or not need to apply service pack on winXP
>clients?
>- How can I check which sql 2000 server service pack applied on clients?
>
sql

Cant able to exprot data to excel formate

Hi,...

I ma using reproting service tools fpr my reports.

And when I export large data to excel format what i get isSERVER NOT AVALIBLE eroor.

and the same export works fine when the size of data is less.

i want to export 13-17k of rows to excel format...

and i am using 2 GB of Ram.

pls help ...

waiting for ur rply

On the client, in Internet Explorer options, try increasing the size of your Temporary Internet File setting to over 100MB and see if you continue to get the error. If not, then it is related to the size of the temp file that reporting services creates in the temporary internet files in the windows folder.

Cannot uninstall reporting services

Hi,
I am trying to install reporting services client tools onto my desktop PC.
It appears that reporting services enterprise edition have been installed on
here before but there is nothing listed in add/remove programs for RS.
An excerpt of the install log is below, I am not sure what is setting the
paths for the reporting services databases to be on "d:\program files" as
this is not on my PC. I have searched through the registry with no joy.
Can anyone tell me how I can completely remove RS and start again? Oh yes
and I have checked for the COM objects prescence on my PC too and there are
not there.
Thanks in advance for your help,
Nick
-- excerpt from installation log
Property(C): DataBases.3882F579_1BCB_4C44_991C_060D38C9C09D = D:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Databases\
Property(C): SamplesDB1 = AdventureWorks2000
Property(C): CostingComplete = 1
Property(C): OutOfDiskSpace = 0
Property(C): OutOfNoRbDiskSpace = 0
Property(C): PrimaryVolumeSpaceAvailable = 0
Property(C): PrimaryVolumeSpaceRequired = 0
Property(C): PrimaryVolumeSpaceRemaining = 0
Property(C): _FeatDescription = Report Server
Property(C): _DefaultInstance = Installed
Property(C): SQL_SHOWLIC = 1
Property(C): RSAutoStart = 1
Property(C): _Service = RS
Property(C): Asp_Net_Accout_For_GUI_Display = URSUS\ASPNET
Property(C): WizardDialog = StartCopyDlg
Property(C): DisableBack = MaintenanceDlg
Property(C): SqlMaintType = 1
=== Logging stopped: 28/02/2006 15:11:48 === MSI (c) (30:20) [15:11:48:982]: Note: 1: 1729
MSI (c) (30:20) [15:11:48:982]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Configuration failed.
MSI (c) (30:20) [15:11:48:992]: Grabbed execution mutex.
MSI (c) (30:20) [15:11:48:992]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (30:20) [15:11:48:992]: MainEngineThread is returning 1603
=== Verbose logging stopped: 28/02/2006 15:11:48 ===Hi,
replying to my own post!!
I actually eventually found some rogue entries in the registry with the help
of "regmon". There were alittle obscure, well that's my excuse and I'm
sticking to it!
Nick
"Nick Long" wrote:
> Hi,
> I am trying to install reporting services client tools onto my desktop PC.
> It appears that reporting services enterprise edition have been installed on
> here before but there is nothing listed in add/remove programs for RS.
> An excerpt of the install log is below, I am not sure what is setting the
> paths for the reporting services databases to be on "d:\program files" as
> this is not on my PC. I have searched through the registry with no joy.
> Can anyone tell me how I can completely remove RS and start again? Oh yes
> and I have checked for the COM objects prescence on my PC too and there are
> not there.
> Thanks in advance for your help,
> Nick
> -- excerpt from installation log
> Property(C): DataBases.3882F579_1BCB_4C44_991C_060D38C9C09D = D:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Databases\
> Property(C): SamplesDB1 = AdventureWorks2000
> Property(C): CostingComplete = 1
> Property(C): OutOfDiskSpace = 0
> Property(C): OutOfNoRbDiskSpace = 0
> Property(C): PrimaryVolumeSpaceAvailable = 0
> Property(C): PrimaryVolumeSpaceRequired = 0
> Property(C): PrimaryVolumeSpaceRemaining = 0
> Property(C): _FeatDescription = Report Server
> Property(C): _DefaultInstance = Installed
> Property(C): SQL_SHOWLIC = 1
> Property(C): RSAutoStart = 1
> Property(C): _Service = RS
> Property(C): Asp_Net_Accout_For_GUI_Display = URSUS\ASPNET
> Property(C): WizardDialog = StartCopyDlg
> Property(C): DisableBack = MaintenanceDlg
> Property(C): SqlMaintType = 1
> === Logging stopped: 28/02/2006 15:11:48 ===> MSI (c) (30:20) [15:11:48:982]: Note: 1: 1729
> MSI (c) (30:20) [15:11:48:982]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Configuration failed.
> MSI (c) (30:20) [15:11:48:992]: Grabbed execution mutex.
> MSI (c) (30:20) [15:11:48:992]: Cleaning up uninstalled install packages, if
> any exist
> MSI (c) (30:20) [15:11:48:992]: MainEngineThread is returning 1603
> === Verbose logging stopped: 28/02/2006 15:11:48 ===>|||If you're re-installing all of SQLServer, make sure you delete all the
MSSQL folders.
For RS, you may want to check and confirm that everything is gone out
of IIS as well.
Jim