Solved

General OLE Error 16386

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 45
sql server tables from access 18 19
VB.NET 2008 - SQL Timeout 9 24
return table in table valued function  using dynamic sql, SQlServer 2008r2 5 18
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 …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

810 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