October 10, 2002 at 9:59 am
We recently added some new user profiles to Windows 2000 computer. After having done that our Enterprise Manager started having problems connecting to our databases. The error we are getting is OLE Error 16386.
We are still able to connect to the databases vis Query Analyzer.
Any suggestions?
October 10, 2002 at 11:56 am
Had this error a few months ago....
Here's what I found, and it worked for me...
sql server enterprise manager general ole error 16386
solution:
a. Stop all SQL Server services (MSSQLServer, SQLServerAgent, MSSEARCH)
b. Open command prompt and go to the Program Files\Microsoft SQL
Server\80\Tools\Binn directory
c. Unregistered the following .dll files (Ex. regsvr32 /u dtsui.dll): dtsui.dll,
sqlns.dll, sqldmo.dll, sqllex.dll, sqlmmc.dll
d. Copy and paste the .dll files from a CD (under x86\Binn directory) to the Program
Files\Microsoft SQL Server\80\Tools\Binn
e. Register the .dll files (Ex. regsvr32 sqldmo.dll)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply