I have patched my MS SQL 2000 DB from SP2 to SP3.
I noticed from the enterprise manager the patch level indicates
8.00.760 (SP3).
However, using microsofts type 4 JDBC driver to connect to SQL2000, I got the following info when I used one of the APIs to retrieve the database version :
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3) .
Now... which one is having the bug? MS JDBC driver or MS SQL 2000 SP3 ??8.00.760 = 2000 SP3. JDBC was written before SP3.
Look at %windir%\sqlsp.log to see SP3 is correctly installed.|||Originally posted by ispaleny
8.00.760 = 2000 SP3. JDBC was written before SP3.
Look at %windir%\sqlsp.log to see SP3 is correctly installed.
Indeed Type 4 MS JDBC driver is written b4 service pack 3.
However, after patching MS SQL 2000, the driver should correctly retrieve the info from SQL 2000. Don't suppose that the JDBC driver has that value hard-coded in its coding?
Probably I would temporary revert to the JDBC-ODBC bridge to do a simple check..|||I tried to patch SP3 on MS sql 2000 standard edition, the JDBC driver reports it correctly.
Thus, seems like the only problem occurs on my MS Sql2000 Enterprise Edition.
Showing posts with label patched. Show all posts
Showing posts with label patched. Show all posts
Monday, February 20, 2012
MS SBS 2003 and RS
Hi,
I have installed SBS 2003 premium andSQL Server 2000 on my server with
default settings and patched it using Windows Update site. Also, installed
SQL Server reporting services. During setup, it warned me the Sharepoint is
installed (I don't know how Sharepoint got installed) and at the end, it
failed to initialize reporting services. Now, when I enter
"localhost/reports" in address line of IE, I get this error message:
The underlying connection was closed: Unable to connect to the remote
server.
I checked SRM*.log error log and found an error message:
<Func Name='Do_Activate_ReportService'>
<Func Name='CreateProccessAndWait'>
Error reported by child process:
Failure starting the web service:
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.
<EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
Error 1603 Launching RSActivate.exe:
C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
"C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Do_Activate_ReportService: Activation Failed!
<EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
<EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
---
When I execute RSActivate on command line, I get the same error (The Report
Server Web service has not generated a public key).
I played with settings of reporting services installation (service account
and SQL Server user) in hope to get it installed successfully but it always
fails.
Do you have any idea about my problem?Alex
I had a similar issue: I had use a domain user account; the service now
starts.
Kic
"Alex" <alim@.rogers.com> wrote in message
news:#mjXxZy$EHA.2032@.tk2msftngp13.phx.gbl...
> Hi,
> I have installed SBS 2003 premium andSQL Server 2000 on my server with
> default settings and patched it using Windows Update site. Also, installed
> SQL Server reporting services. During setup, it warned me the Sharepoint
is
> installed (I don't know how Sharepoint got installed) and at the end, it
> failed to initialize reporting services. Now, when I enter
> "localhost/reports" in address line of IE, I get this error message:
> The underlying connection was closed: Unable to connect to the remote
> server.
> I checked SRM*.log error log and found an error message:
> <Func Name='Do_Activate_ReportService'>
> <Func Name='CreateProccessAndWait'>
> Error reported by child process:
> Failure starting the web service:
> 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.
> <EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
> Error 1603 Launching RSActivate.exe:
> C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
> "C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Do_Activate_ReportService: Activation Failed!
> <EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
> <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> ---
> When I execute RSActivate on command line, I get the same error (The
Report
> Server Web service has not generated a public key).
> I played with settings of reporting services installation (service account
> and SQL Server user) in hope to get it installed successfully but it
always
> fails.
> Do you have any idea about my problem?
>|||Thanks Kic for the reply.
Domain user account for service account or SQL Server access?
Alex
"kic" <kic1999@.stop.the.damn.spam.hot.mail.com> wrote in message
news:uep9mb1$EHA.4004@.tk2msftngp13.phx.gbl...
> Alex
> I had a similar issue: I had use a domain user account; the service now
> starts.
> Kic
> "Alex" <alim@.rogers.com> wrote in message
> news:#mjXxZy$EHA.2032@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I have installed SBS 2003 premium andSQL Server 2000 on my server with
> > default settings and patched it using Windows Update site. Also,
installed
> > SQL Server reporting services. During setup, it warned me the Sharepoint
> is
> > installed (I don't know how Sharepoint got installed) and at the end, it
> > failed to initialize reporting services. Now, when I enter
> > "localhost/reports" in address line of IE, I get this error message:
> > The underlying connection was closed: Unable to connect to the remote
> > server.
> >
> > I checked SRM*.log error log and found an error message:
> > <Func Name='Do_Activate_ReportService'>
> > <Func Name='CreateProccessAndWait'>
> > Error reported by child process:
> > Failure starting the web service:
> > 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.
> >
> > <EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
> > Error 1603 Launching RSActivate.exe:
> > C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
> > "C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
> > Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config"
> > Do_Activate_ReportService: Activation Failed!
> > <EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
> > <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> > ---
> >
> > When I execute RSActivate on command line, I get the same error (The
> Report
> > Server Web service has not generated a public key).
> > I played with settings of reporting services installation (service
account
> > and SQL Server user) in hope to get it installed successfully but it
> always
> > fails.
> >
> > Do you have any idea about my problem?
> >
> >
>
I have installed SBS 2003 premium andSQL Server 2000 on my server with
default settings and patched it using Windows Update site. Also, installed
SQL Server reporting services. During setup, it warned me the Sharepoint is
installed (I don't know how Sharepoint got installed) and at the end, it
failed to initialize reporting services. Now, when I enter
"localhost/reports" in address line of IE, I get this error message:
The underlying connection was closed: Unable to connect to the remote
server.
I checked SRM*.log error log and found an error message:
<Func Name='Do_Activate_ReportService'>
<Func Name='CreateProccessAndWait'>
Error reported by child process:
Failure starting the web service:
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.
<EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
Error 1603 Launching RSActivate.exe:
C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
"C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Do_Activate_ReportService: Activation Failed!
<EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
<EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
---
When I execute RSActivate on command line, I get the same error (The Report
Server Web service has not generated a public key).
I played with settings of reporting services installation (service account
and SQL Server user) in hope to get it installed successfully but it always
fails.
Do you have any idea about my problem?Alex
I had a similar issue: I had use a domain user account; the service now
starts.
Kic
"Alex" <alim@.rogers.com> wrote in message
news:#mjXxZy$EHA.2032@.tk2msftngp13.phx.gbl...
> Hi,
> I have installed SBS 2003 premium andSQL Server 2000 on my server with
> default settings and patched it using Windows Update site. Also, installed
> SQL Server reporting services. During setup, it warned me the Sharepoint
is
> installed (I don't know how Sharepoint got installed) and at the end, it
> failed to initialize reporting services. Now, when I enter
> "localhost/reports" in address line of IE, I get this error message:
> The underlying connection was closed: Unable to connect to the remote
> server.
> I checked SRM*.log error log and found an error message:
> <Func Name='Do_Activate_ReportService'>
> <Func Name='CreateProccessAndWait'>
> Error reported by child process:
> Failure starting the web service:
> 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.
> <EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
> Error 1603 Launching RSActivate.exe:
> C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
> "C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Do_Activate_ReportService: Activation Failed!
> <EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
> <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> ---
> When I execute RSActivate on command line, I get the same error (The
Report
> Server Web service has not generated a public key).
> I played with settings of reporting services installation (service account
> and SQL Server user) in hope to get it installed successfully but it
always
> fails.
> Do you have any idea about my problem?
>|||Thanks Kic for the reply.
Domain user account for service account or SQL Server access?
Alex
"kic" <kic1999@.stop.the.damn.spam.hot.mail.com> wrote in message
news:uep9mb1$EHA.4004@.tk2msftngp13.phx.gbl...
> Alex
> I had a similar issue: I had use a domain user account; the service now
> starts.
> Kic
> "Alex" <alim@.rogers.com> wrote in message
> news:#mjXxZy$EHA.2032@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I have installed SBS 2003 premium andSQL Server 2000 on my server with
> > default settings and patched it using Windows Update site. Also,
installed
> > SQL Server reporting services. During setup, it warned me the Sharepoint
> is
> > installed (I don't know how Sharepoint got installed) and at the end, it
> > failed to initialize reporting services. Now, when I enter
> > "localhost/reports" in address line of IE, I get this error message:
> > The underlying connection was closed: Unable to connect to the remote
> > server.
> >
> > I checked SRM*.log error log and found an error message:
> > <Func Name='Do_Activate_ReportService'>
> > <Func Name='CreateProccessAndWait'>
> > Error reported by child process:
> > Failure starting the web service:
> > 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.
> >
> > <EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
> > Error 1603 Launching RSActivate.exe:
> > C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
> > "C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
> > Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config"
> > Do_Activate_ReportService: Activation Failed!
> > <EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
> > <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> > ---
> >
> > When I execute RSActivate on command line, I get the same error (The
> Report
> > Server Web service has not generated a public key).
> > I played with settings of reporting services installation (service
account
> > and SQL Server user) in hope to get it installed successfully but it
> always
> > fails.
> >
> > Do you have any idea about my problem?
> >
> >
>
Subscribe to:
Posts (Atom)