April 11, 2003 at 7:54 am
I have Enterprise Manager on a remote machine. Each day I select my SQL Server and check my jobs, security, etc. No problem. Today I selected the Server and got the error message:
-----------------------
A connection could not be established to MyServerName.
Reason: General OLE Error 16386
Please verify SQL Server is running and check your SQL Server registration properties.
---------------------------
SQL Server Service and SQL Server Agent Service are both running. The registration hasn't changed. I can connect and do queries with Query Analyzer. I can PING the SQL Server. I just can't connect to it via Enterprise Manager.
Does anyone have any suggestions as to what happened and what I can do to solve this? As I said, it worked fine when I left work yesterday but it's not working today. No one else has 'messed' with my remote machine nor the actual SQL Server. I can use EM on the actual SQL Server just fine.
-SQLBill
April 11, 2003 at 8:33 am
Have you tried zapping the registration on Enterprise Manager and re-creating it?
April 11, 2003 at 11:25 am
Not yet....I wanted to see if I could find out what CAUSED the problem first. I think I may have figured it out. I was loading a third-party tool that uses MSDE. I didn't complete the Install (it failed). Turns out it loaded MSDE and instead of loading a second instance, it 'downgraded' my current instance from MSDE 2000 to MSDE 7. So, I'm going to try uninstalling Enterprise Manager and MSDE and then reinstalling EM.
-sQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply