web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SQL Agent Nightmare
Microsoft Dynamics SL (Archived)

SQL Agent Nightmare

(0) ShareShare
ReportReport
Posted on by Laurie Sweeney 577

Installed SQL 2011 and the new Management Reporter.

Months later, noticed that backups were not running via a SQL Server Agent job that had been set up. 

Found this resolution for Bug 23443 below:

After you install Microsoft Dynamics SL 2011 and SQL Server 2008 on the same computer, you notice the SQL Server Agent does not start. You may also see the following error message:

SQLServer Error: 160, Specified driver could not be loaded due to system error 193: (SQL Server Native Client 10.0, C:\Windows\SysWOW64\sqlncli10.dll). [SQLSTATE IM003]

RESOLUTION

Download and install the 64bit SQL Server Native Client. This can be downloaded from the following location:

Microsoft® SQL Server® 2008 R2 Native Client
http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0x409 

 

However, I could not get this download to work due to this error: 

“The system administrator has set policies to prevent this installation”.   

So I had our IT guy assist, and he accidentally uninstalled the SQL Server Agent program under Add/Remove Programs.    The process is still available in services, but now it generates an error 1053 error after timing out.   I suspect that there are some files that have been deleted.

So.....we try to run a repair of the installation using the SQL 2008 DVD.   When it gets to the part where it is supposed to be running the repair, I get:   The credentials you provided for the Integration Services service are invalid. To continue, provide a valid account and password for the Integration Services service.

SQL 2008 SP3 is installed on a Windows Server 2008 box.   We are using the Administrator account.   SQL server was installed in 2010, and I'm assuming that it was installed with the Administrator login, but can't fall on a sword for it. 

We probably need to work backwards to resolve this:

First get SQL Server Agent properly installed.

Then get the 64 bit SQL Native SQL Client Installed. 

There is also a copy of SQL 2005 express installed that is being used by something, perhaps Trend Micro?   We are not sure.

So any hints on how to get beyond the above error messages?

Laurie

*This post is locked for comments

I have the same question (0)
  • Laurie Sweeney Profile Picture
    Laurie Sweeney 577 on at

    I meant that I installed Microsoft Dynamics SL 2011 and the new Management Reporter.

  • Verified answer
    Laurie Sweeney Profile Picture
    Laurie Sweeney 577 on at

    After Installing the new Dynamics product on a 64 bit SQL Server 2008 server (not R2), I noticed that we were no longer getting backups.   Additionally, the SQL Server Agent would not start.  

    SQLServer Error: 160, Specified driver could not be loaded due to system error 193: (SQL Server Native Client 10.0, C:\Windows\SysWOW64\sqlncli10.dll). [SQLSTATE IM003]

    I found the resolution below, however, the link to install the solution, which is the 64 bit SQL Server native client install was not working.    I was getting this message:  “the system administrator has set policies to prevent this installation".    We went through the various solutions to get around this message, and they did not work.   We tried to remove the software for the existing native client, and then the install would act like it could only repair the existing native client product like the native client was still there.   Eventually, we ended up with a Microsoft support call, where the registry had to be edited as follows:  

    ·         We deleted SQL Native Client from the following registry key HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products.

    SQL Server Agent does not start after you install Microsoft Dynamics SL 2011

    View products that this article applies to.

    Confidential Article

    (The information in this article is provided to you in accordance with your Confidentiality Agreement)

    Expand all | Collapse all

    SYMPTOMS

    After you install Microsoft Dynamics SL 2011 and SQL Server 2008 on the same com...

    After you install Microsoft Dynamics SL 2011 and SQL Server 2008 on the same computer, you notice the SQL Server Agent does not start. You may also see the following error message:

    SQLServer Error: 160, Specified driver could not be loaded due to system error 193: (SQL Server Native Client 10.0, C:\Windows\SysWOW64\sqlncli10.dll). [SQLSTATE IM003]

    Back to the top

    CAUSE

    Bug 23443

    Bug 23443

    Back to the top

    RESOLUTION

    Download and install the 64bit SQL Server Native Client. This can be downloaded...

    Download and install the 64bit SQL Server Native Client. This can be downloaded from the following locaiton:

    Microsoft® SQL Server® 2008 R2 Native Client

    go.microsoft.com/fwlink (go.microsoft.com/fwlink)

    Back to the top

    MORE INFORMATION

    The issue does not occur with earlier versions of Microsoft Dynamics SL. The iss...

    The issue does not occur with earlier versions of Microsoft Dynamics SL. The issue also does not occur with SQL Server 2008 R2.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans