Solved

General OLE Error 16386

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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 …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

929 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now