Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message -2147165949 when attempting to connect to a Dynamics SL Server in Database Maintenance


Symptoms

Error message Cannot connect via Database Maintenance

-2147165949

↑ Back to the top


Cause

1) The sql server client tools are not installed.

2) The sql server client tools are not installed correctly.
The sqldmo.rll file is not present on the client and so sqldmo.dll did not register
Following is the list of SQL-DMO related DLLs that you need to enable DMO
from a client:
Sqldmo.dll Distributed Management Objects Resource File
Sqldmo.rll
Sqlsvc.dll
Sqlsvc.rll
Sqlwoa.dll
Sqlresld.dll
Sqlwid.dll
W95scm.dll

see "More Information"

↑ Back to the top


Resolution

1) Install the sql server client tools

2) Register Sqldmo.dll manually and make sure that all required file exist
See http://support.microsoft.com/kb/248241.

↑ Back to the top


More Information

The following article contains steps to manually register SQL DMO Clients
http://support.microsoft.com/kb/248241

↑ Back to the top


Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2015572
Revision : 2
Created on : 2/2/2017
Published on : 2/3/2017
Exists online : False
Views : 107