Solved

General OLE Error 16386

Posted on 2004-09-20
4
1,036 Views
Last Modified: 2008-02-07
Hi all,

I really need help with the SQL Enterprise Manager. I have always been able to connect to all of the Servers. But recently I am not able to connect to a single one of them. Whenever I try to click on a Server I get the message:

“A Connection could not be established to Server X".
Reason: General OLE-Error 16386.
Please Verify SQL Server is running and check your SQL Server registration properties( by right clicking on the server X node) and try again.

I can connect through query analyzer.

Can anyone please help me???

Thanks a lot!
0
Comment
Question by:bhaskarchalla
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 2

Accepted Solution

by:
ngolovin earned 100 total points
ID: 12122303
You can try to reinstall the Client Tools from the MSSQL CD, since it looks like your SQL-DMO object got unregistered.
Enterprise Manager uses SQL-DMO OLE objects to communicate to the Server, whereas Query Analyzer doesn't need them and can work without them.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Tempdb Contention - SQL SERVER 10 37
What is needed to become a DBA? 7 48
database audit for object access 6 38
SQL Job Failed 6 27
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question