Showing posts with label knows. Show all posts
Showing posts with label knows. Show all posts

Tuesday, March 27, 2012

Error installing SQL Server 2000 Developer Edition

Hello, I hope someone knows the answer to this issue. I am trying to install SQL Server 2000 Developer Edition and once I get to the screen that is asking for the SQL Server instance and Login Information I receive the following error when trying to proceed.

(Report Server database is a different version and cannot be used for this installation)

I have installed reporting services 2000 developer edition many times and I have never seen this error.

Are you adding a new Report Server to an existing deployment? If so then you are probably impacted by the Service Pack of the SQL Server instance.

I have seen something like this before but can't recall exactly the resolution. However I do recall I was able to find some documentation on this on the Microsoft site.

Sorry can't be of any more help

|||

I ran into the same problem installing Reporting Services on a new web server and I deleted the Report and ReportTemp databases form the server and then the install went fine.

Friday, February 17, 2012

Error handling?!

Hi
I have the following problem.
When I execute a statement i get an error and my statement stops running
but there is errorhandling.
Does anyone knows why i don't get the print statement?
15 is a wrong number to generate the error.
Thanks, John
DDL:
DECLARE @.intError INTEGER
SELECT CONVERT(VARCHAR, GETDATE(), 15)
SELECT @.intError = @.@.ERROR
IF @.intError != 0
PRINT 'Error occured!'
ELSE
PRINT 'No Error...'
Result:
Server: Msg 281, Level 16, State 1, Line 3
15 is not a valid style number when converting from datetime to a
character string.
Server: Msg 8114, Level 16, State 1, Line 3
Error converting data type datetime to varchar.
========================================
======================
Johnny van Cadsand news ( ) cadsand ! demon ! nl
A computer beat me at chess once.
But, it was no match for me at kick boxing.On Sun, 29 May 2005 11:25:14 -0000, Johnny van Cadsand wrote:

>Hi
>I have the following problem.
>When I execute a statement i get an error and my statement stops running
>but there is errorhandling.
>Does anyone knows why i don't get the print statement?
(snip)
Hi Johnny,
For some errors, SQL Server will immediately terminate the batch. These
will never be catched by your error handling routine.
More information:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo Kornelis wrote :

> On Sun, 29 May 2005 11:25:14 -0000, Johnny van Cadsand wrote:
>
> (snip)
> Hi Johnny,
> For some errors, SQL Server will immediately terminate the batch.
> These will never be catched by your error handling routine.
> More information:
> http://www.sommarskog.se/error-handling-I.html
> http://www.sommarskog.se/error-handling-II.html
> Best, Hugo
Thanks...
Johnny van Cadsand news ( ) cadsand ! demon ! nl