Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 905
  • Last Modified:

"Error 22528: [SQL-DMO]" SQL Server Connection Broken

I have installed SQL server 2000 on my laptop (local). When I use Enterprise Manager to open the server I get the error message:
"Error 22528: [SQL-DMO]This server connection has been unexpectedly broken and cannot be reconnected".
Service Manager starts the server fine and VB6 applications have full access to the databases?

Connection to another SQL server goes without any problems.

Tried Uninstalling, clearing out the registry and reinstalling.

What is happening???

Running XP Professional.
0
Mike Reynolds
Asked:
Mike Reynolds
  • 2
1 Solution
 
jdlambert1Commented:
Weird. Have you had the 120 trial version on this laptop? If so, perhaps you missed something in the registry.
0
 
Mike ReynoldsAuthor Commented:
No, only the full Developers SQL Server Installation has been carried out. Further information, when I try to install SP3 I get through to the part of the install when 11 scripts have to run. Then it also fails..

Managed to workaround for now by using my desktop as a server (new installation of SQL server went without a problem) so problem is not urgent. Enetrprise Manage from the laptop connect to the desktop without problems.
0
 
Mike ReynoldsAuthor Commented:
Problem was eventually solved by installing the latest version of MDAC (2.8).
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now