Solved

General OLE Error 16386

Posted on 2004-09-20
4
1,034 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
point in time restore in SQL server 26 41
MSSQL join different row from other table 14 65
SQL Select Query help 1 34
Checking for column changes SQL 2014 4 17
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

735 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