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.rll" 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. 4 2534
"Lars Bonnesen" <no***@none.invalid> wrote in message
news:41*********************@dtext01.news.tele.dk. .. 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.rll" 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.
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..._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
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41**********@news.bluewin.ch... Based on this post (not many details, unfortunately), Terminal Application Mode may be a problem:
http://tek-tips.com/viewthread.cfm?qid=732941
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.
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.
Well, it is not "my" installation, but I am pretty sure they run Standard
Edition. 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?),
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?
or the service won't start,
The SQL service does start.
then it might be worth simply uninstalling and reinstalling the whole thing anyway.
Yes, perhaps. But I wouldn't rather...
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.
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.
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41**********@news.bluewin.ch... "Lars Bonnesen" <no***@none.invalid> wrote in message news:41*********************@dtext01.news.tele.dk. ..
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.
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. 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.
Perhaps I have to do this if it is the SQL that is causing the problem with
the web app.
Regards, Lars.
"Lars Bonnesen" <no***@none.invalid> wrote in message
news:41*********************@dtext01.news.tele.dk. .. 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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Randell D. |
last post by:
Folks,
I have a number of years with HP Unix and Linux but I've never dipped my
toes in to Perl - I currently have SuSE 8.1 at home and am using webmin
(www.webmin.com) to update Perl 5.8.0-45...
|
by: WangKhar |
last post by:
Hi
(sorry this has turned into a bit of an epic...thought I'd as the
experts!)
SQL 2k, sp3a. Dual xeon 2.4. 2 gig ram. everything on a 3 disk raid 5.
Microsoft SQL Server 2000 - 8.00.760...
|
by: gregs |
last post by:
Hi folks,
I need to know which EXE's of SP3 to install with SQL Server 2000 Personal
Edition. From the Microsoft website:
...
|
by: pete |
last post by:
Can anyone give me some sugguestions here.
Connection is declared at the start of the application
Set rsFZReport.ActiveConnection = conn
Then a function repeatly opens recordsets like this -
...
|
by: John Morgan |
last post by:
I urgently need tom use SP3a upgrade the instance of SQLServer200
MSDE runing on my local machine but I am having problems in doing so.
My first problem is that when I start the set up procedure...
| |
by: WangKhar |
last post by:
Server: Msg 3443, Level 20, State 1, Line 1
Database 'GAII_Build' (database ID 8) was marked for standby or
read-only use, but has been modified. The RESTORE LOG statement cannot
be performed.
...
|
by: Jesus Carmona |
last post by:
Good day everyone;
I'm having a program for a PocketPC that was working great, this program
connects to a database (MSDE) but when I updated the MSDE to SP3a everything
blew-up... There is no way...
|
by: JDRaven |
last post by:
(also posted under webdevelopment-inetserver-iis newsgroup, not sure which is
most appropriate)
We have a Windows Forms app that has been successfully running for several
months. Part of the...
|
by: teddysnips |
last post by:
I recently had to rebuild an instance of SQL Server. When it was
restarted, one of the client apps (ASP.NET) could not connect - the
user could see the login screen, but it kept throwing...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |