Installing MSDE SQL 2000 SP4

I was working on a install for MSDE SQL SERVER 2000 when I noticed that there
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:

> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>

Installing Inventor10

Hello,
I have a problem installing Autodesk Inventor 10 on my
WK SP4 OS system on XP SP2 system it works fine.
Event log during setup Inventor 10 Pro.
Source Loadperf
Category (none)
Event ID 2000
No object list was found in the installation file.
Adding an object list to the installation file will improve
performance of the system when measuring performance counters.
Source Loadperf
Category (none)
Event ID 1000
Performance counters for the MSSQL$INVENTORCONTENT service were loaded
successfully.
The Record Data contains the new index values assigned to this service.
Source MSSQL$INVENTORCONTENT
Category (8)
Event ID 19011
The description for Event ID ( 19011 ) in Source ( MSSQL$INVENTORCONTENT
) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer.
The following information is part of the event: (SpnRegister) : Error 1355.
Source MsiInstaller
Category (none)
Event ID 1013
Product: Microsoft SQL Server Desktop Engine --
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
Source MsiInstaller
Category (none)
Event ID 11708
Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
Source MsiInstaller
Category (none)
Event ID 11722
Product: Autodesk Inventor Professional 10 -- Error 1722.
There is a problem with this Windows Installer package.
A program run as part of the setup did not finish as expected.
Contact your support personnel or package vendor.
Action InstallMSDE, location:
F:\inv1_pro10\bin\acadfeui\support\msde\setup.exe, command:
SAPWD="AutodeskVault" INSTANCENAME="INVENTORCONTENT" SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=1 /L*v
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og /qb
REBOOT=ReallySuppress
Kind Regards
hi,
Smeusje wrote:
> Hello,
> I have a problem installing Autodesk Inventor 10 on my
> WK SP4 OS system on XP SP2 system it works fine.
> Event log during setup Inventor 10 Pro.
try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
for
RETURN VALUE 3
entries..
about 10 lines before each entry some (sometime cryptic) description of the
problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I have two of them
************************************************** ************************************************** ********************
Starting custom action SkuIt
MSI (s) (30:D4) [13:57:35:890]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (30:18) [13:57:35:921]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI47.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
MSI (s) (30:D4) [13:58:06:968]: Executing op:
ActionStart(Name=RegSQLWithMDAC.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INVENTORCONTENT" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (s) (30:D4) [13:58:06:968]: Executing op:
CustomActionSchedule(Action=RegSQLWithMDAC.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=RegSQLWithMDAC,)
MSI (s) (30:18) [13:58:06:984]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI48.tmp, Entrypoint: RegSQLWithMDAC
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action RegSqlWithMdac
MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
Engine -- An error has occurred registering this installation of SQL
Server Desktop Engine with MDAC.
MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback' is 0
MSI (s) (30:D4) [13:58:12:812]: Machine policy value 'DisableRollback' is 0
Action ended 13:58:12: InstallFinalize. Return value 3.
************************************************** ************************************************** *******************
MSI (s) (30:D4) [13:58:19:078]: Executing op:
ActionStart(Name=RollbackStreamSupportFiles.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:078]: Executing op:
CustomActionRollback(Action=RollbackStreamSupportF iles.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionTy pe=1281,Source=BinaryData,Target=RemoveSupportFile s,)
MSI (s) (30:94) [13:58:19:078]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4B.tmp, Entrypoint: RemoveSupportFiles
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
MSI (s) (30:D4) [13:58:19:203]: Executing op:
ActionStart(Name=RollbackDeferProperties.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:203]: Executing op:
CustomActionRollback(Action=RollbackDeferPropertie s.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (30:94) [13:58:19:203]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4C.tmp, Entrypoint: DeferProperties
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
MSI (s) (30:D4) [13:58:19:421]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return: 5
Defer Properties returns: 0
MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 13:58:19: INSTALL. Return value 3.
************************************************** ************************************************** **********************
I already changed from "Not difined" to "silently succeed" as
mentionned in the MSDE 2000 Release A guide
Unsigned driver installation behavior.
Unsigned non-driver installation behavior
Extract guide
A MSDE 2000 Release A installation will fail if either of the following
security policies has been set to Do not allow installation:
* The Devices: Unsigned driver installation behavior local security
policy for Windows XP.
* The Unsigned non-driver installation behavior local security
policy for Windows 2000.
If you use the Do not allow installation setting, you must change it to
Silently succeed before installing MSDE 2000 Release A. If necessary,
you can return the policy to its previous setting after the installation
is complete.
Note Do not allow installation is not the default setting for these
security policies.
To set these policies:
1. In Control Panel, double-click Administrative Tools.
2. Double-click Local Security Policy.
3. Expand Local Policies.
4. Select Security Options.
5. Ensure that the following option in the right pane is set to
Silently Succeed before installing MSDE 2000 Release A:
* On Windows XP and Windows 2003: Devices: Unsigned driver
installation behavior.
* On Windows 2000: Unsigned non-driver installation behavior.
Still doesn't work
Kind regards
Andrea Montanari wrote:

>hi,
>Smeusje wrote:
>
>try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
>for
>RETURN VALUE 3
>entries..
>about 10 lines before each entry some (sometime cryptic) description of the
>problem will be reported..
>
|||hi,
Smeusje wrote:
> I have two of them
> ************************************************** ************************************************** ********************
> MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
> Engine -- An error has occurred registering this installation of SQL
> Server Desktop Engine with MDAC.
> MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> An error has occurred registering this installation of SQL Server
> Desktop Engine with MDAC.
> MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback'
> is 0 MSI (s) (30:D4) [13:58:12:812]: Machine policy value
> 'DisableRollback' is 0 Action ended 13:58:12: InstallFinalize. Return
> value 3.
> ************************************************** ************************************************** *******************
>...
> MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return:
> 5 Defer Properties returns: 0
> MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
> MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting
> UpdateStarted property. Its current value is '1'.
> Action ended 13:58:19: INSTALL. Return value 3.
> ************************************************** ************************************************** **********************
the first one indicates a problem "installing" MDAC... actually it should
not as it only has to check for the correct MDAC stack... on WinXP sp2 and
Win2003 MDAC 2.8 of the service pack 4 will not be installed becouse of the
"superior" level of the installed component, perfomed only via Windows
Update...
for the 2nd one I really have no clues...
I do think all this is dependent of a embedded installation of MSDE... can
you please try downloading and executing the original setup.exe boostrapper
installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installing error for SQL Server 2000 SP4

I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.
<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegr oups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
sql

Installing error for SQL Server 2000 SP4

I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Installing error for SQL Server 2000 SP4

I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Installing A Default Instance AFTER a Named Instance??

I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.

It is a Production Server with 3 NAMED Instances and NO Default Instance.

Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances?Except for a reboot after the install, you should have no problems installing a default instance.|||Thank you : )|||Will the default instance automatically have the name of the Server - or is there a way to give it name - like you would a named instance.. sorry if the question sounds stupid.. : )|||The default instance will have the name of the server. The only way around this that I can think of off the top of my head is to give the machine a DNS alias.|||Thanks !!! I'm not so much worried about the name as I am Blowing up the Server by installing a Default Instance AFTER it has already been populated with Named Instances.

Installed SQL2000 SP4 successfully but still shows RTM as installe

After installing SP4 on server, I checked ProductLevel and Productversion and
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.
The other option was to edit the registry key which I do not feel
comfortable doing.
Has anyone else come across this before??
Hi Kristen
Your version number is not SP1 (384) but the RTM version.
Did you run the setup from the directory that you unzipped the files to?
Have you more than one instance of SQL Server running and have you upgraded
them all?
Did you run the service pack setup from the server?
John
"Kristen" wrote:

> After installing SP4 on server, I checked ProductLevel and Productversion and
> they still showed RTM and 8.00.194.
> I did see a whitepaper about this regarding SP1 and the fix was to apply the
> latest SP which is SP4, so this does not apply to me.
> The other option was to edit the registry key which I do not feel
> comfortable doing.
> Has anyone else come across this before??

Installed SQL2000 SP4 successfully but still shows RTM as installe

After installing SP4 on server, I checked ProductLevel and Productversion and
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.
The other option was to edit the registry key which I do not feel
comfortable doing.
Has anyone else come across this before'?Hi Kristen
Your version number is not SP1 (384) but the RTM version.
Did you run the setup from the directory that you unzipped the files to?
Have you more than one instance of SQL Server running and have you upgraded
them all?
Did you run the service pack setup from the server?
John
"Kristen" wrote:
> After installing SP4 on server, I checked ProductLevel and Productversion and
> they still showed RTM and 8.00.194.
> I did see a whitepaper about this regarding SP1 and the fix was to apply the
> latest SP which is SP4, so this does not apply to me.
> The other option was to edit the registry key which I do not feel
> comfortable doing.
> Has anyone else come across this before'?

Installed SQL2000 SP4 successfully but still shows RTM as installe

After installing SP4 on server, I checked ProductLevel and Productversion an
d
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.
The other option was to edit the registry key which I do not feel
comfortable doing.
Has anyone else come across this before'?Hi Kristen
Your version number is not SP1 (384) but the RTM version.
Did you run the setup from the directory that you unzipped the files to?
Have you more than one instance of SQL Server running and have you upgraded
them all?
Did you run the service pack setup from the server?
John
"Kristen" wrote:

> After installing SP4 on server, I checked ProductLevel and Productversion
and
> they still showed RTM and 8.00.194.
> I did see a whitepaper about this regarding SP1 and the fix was to apply t
he
> latest SP which is SP4, so this does not apply to me.
> The other option was to edit the registry key which I do not feel
> comfortable doing.
> Has anyone else come across this before'?

Installed SP4 - Version # okay but Product Level wrong?

I have the developer edition of MS SQL and applied SP4 to it. Here's what I get when I execute SELECT @.@.Version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

According to the readme, here are the version numbers for each service pack:

SQL Server 2000 Version and Level@.@.VERSIONProduct LevelSQL Server 2000 Original Release8.00.194RTMDatabase Components SP18.00.384SP1Database Components SP28.00.534SP2Database Components SP3, SP3a or MSDE 2000 Release A.8.00.760SP3Database Components SP48.00.2039SP4

Do I trust the Version Number or the Product Level? Anyone know what the story is? TIA.

The numbers are TDS( tabular data stream) yes the increament is based on service packs in SQL Sever 2000 and in Win2k you are missing two service packs because I have a box in Houston running it and as of 2005 December I had SP4, I have installed the product that is SQL Server 2000 on all existing os including XP home. I also have SQL Server 2000 SP3 and SP3a in .sql files. So you just need two service packs for Win2k. Hope this helps.|||

Thanks Caddre. I didn't realize it was reporting the OS service pack as opposed to the SQL Server service pack. I'm aware I haven't applied the latest Windows SP - I'm deferring IE 7 for the moment.

|||

EDIT

(Windows NT 5.1 (Build 2600: Service Pack 2)

(SQL Server 2000 Original Release 8.00.194 RTM
Database Components SP1 8.00.384 SP1
Database Components SP2 8.00.534 SP2
Database Components SP3, SP3a or MSDE 2000 Release A. 8.00.760 SP3
Database Components SP4 8.00.2039 SP4)

It was reporting both because the first is for Win2k while the TDS number are for SQL Server 2000 Service Pack because it default to 80 and the extra numbers defines the service packs. One more thing build 2600 in Win2k is Advanced Server.

Installation Problem. Please Help.

We are having issues installing Reporting Services on a Windows 2000 server
with SP4. The database is located on a separate server and is also running
Windows 2000 with SP4. At the end of the installation a warning is displayed
that says "Setup could not initialize the report server. you must manually
initialize the report server before using it for the first time. for more
information, see the reporting services setup documentation." . How exactly
do you initialize the report server manually? We have tried running the
rsActivate command, but that errors out. When going to the report server
there is an internal error and it says to see the error logs. The error from
the log is shown below.
aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
user: COMPUTERNAME\ASPNET
aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
When running SQL profiler on the SQL server we see that there is no attempt
to connect to the report server database from the web service, however we can
see connections being made every 10 seconds that look to be from the windows
service.
ThanksWhat errors are thrown with "rsavtivate"? Have you tried running "rsconfig"
prior to running rsactivate?
Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
www.apress.com
"David" <David@.discussions.microsoft.com> wrote in message
news:B54C509A-14BD-4F14-B85E-3B0EDA53E304@.microsoft.com...
> We are having issues installing Reporting Services on a Windows 2000
> server
> with SP4. The database is located on a separate server and is also
> running
> Windows 2000 with SP4. At the end of the installation a warning is
> displayed
> that says "Setup could not initialize the report server. you must manually
> initialize the report server before using it for the first time. for more
> information, see the reporting services setup documentation." . How
> exactly
> do you initialize the report server manually? We have tried running the
> rsActivate command, but that errors out. When going to the report server
> there is an internal error and it says to see the error logs. The error
> from
> the log is shown below.
> aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
> user: COMPUTERNAME\ASPNET
> aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
> aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details. --> System.UnauthorizedAccessException: Access is denied.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
>
> When running SQL profiler on the SQL server we see that there is no
> attempt
> to connect to the report server database from the web service, however we
> can
> see connections being made every 10 seconds that look to be from the
> windows
> service.
> Thanks|||The error that I get when I run rsactivate is:
Failure starting the web service:
System.Exception: The Report Server Web service has not generated a public
key.
The service may not have started successfully. Check the log files for more
information.
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
When trying to run the rsconfig command I also get an error saying:
System.Management.ManagementException: Provider load failure
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.ManagementObjectEnumerator.MoveNext()
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
"Rodney Landrum" wrote:
> What errors are thrown with "rsavtivate"? Have you tried running "rsconfig"
> prior to running rsactivate?
> Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
> www.apress.com
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:B54C509A-14BD-4F14-B85E-3B0EDA53E304@.microsoft.com...
> > We are having issues installing Reporting Services on a Windows 2000
> > server
> > with SP4. The database is located on a separate server and is also
> > running
> > Windows 2000 with SP4. At the end of the installation a warning is
> > displayed
> > that says "Setup could not initialize the report server. you must manually
> > initialize the report server before using it for the first time. for more
> > information, see the reporting services setup documentation." . How
> > exactly
> > do you initialize the report server manually? We have tried running the
> > rsActivate command, but that errors out. When going to the report server
> > there is an internal error and it says to see the error logs. The error
> > from
> > the log is shown below.
> >
> > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
> > user: COMPUTERNAME\ASPNET
> > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
> > aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details., Error getting running jobs;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details. --> System.UnauthorizedAccessException: Access is denied.
> > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > errorCode, IntPtr errorInfo)
> > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> >
> >
> > When running SQL profiler on the SQL server we see that there is no
> > attempt
> > to connect to the report server database from the web service, however we
> > can
> > see connections being made every 10 seconds that look to be from the
> > windows
> > service.
> >
> > Thanks
>
>|||I have got the rsActivate command to work now. I had to manually add the key
into the Keys table using the stored procedure AnnounceOrGetKey.
Unfortunately the reportserver website still returns an 'access is denied'
error. The log file still shows the same stack trace and it seems like the
problem occurs in the RSManagedCrypto.RSCrypto.ExportPublicKey() function.
Anybody got any ideas.
"David" wrote:
> The error that I get when I run rsactivate is:
> Failure starting the web service:
> System.Exception: The Report Server Web service has not generated a public
> key.
> The service may not have started successfully. Check the log files for more
> information.
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> BaseCmdLine instance)
> When trying to run the rsconfig command I also get an error saying:
> System.Management.ManagementException: Provider load failure
> at
> System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.ManagementObjectEnumerator.MoveNext()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> BaseCmdLine instance)
> "Rodney Landrum" wrote:
> > What errors are thrown with "rsavtivate"? Have you tried running "rsconfig"
> > prior to running rsactivate?
> > Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
> > www.apress.com
> >
> >
> >
> > "David" <David@.discussions.microsoft.com> wrote in message
> > news:B54C509A-14BD-4F14-B85E-3B0EDA53E304@.microsoft.com...
> > > We are having issues installing Reporting Services on a Windows 2000
> > > server
> > > with SP4. The database is located on a separate server and is also
> > > running
> > > Windows 2000 with SP4. At the end of the installation a warning is
> > > displayed
> > > that says "Setup could not initialize the report server. you must manually
> > > initialize the report server before using it for the first time. for more
> > > information, see the reporting services setup documentation." . How
> > > exactly
> > > do you initialize the report server manually? We have tried running the
> > > rsActivate command, but that errors out. When going to the report server
> > > there is an internal error and it says to see the error logs. The error
> > > from
> > > the log is shown below.
> > >
> > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
> > > user: COMPUTERNAME\ASPNET
> > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
> > > aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more
> > > details., Error getting running jobs;
> > > Info:
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more
> > > details. --> System.UnauthorizedAccessException: Access is denied.
> > > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > > errorCode, IntPtr errorInfo)
> > > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> > >
> > >
> > > When running SQL profiler on the SQL server we see that there is no
> > > attempt
> > > to connect to the report server database from the web service, however we
> > > can
> > > see connections being made every 10 seconds that look to be from the
> > > windows
> > > service.
> > >
> > > Thanks
> >
> >
> >|||"David" wrote:
> The error that I get when I run rsactivate is:
> Failure starting the web service:
> System.Exception: The Report Server Web service has not generated a public
> key.
> The service may not have started successfully. Check the log files for more
> information.
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> BaseCmdLine instance)
> When trying to run the rsconfig command I also get an error saying:
> System.Management.ManagementException: Provider load failure
> at
> System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.ManagementObjectEnumerator.MoveNext()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> BaseCmdLine instance)
> "Rodney Landrum" wrote:
> > What errors are thrown with "rsavtivate"? Have you tried running "rsconfig"
> > prior to running rsactivate?
> > Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
> > www.apress.com
> >
> >
> >
> > "David" <David@.discussions.microsoft.com> wrote in message
> > news:B54C509A-14BD-4F14-B85E-3B0EDA53E304@.microsoft.com...
> > > We are having issues installing Reporting Services on a Windows 2000
> > > server
> > > with SP4. The database is located on a separate server and is also
> > > running
> > > Windows 2000 with SP4. At the end of the installation a warning is
> > > displayed
> > > that says "Setup could not initialize the report server. you must manually
> > > initialize the report server before using it for the first time. for more
> > > information, see the reporting services setup documentation." . How
> > > exactly
> > > do you initialize the report server manually? We have tried running the
> > > rsActivate command, but that errors out. When going to the report server
> > > there is an internal error and it says to see the error logs. The error
> > > from
> > > the log is shown below.
> > >
> > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
> > > user: COMPUTERNAME\ASPNET
> > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
> > > aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more
> > > details., Error getting running jobs;
> > > Info:
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more
> > > details. --> System.UnauthorizedAccessException: Access is denied.
> > > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > > errorCode, IntPtr errorInfo)
> > > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> > >
> > >
> > > When running SQL profiler on the SQL server we see that there is no
> > > attempt
> > > to connect to the report server database from the web service, however we
> > > can
> > > see connections being made every 10 seconds that look to be from the
> > > windows
> > > service.
> > >
> > > Thanks
> >
> >
> >|||Make sure the ASP.NET if os is 2000 is able to act as part of the OS in
local securiy policy. (this would be IWAM_machinename for 2003. I had to
add these accounts and verify the default app pool was running as network
service to get rsactivate to work correctly.
"David" wrote:
> The error that I get when I run rsactivate is:
> Failure starting the web service:
> System.Exception: The Report Server Web service has not generated a public
> key.
> The service may not have started successfully. Check the log files for more
> information.
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> BaseCmdLine instance)
> When trying to run the rsconfig command I also get an error saying:
> System.Management.ManagementException: Provider load failure
> at
> System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.ManagementObjectEnumerator.MoveNext()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> BaseCmdLine instance)
> "Rodney Landrum" wrote:
> > What errors are thrown with "rsavtivate"? Have you tried running "rsconfig"
> > prior to running rsactivate?
> > Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
> > www.apress.com
> >
> >
> >
> > "David" <David@.discussions.microsoft.com> wrote in message
> > news:B54C509A-14BD-4F14-B85E-3B0EDA53E304@.microsoft.com...
> > > We are having issues installing Reporting Services on a Windows 2000
> > > server
> > > with SP4. The database is located on a separate server and is also
> > > running
> > > Windows 2000 with SP4. At the end of the installation a warning is
> > > displayed
> > > that says "Setup could not initialize the report server. you must manually
> > > initialize the report server before using it for the first time. for more
> > > information, see the reporting services setup documentation." . How
> > > exactly
> > > do you initialize the report server manually? We have tried running the
> > > rsActivate command, but that errors out. When going to the report server
> > > there is an internal error and it says to see the error logs. The error
> > > from
> > > the log is shown below.
> > >
> > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
> > > user: COMPUTERNAME\ASPNET
> > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
> > > aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more
> > > details., Error getting running jobs;
> > > Info:
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more
> > > details. --> System.UnauthorizedAccessException: Access is denied.
> > > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > > errorCode, IntPtr errorInfo)
> > > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > at
> > > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> > >
> > >
> > > When running SQL profiler on the SQL server we see that there is no
> > > attempt
> > > to connect to the report server database from the web service, however we
> > > can
> > > see connections being made every 10 seconds that look to be from the
> > > windows
> > > service.
> > >
> > > Thanks
> >
> >
> >|||Giving the ASPNET account the ability to Act as Part of the Operating System
seemed to fix our problems. According to several places online, including
Microsoft, it is recommended that you not give the ASPNET account that
privilege. So after the report server was running properly what we did was
remove that privilege from the ASPNET account and we restarted IIS. The
report server still works. It seems to me that the Act as Part of the
Operating System privilege just needs to be added to the ASPNET account on
the first access to the report server.
Anybody see any problems with this solution?
Thanks,
David
"parisma" wrote:
> Make sure the ASP.NET if os is 2000 is able to act as part of the OS in
> local securiy policy. (this would be IWAM_machinename for 2003. I had to
> add these accounts and verify the default app pool was running as network
> service to get rsactivate to work correctly.
> "David" wrote:
> > The error that I get when I run rsactivate is:
> > Failure starting the web service:
> > System.Exception: The Report Server Web service has not generated a public
> > key.
> > The service may not have started successfully. Check the log files for more
> > information.
> > at
> > Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> > clientType)
> > at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> > at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> > BaseCmdLine instance)
> >
> > When trying to run the rsconfig command I also get an error saying:
> > System.Management.ManagementException: Provider load failure
> > at
> > System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> > errorCode)
> > at System.Management.ManagementObjectEnumerator.MoveNext()
> > at
> > Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> > at
> > Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> > at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> > BaseCmdLine instance)
> >
> > "Rodney Landrum" wrote:
> >
> > > What errors are thrown with "rsavtivate"? Have you tried running "rsconfig"
> > > prior to running rsactivate?
> > > Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
> > > www.apress.com
> > >
> > >
> > >
> > > "David" <David@.discussions.microsoft.com> wrote in message
> > > news:B54C509A-14BD-4F14-B85E-3B0EDA53E304@.microsoft.com...
> > > > We are having issues installing Reporting Services on a Windows 2000
> > > > server
> > > > with SP4. The database is located on a separate server and is also
> > > > running
> > > > Windows 2000 with SP4. At the end of the installation a warning is
> > > > displayed
> > > > that says "Setup could not initialize the report server. you must manually
> > > > initialize the report server before using it for the first time. for more
> > > > information, see the reporting services setup documentation." . How
> > > > exactly
> > > > do you initialize the report server manually? We have tried running the
> > > > rsActivate command, but that errors out. When going to the report server
> > > > there is an internal error and it says to see the error logs. The error
> > > > from
> > > > the log is shown below.
> > > >
> > > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Initializing crypto as
> > > > user: COMPUTERNAME\ASPNET
> > > > aspnet_wp!crypto!864!11/3/2004-10:38:52:: i INFO: Exporting public key
> > > > aspnet_wp!library!864!11/3/2004-10:38:52:: e ERROR: Throwing
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > > An internal error occurred on the report server. See the error log for
> > > > more
> > > > details., Error getting running jobs;
> > > > Info:
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > > An internal error occurred on the report server. See the error log for
> > > > more
> > > > details. --> System.UnauthorizedAccessException: Access is denied.
> > > > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > > > errorCode, IntPtr errorInfo)
> > > > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > > > at
> > > > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > > at
> > > > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > > at
> > > > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > > at
> > > > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > > at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> > > >
> > > >
> > > > When running SQL profiler on the SQL server we see that there is no
> > > > attempt
> > > > to connect to the report server database from the web service, however we
> > > > can
> > > > see connections being made every 10 seconds that look to be from the
> > > > windows
> > > > service.
> > > >
> > > > Thanks
> > >
> > >
> > >

installation problem

I tried to install MSSQL Enterprise Server 2000 at Windows 2000 Server (SP4). It looks fine during the option selection but after I enter the sa password and click Next, the installation program hangs and a process setupsql.exe still remains on system. I can only end this process at Task Manager. What's wrong there and how can I fix it?

Best rgds,
JoeHave you used this CD or copy to install other places? Also, after this install fails have you looked to see if it shows up in the installed programs list? You might need to clean the registry up for this to work now. I would call MS support on this one though if you can't figure it out, because you might end up reinstalling the OS to get it to work now. It's $250 per incident.

I would try another CD first if you have one. :)

Installation of RS 2000 on SQL 2000 with SP4

Is there anyway of installing Reporting Services on a SQL server with SP4
installed. We recieve the error:
"This edition of the Reporting Server Database is not supported on the
edition of SQL Server 2000 you have chosen"
Thanks for any helpYou must have matching editions. For example, if your SQL installation
is 'Standard', you must install a Standard edition of MSRS. If your
SQL installation is 'Enterprise' edition you need to install an
enterprise edition of MSRS.
To determine your version of SQL, open Query Analyzer and execute the
statement 'SELECT @.@.VERSION'
Andy Potter|||Also, make sure that you are not running personal edition. RS does not run
at all on personal edition.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Duckworth" <scott.duckworth@.nospam.aqssys.com> wrote in message
news:epWuPBDHGHA.2912@.tk2msftngp13.phx.gbl...
> Is there anyway of installing Reporting Services on a SQL server with SP4
> installed. We recieve the error:
> "This edition of the Reporting Server Database is not supported on the
> edition of SQL Server 2000 you have chosen"
> Thanks for any help
>|||Thanks for the help. It was a Developer Edition installation.
"Scott Duckworth" <scott.duckworth@.nospam.aqssys.com> wrote in message
news:epWuPBDHGHA.2912@.tk2msftngp13.phx.gbl...
> Is there anyway of installing Reporting Services on a SQL server with SP4
> installed. We recieve the error:
> "This edition of the Reporting Server Database is not supported on the
> edition of SQL Server 2000 you have chosen"
> Thanks for any help
>

installation media

Hi,
I am running SQL Server 2000 SP4 on Windows Server 2003 and IIS Server 6.0
on the same machine. I have a SQL Server 2000 installation CD. I don't find
Reporting Services included in that CD. From where can I get the Reporting
Services component? Thanks in advance.SQL Server2000' Reporting Services was released (2003) well after SQL
Server2000 (1999), as add-on. So, if your SQL Server CD was acquired before
RS available, it would not contain RS obviously. Usually, SQL Server2000
Reporting Services comes in a seperate disk. If you have a legal copy of SQL
Server2000, you are entitled for free SQL Server Reporting Services. You may
have to contact the dealer who sold you the SQL Server copy, if you do not
have one.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:7519BB6D-A2AF-41A9-BB2B-CADA59B93928@.microsoft.com...
> Hi,
> I am running SQL Server 2000 SP4 on Windows Server 2003 and IIS Server 6.0
> on the same machine. I have a SQL Server 2000 installation CD. I don't
> find
> Reporting Services included in that CD. From where can I get the Reporting
> Services component? Thanks in advance.

Installation Issue

Hi,
I am Installing Reporting services enterprise Version On Windows 2000 Server
with SP4. The Installtion went smooth except at the finish dialog it gave me
the Warning message "Setup could not initialize the Report server. you must
manually initialize the report server"
My reportserver services shows started in the services window.
I tried running
"C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i . which
upated the framework succesfully.
Also the ASPNet user has the read/write permission on the Temporary ASP.NET
files folder.
I also ran rsactivate.exe successfully.
I also ran rsconfig.exe successfully.
I have given ASPNET user the Admin rights as well as It has the read/write
rights over the Asp.NET temporary files folder.
I have all the servers on the same machine.
Inspite of all these exercises when I browse for the http:\\Localhost page
it gives me Application error with message "Access denied to 'c:\inetpub'.
Failed to start monitoring file changes. "
Any suggestions please !!!
Thanks in advance.
siajHey ..
I solved the problem...
I uninstalled the Reporting services and reinstalled it with two change
a. I installed it on the F; drive instead of the rot drive C
The Instalation went on successfullly but again I got the same warning to
start the services manually.
b. Then I added read/write rights to the ASPNET user over the INETPUB folder.
(I think this worked out my problem)
Now I can browse on the http:\\localhost\reportserver
Cheers,
siaj
"siaj" wrote:
> Hi,
> I am Installing Reporting services enterprise Version On Windows 2000 Server
> with SP4. The Installtion went smooth except at the finish dialog it gave me
> the Warning message "Setup could not initialize the Report server. you must
> manually initialize the report server"
> My reportserver services shows started in the services window.
>
> I tried running
> "C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i . which
> upated the framework succesfully.
> Also the ASPNet user has the read/write permission on the Temporary ASP.NET
> files folder.
>
> I also ran rsactivate.exe successfully.
> I also ran rsconfig.exe successfully.
> I have given ASPNET user the Admin rights as well as It has the read/write
> rights over the Asp.NET temporary files folder.
> I have all the servers on the same machine.
>
> Inspite of all these exercises when I browse for the http:\\Localhost page
> it gives me Application error with message "Access denied to 'c:\inetpub'.
> Failed to start monitoring file changes. "
>
> Any suggestions please !!!
> Thanks in advance.
> siaj

installation fails on xp home - failed to configure server

Hi,
First I attemtped to upgrade MSDE to sp4, and I got the error
"This product is not installed",
So I removed the installation of MSDE and just installed sp4 directly. But
when I do, I get the error
"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (A4!4C) [12:01:18:241]: Product: Microsoft SQL Server Desktop Engine
(VLM) -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information."
The only other line in the log that metions a failure is
Setting SqlEdition property failed
The installer then backs everthing out and removes the service. The service
was already installed and running at that point.
I am using SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE to install,
Thanks,
Brian
hi Brian,
msnews.microsoft.com wrote:
> Hi,
> First I attemtped to upgrade MSDE to sp4, and I got the error
> "This product is not installed",
> So I removed the installation of MSDE and just installed sp4
> directly. But when I do, I get the error
> "Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> MSI (s) (A4!4C) [12:01:18:241]: Product: Microsoft SQL Server Desktop
> Engine (VLM) -- Setup failed to configure the server. Refer to the
> server error logs and setup error logs for more information."
> The only other line in the log that metions a failure is
> Setting SqlEdition property failed
> The installer then backs everthing out and removes the service. The
> service was already installed and running at that point.
> I am using SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE to install,
this usually means you did not comletely uninstall MSDE (not your fault,
just MSDE fault :D)
I succesfully cleared my registry and file system following
http://support.microsoft.com/default...b;en-us;290991 KB article
adiveces but the Windows Installer entries, that can be cleared using the
Windows Installer SDK tool Msizap.exe as per
http://support.microsoft.com/default...b;en-us;320873 (never tried)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Got it fixed.
To get it to work I did the following:
1. Intalled a default instance. I had removed it as well. That worked.
2. re-registering sqldmo.dll. I did this because DbaMgr got an automation
error when connecting to the default instance
3. Installed the named instance I wanted. This time it worked.
Notes:
The error I was getting was
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
Things learned along the way:
1. If the install fails, then enable verbose logging with /L*v
C:\MSDELog.log. Look in the log when its finished for what failed. When you
get the error message box, LEAVE IT THERE, and go look at the log. The last
thing it did is the last line.
2. If you get the error "Unable to configure server", then look in the file
cnfgsvr.out. It will be in C:\Program files\Microsoft SQL
Server\MSSQL$<instancename>\Inatall (assuming drive c)
3. To clean manully to get the installer to resintall completely if a
partial install is left on the system:
- Run Windows Installer SDK tool Msizap.exe as per
http://support.microsoft.com/default...b;en-us;320873
The command is MSIZAP.EXE" T {product code}. The product code can be
found in the install log (C:\MSDELog.log in the example above). The product
code for MDSE service pack 4 was
{E09B48B5-E141-427A-AB0C-D3605127224A} so I ran
MSIZAP.EXE" T {E09B48B5-E141-427A-AB0C-D3605127224A}
- Manually delete the folder C:\Program Files\Microsoft SQL Server\MSSQL
or C:\Program Files\Microsoft SQL Server\MSSQL$<instancename>. Make sure you
look at cnfgsvr.out first if you need too!
Brian
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3s9k91Fn804jU1@.individual.net...
> hi Brian,
> msnews.microsoft.com wrote:
> this usually means you did not comletely uninstall MSDE (not your fault,
> just MSDE fault :D)
> I succesfully cleared my registry and file system following
> http://support.microsoft.com/default...b;en-us;290991 KB article
> adiveces but the Windows Installer entries, that can be cleared using the
> Windows Installer SDK tool Msizap.exe as per
> http://support.microsoft.com/default...b;en-us;320873 (never
> tried)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Installation Fails -> need sp3a but there's a sp4??

I installed RS developer edition on windows 2000 with sp4.
Also there's SQL 2000 with sp4.
During the installation where missing:
1)VS 2003
2)Authz.dll
I installed it without those things.I download the Authz.dll and add it 2
system32 and Reinstalled the RS but somewhere in the middle there was error
that Reporting services requier sql 2000 with sp3a but i have sp4!!!
What 2 do?well the solution was as expected with microsoft products:
Remove sp4 and install it again.
"ש×?×?×?" wrote:
> I installed RS developer edition on windows 2000 with sp4.
> Also there's SQL 2000 with sp4.
> During the installation where missing:
> 1)VS 2003
> 2)Authz.dll
> I installed it without those things.I download the Authz.dll and add it 2
> system32 and Reinstalled the RS but somewhere in the middle there was error
> that Reporting services requier sql 2000 with sp3a but i have sp4!!!
> What 2 do?
>

Installation error an error occured during move data process: -145...?

hi all..

please any one help me in installing sql sp4 in my w2k server machine having sp4 and all the other updates.i tried installing sql sp3 and newly downloaded sql sp4 but shows an error at 97 % of installation that "an error occured during move data process: -145"

its really urgent ....please

thanxz in advance

Have you repeated the process?|||

thanxz bass for the reply..i installed sql server analysis service and installed the service packs..its now ok...Solved errors..thnk god

but i want to know more about the error..i googled it...nothing meaningful...