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. 4 2543
"Lars Bonnesen" <no***@none.inv alid> wrote in message
news:41******** *************@d text01.news.tel e.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.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.
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.inv alid> wrote in message news:41******** *************@d text01.news.tel e.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.inv alid> wrote in message
news:41******** *************@d text01.news.tel e.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 (I've got the version number from
rpm --query). I want to apply the ImageMagick module so I can make better
use of MoveableType.org's blogger tool.
I've cut/pasted the output from the update - I can see the errors but don't
know how to resolve...
|
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 (Intel X86)
Enterprise Edition on Windows NT 5.0 (Build 2195: )
Problem seems to be some extended procs that seemed to be running fine
|
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:
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en
....it has these 3 files:
|
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 -
rsFZReport.Open sRS, , adOpenStatic, adLockReadOnly, adCmdText
..
..
|
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 I get the
message
"A strong SA password is required for security reasons. Please use
SAPWD switch to supply the same"
Currently the sa password is
Abc/def/ghk1
| |
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.
Scenario: win2003, sql2k sp3a.
Manual log shipping - ftp logs to server, restore in situ.
Looks like the log ftp across ran out of disk space - down to
0bytes...
Never the less it seems to have tried to restore it.
|
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 I can connect to my database anymore. The funny
part is that if I connect to a full MS-SQL Server the program works just
fine. Do I need to change anything in my connection string so I can connect
to MSDE SP3a? Any Ideas of how I can solve this...
|
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 app checks for certain file updates from a web folder at
login time and downloads any component updates that are needed. There are
about 15 files of different types that could be downloaded, including .rtf,
..ppt, .xls, .exe and .mdb extensions.
...
|
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 exceptions.
Turns out that the database had been restored with a different name,
so the connection string (stored in web.config) was amended.
At that point the system failed to display even the login screen - it
failed with the error message shown at...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |