473,394 Members | 4,034 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Problems running Enterprise Manager and Service Manager

PF
On one of our machines, all of the SQL Server 2000
components except for the main Server component (SQL Server
core) itself were installed (Management tools, etc) a while ago
and everything was running fine. Now I go and add/install the
Server component and then Service Pack 3a.

It seems that Service Manager won't start up (I get an hourglass cursor)
and now I find that Enterprise Manager won't run as well. No error
messages appeared and I don't think I saw anything unusual in
the log file.

However, I can use Enterprise Manager on a different
machine and connect to the database (so the database
itself seems to be running).

Any suggestions as to what the problem might be and how to
fix it? I like to see if I can repair this without having
to do a reinstall.

Thanks.

PF

Jul 20 '05 #1
2 2336
PF (pf****@hotmail.com) writes:
On one of our machines, all of the SQL Server 2000
components except for the main Server component (SQL Server
core) itself were installed (Management tools, etc) a while ago
and everything was running fine. Now I go and add/install the
Server component and then Service Pack 3a.

It seems that Service Manager won't start up (I get an hourglass cursor)
and now I find that Enterprise Manager won't run as well. No error
messages appeared and I don't think I saw anything unusual in
the log file.

However, I can use Enterprise Manager on a different
machine and connect to the database (so the database
itself seems to be running).

Any suggestions as to what the problem might be and how to
fix it? I like to see if I can repair this without having
to do a reinstall.


This sounds like something I ran into on my work machine some time
back. I got the machine from our sysadmin with a cloned standard
setup, which included SQL Server tools and utilities, but not the
server. I installed the server and applied SP3, and then none of
the SQL tools would start. If I attempted to start Query Analyzer,
isqlw.exe would show up in Task Manager, but not getting any CPU
time and the GUI never showed up.

OSQL was even funnier. From the one tool that could connect - ISQL -
I could see that the OSQL created multipled connections to SQL Server
until it finally croaked with an error message.

Since ISQL, which connects through DB-Library, worked, my suspicioun was
that the problem was related to ODBC in some way, I did try to reinstall the
MDAC, but no avail. If you are really dead set on sorting this out without
reinstalling, you could pursue that track.

Myself, I uninstalled all of SQL Server and reinstalled. Since this was
a new machine, this was not of an issue.

You didn't say which OS you had. Mine was Windows XP SP1.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2
[Posted and mailed]

"PF" <pf****@hotmail.com> writes:
On one of our machines, all of the SQL Server 2000
components except for the main Server component (SQL Server
core) itself were installed (Management tools, etc) a while ago
and everything was running fine. Now I go and add/install the
Server component and then Service Pack 3a.

It seems that Service Manager won't start up (I get an hourglass cursor)
and now I find that Enterprise Manager won't run as well. No error
messages appeared and I don't think I saw anything unusual in
the log file.

However, I can use Enterprise Manager on a different
machine and connect to the database (so the database
itself seems to be running).

Any suggestions as to what the problem might be and how to
fix it? I like to see if I can repair this without having
to do a reinstall.

OK, so I brought this up with my contacts with Microsoft, who gave me
two suggestions:

1) Reapply MDAC 2.8. (Which was what I tried myself without success)

2) look at dasetup.log in the winnt directory, the setup log for MDAC.

Whatever, the reason is likely to be a case of mismatched dlls. I was
suggested that you run the Component Checker to find this out as well.

If you still have problems after reapplying the MDAC, post the dasetup.log
file, or mail it to me.
The MDAC and Component Checker are available for download from
www.microsoft.com. Unfortunately, I don't have direct links, but
I seem to recall that they easy to find if you search downloads.
--
Erland Sommarskog, Stockholm, es****@sommarskog.se

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Rafal Zurkowski | last post by:
Hello everybody, Maybe my question is very simple but I can't find answer for it. And without it I can't go on. I have installed SQL 2000 Personal edition on Windows 98. All the setup process ran...
4
by: John Morgan | last post by:
I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP...
2
by: ceadtinneh | last post by:
Folks, We're implementing a software based mirroring solution. This solution requires that the SQL Server service on the target server be stopped while data is being replicated from the source...
2
by: si.downes | last post by:
Using SQL Server 2000 SP3 I'm developing a data warehouse where data will be archived off to a filegroup, this filegroup backed up and the tables in this filegroup truncated to free up space on...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
2
by: Praveen K | last post by:
I have a problem in communicating between the C# and the Excel Interop objects. The problem is something as described below. I use Microsoft Office-XP PIA dll’s as these dll’s were been...
4
by: Fred Nelson | last post by:
Help! I just upgraded MSDE to the latest version on my Windows 2000 server. Everything appears to work fine - the enterprise manager on both the server and on my computer are able to access the...
4
by: Prem | last post by:
I would like to reinstall the enterprise manager of sql server 2000, and i have currently sql server 2000 SP4 installed on it. I googled on it, and read that installation of enterprise manager is...
2
by: Steve | last post by:
Hi guys, I have a test solution (called TP2) which is checked in to a Team Project (also called TP2). The solution contains: * DLL (containing a single test class) * Unit Test project (which...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
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,...
0
jinu1996
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...
0
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...
0
tracyyun
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.