Enterprise Manager broken on SQL 2000, how to put back

I uninstalled Veritas Backup Exec 90 from my SQL 2000 server.
Now, none of my SQL "Snap Ins" (SQL Query, Enterprise Manager) work.
SQL appears to be running fine and my SQL applications are working fine too.
How can I put back my SQL Enterprise Manager and SQL Query Analyser?
If I reinstall SQL 2000 will that mess up my installed SQL applications?
Will SQL installer attempt to "repair" things with messing up my installed
databases?
My SQL applications/databases are a bear to reinstall and I don't want to if
I don't have to. Like I said, they are running fine.
Greatful for any help.
RonYou can try to reinstall the SQL Server service pack to start with...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:A7A214E5-B073-4988-8E18-8464F2407483@.microsoft.com...
> I uninstalled Veritas Backup Exec 90 from my SQL 2000 server.
> Now, none of my SQL "Snap Ins" (SQL Query, Enterprise Manager) work.
> SQL appears to be running fine and my SQL applications are working fine too.
> How can I put back my SQL Enterprise Manager and SQL Query Analyser?
> If I reinstall SQL 2000 will that mess up my installed SQL applications?
> Will SQL installer attempt to "repair" things with messing up my installed
> databases?
> My SQL applications/databases are a bear to reinstall and I don't want to if
> I don't have to. Like I said, they are running fine.
> Greatful for any help.
> Ron
>|||Thank you for your response. I tried first to restart the SQL server. Boy,
that was a mistake (of sorts). When the server came back up, none of the SQL
applications were working (although the SQL service had started).
Tried to reinstall SP3 as suggested (thank you) but niether windows
authentication nor the sa account would work.
So, out of desperation I reinstalled Veritas Backupexec 91 for servers. I
rebooted the machine and bingo, the SQL apps could access the SQL databases
again!
But SQL is still broken, in that Enterprise Manager and SQL query will not
run.
I am almost to the point where I am going to try reinstalling SQL.
Will it recognize my existing SQL databases or will I have to reinstall
everything?
The Win 2003 server itself is fine, it's just that SQL is "not all there" it
seems.
Ron
"Ron" wrote:
> I uninstalled Veritas Backup Exec 90 from my SQL 2000 server.
> Now, none of my SQL "Snap Ins" (SQL Query, Enterprise Manager) work.
> SQL appears to be running fine and my SQL applications are working fine too.
> How can I put back my SQL Enterprise Manager and SQL Query Analyser?
> If I reinstall SQL 2000 will that mess up my installed SQL applications?
> Will SQL installer attempt to "repair" things with messing up my installed
> databases?
> My SQL applications/databases are a bear to reinstall and I don't want to if
> I don't have to. Like I said, they are running fine.
> Greatful for any help.
> Ron
>

Enterprise Manager broken on SQL 2000, how to put back

I uninstalled Veritas Backup Exec 90 from my SQL 2000 server.
Now, none of my SQL "Snap Ins" (SQL Query, Enterprise Manager) work.
SQL appears to be running fine and my SQL applications are working fine too.
How can I put back my SQL Enterprise Manager and SQL Query Analyser?
If I reinstall SQL 2000 will that mess up my installed SQL applications?
Will SQL installer attempt to "repair" things with messing up my installed
databases?
My SQL applications/databases are a bear to reinstall and I don't want to if
I don't have to. Like I said, they are running fine.
Greatful for any help.
Ron
You can try to reinstall the SQL Server service pack to start with...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:A7A214E5-B073-4988-8E18-8464F2407483@.microsoft.com...
> I uninstalled Veritas Backup Exec 90 from my SQL 2000 server.
> Now, none of my SQL "Snap Ins" (SQL Query, Enterprise Manager) work.
> SQL appears to be running fine and my SQL applications are working fine too.
> How can I put back my SQL Enterprise Manager and SQL Query Analyser?
> If I reinstall SQL 2000 will that mess up my installed SQL applications?
> Will SQL installer attempt to "repair" things with messing up my installed
> databases?
> My SQL applications/databases are a bear to reinstall and I don't want to if
> I don't have to. Like I said, they are running fine.
> Greatful for any help.
> Ron
>
|||Thank you for your response. I tried first to restart the SQL server. Boy,
that was a mistake (of sorts). When the server came back up, none of the SQL
applications were working (although the SQL service had started).
Tried to reinstall SP3 as suggested (thank you) but niether windows
authentication nor the sa account would work.
So, out of desperation I reinstalled Veritas Backupexec 91 for servers. I
rebooted the machine and bingo, the SQL apps could access the SQL databases
again!
But SQL is still broken, in that Enterprise Manager and SQL query will not
run.
I am almost to the point where I am going to try reinstalling SQL.
Will it recognize my existing SQL databases or will I have to reinstall
everything?
The Win 2003 server itself is fine, it's just that SQL is "not all there" it
seems.
Ron
"Ron" wrote:

> I uninstalled Veritas Backup Exec 90 from my SQL 2000 server.
> Now, none of my SQL "Snap Ins" (SQL Query, Enterprise Manager) work.
> SQL appears to be running fine and my SQL applications are working fine too.
> How can I put back my SQL Enterprise Manager and SQL Query Analyser?
> If I reinstall SQL 2000 will that mess up my installed SQL applications?
> Will SQL installer attempt to "repair" things with messing up my installed
> databases?
> My SQL applications/databases are a bear to reinstall and I don't want to if
> I don't have to. Like I said, they are running fine.
> Greatful for any help.
> Ron
>

Enterprise Manager appears to slow my dial up connection

I am using a dial up connection to the Internet and to an online SQL
Server database.

I have a problem in that when I use Enterprise Manager to access even
my local server , or even, it appears, when it is just open with no
connection to any SQL Server, I experience very slow data transfer
over my normal dial up connection.

I am reasonably sure it is Enterprise Manager causing the problem as
when I close it and redial I have an acceptable rate of data transfer
using my dial up connection.

Can anyone:

a. support my conclusion that Enterprise Manager is the probable
cause of the slow connection.

b. suggest a solution

Best wishes, John MorganJohn Morgan (jfm@.XXwoodlander.co.uk) writes:
> I am using a dial up connection to the Internet and to an online SQL
> Server database.
> I have a problem in that when I use Enterprise Manager to access even
> my local server , or even, it appears, when it is just open with no
> connection to any SQL Server, I experience very slow data transfer
> over my normal dial up connection.
> I am reasonably sure it is Enterprise Manager causing the problem as
> when I close it and redial I have an acceptable rate of data transfer
> using my dial up connection.
> Can anyone:
> a. support my conclusion that Enterprise Manager is the probable
> cause of the slow connection.
> b. suggest a solution

I don't have a configuration that I easily can test from, but I have a
guess that you could try: for all your remote servers, right-click and
pick Edit SQL Server Registration Properties and uncheck "Display server
state in console".

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp