SQL fails after SP3a has been applied. Slammer?

[Lars Bonnesen]

A Win2k, SQL2k machine with SP2 that only just now has been updated to SP3a
fails in different ways. Among other things, when I now start Enterprise
Manager, I get a message saying "rebbrui.rl l" is missing and the snap-in
fails to initiate. But then the Manager starts anyway.

But the SQL application does not work. I searched around the net, and I
found that it looks as if SQL Slammer has been on the server. I can tell by
the similar symptoms other users have had, allthough I am not sure. Anyway,
when I run some online virusscans and the Symantec SQLexp-tool to remove
Slammer, I am told that the system is virusfree. Is that because SP3a to
SQL2000 automatically got rid of the virus (if any)?

But how do I get the SQL to run without any errors again?

The server also runs in Terminal Application Mode.

Regards, Lars.

[Simon Hayes]

Re: SQL fails after SP3a has been applied. Slammer?


"Lars Bonnesen" <noone@none.inv alid> wrote in message
news:41e1ca10$0 $161$edfadb0f@d text01.news.tel e.dk...[color=blue]
>A Win2k, SQL2k machine with SP2 that only just now has been updated to SP3a
> fails in different ways. Among other things, when I now start Enterprise
> Manager, I get a message saying "rebbrui.rl l" is missing and the snap-in
> fails to initiate. But then the Manager starts anyway.
>
> But the SQL application does not work. I searched around the net, and I
> found that it looks as if SQL Slammer has been on the server. I can tell
> by
> the similar symptoms other users have had, allthough I am not sure.
> Anyway,
> when I run some online virusscans and the Symantec SQLexp-tool to remove
> Slammer, I am told that the system is virusfree. Is that because SP3a to
> SQL2000 automatically got rid of the virus (if any)?
>
> But how do I get the SQL to run without any errors again?
>
> The server also runs in Terminal Application Mode.
>
> Regards, Lars.
>[/color]

Based on this post (not many details, unfortunately), Terminal Application
Mode may be a problem:

http://tek-tips.com/viewthread.cfm?qid=732941

The SP3a readme does mention a problem with installing MSDE in Terminal
Services, but not with installing the full MSSQL product. You don't mention
your edition, but since you're using Enterprise Manager, I guess you
probably have Standard or Enterprise.

http://support.microsoft.com/default.aspx?scid=/support/servicepacks/sql/2000/sp3readme.asp#_3467461_prerequisites_for_msde_2000_sp3_d3jb

To fix the missing file error, you'll probably need to reinstall the client
tools, and if you cannot connect to MSSQL at all (what exactly does "the SQL
application does not work" mean?), or the service won't start, then it might
be worth simply uninstalling and reinstalling the whole thing anyway.

Then you can install SP3a, and finally restore or reattach your databases.
If that isn't a good solution for some reason (time, data loss etc.), then
it would probably be a good idea to call MS - support for problems caused by
bugs is free.

Simon

[Lars Bonnesen]

Re: SQL fails after SP3a has been applied. Slammer?


"Simon Hayes" <sql@hayes.ch > wrote in message
news:41e2330d$1 _1@news.bluewin .ch...
[color=blue]
> Based on this post (not many details, unfortunately), Terminal Application
> Mode may be a problem:
>
> http://tek-tips.com/viewthread.cfm?qid=732941[/color]

Did in fact find that URL during my netsearch for a solution. The problem
with that is that "Add/remove programms" assumes you are installing from a
CD - and I have the SP3a patch downloaded on disk. What he thinks about when
saying "change user", I do not understand.
[color=blue]
> The SP3a readme does mention a problem with installing MSDE in Terminal
> Services, but not with installing the full MSSQL product. You don't
> mention your edition, but since you're using Enterprise Manager, I guess
> you probably have Standard or Enterprise.[/color]

Well, it is not "my" installation, but I am pretty sure they run Standard
Edition.
[color=blue]
> http://support.microsoft.com/default..._2000_sp3_d3jb
>
> To fix the missing file error, you'll probably need to reinstall the
> client tools, and if you cannot connect to MSSQL at all (what exactly does
> "the SQL application does not work" mean?),[/color]

That is a third party program, that uses the SQL-thing. It will not work.

Did I BTW mention, that I am able to view the databases through Enterprise
Manager - after getting passed that missing .rll file error?
[color=blue]
> or the service won't start,[/color]

The SQL service does start.
[color=blue]
> then it might be worth simply uninstalling and reinstalling the whole
> thing anyway.[/color]

Yes, perhaps. But I wouldn't rather...
[color=blue]
> Then you can install SP3a, and finally restore or reattach your databases.
> If that isn't a good solution for some reason (time, data loss etc.), then
> it would probably be a good idea to call MS - support for problems caused
> by bugs is free.[/color]

Sure, if it is a bug. The problem is that I am afraid it is because of the
Slammer. (Well which also is a result of a security bug).

Regards, Lars.

[Lars Bonnesen]

Re: SQL fails after SP3a has been applied. Slammer?


"Simon Hayes" <sql@hayes.ch > wrote in message
news:41e2330d$1 _1@news.bluewin .ch...[color=blue]
>
> "Lars Bonnesen" <noone@none.inv alid> wrote in message
> news:41e1ca10$0 $161$edfadb0f@d text01.news.tel e.dk...[/color]
[color=blue]
> http://tek-tips.com/viewthread.cfm?qid=732941
>
> The SP3a readme does mention a problem with installing MSDE in Terminal
> Services, but not with installing the full MSSQL product. You don't
> mention your edition, but since you're using Enterprise Manager, I guess
> you probably have Standard or Enterprise.[/color]

It definatly was because of the above. Apparently SP3a has to be installed
from add/remove when running Terminal Services in app. mode. I wasn't fully
aware of the way to run a program for other than a CD/disc in here, but that
seemed to be no problem at all.

Now the enterprise manager starts without any problems.

Then again, I still have some problems with a web app. that is running on
the server, but this is another story.
[color=blue]
> http://support.microsoft.com/default..._2000_sp3_d3jb
>
> To fix the missing file error, you'll probably need to reinstall the
> client tools, and if you cannot connect to MSSQL at all (what exactly does
> "the SQL application does not work" mean?), or the service won't start,
> then it might be worth simply uninstalling and reinstalling the whole
> thing anyway.[/color]

Perhaps I have to do this if it is the SQL that is causing the problem with
the web app.

Regards, Lars.

[Lars Bonnesen]

Re: SQL fails after SP3a has been applied. Slammer?


"Lars Bonnesen" <noone@none.inv alid> wrote in message
news:41e37ae5$0 $168$edfadb0f@d text01.news.tel e.dk...
[color=blue]
> Now the enterprise manager starts without any problems.
>
> Then again, I still have some problems with a web app. that is running on
> the server, but this is another story.[/color]

Well... a strange thing:

The application that is using the SQL works when I connect via Termina
Service.

But when another user connects to the SQL via Terminal Service with the same
credential, it does not.

The SQLagent seems to be not running. I get "An error 1060 - (The specified
service does not exist as an installed service) occoured ehile performing
this service operation on the SQLServerAgent service".

Now it looks to me as being a Terminal Service error. Am I correct?

Regards, Lars.