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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

DSL 2011 FP1 Database Maintenance cannot connect to MS SQL 2008 instances

(0) ShareShare
ReportReport
Posted on by

We are attempting to setup a test environment for Dynamics SL 2011 FP1. Initially, I would like to build it on a Windows 7 Professional 64-bit workstation. MS SQL 2008 SP3 Standard Edition is functioning within parameters on the same machine. A copy of our production application and system databases have been restored to this instance from the backup files on its SQL 2005 Server.

The Database Maintenance launches, but regardless what is provided as the Destination SQL Server Name, or Authentication type, every attempt to Connect yields the same results:

A dialog box pops up immediately indicating: "Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately."

"Value cannot be null. Parameter name: path1."

Details:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentNullException: Value cannot be null.
Parameter name: path1
   at DBBuild.DBBuild.NameOfServer_Leave(Object eventSender, EventArgs eventArgs)
   at System.Windows.Forms.Control.OnLeave(EventArgs e)
   at System.Windows.Forms.ContainerControl.UpdateFocusedControl()


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
9829000
    Assembly Version: 8.0.0.0
    Win32 Version: 8.10.30917.00
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/SL/Applications/SM/9829000.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Microsoft.VisualBasic.Compatibility
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.5420
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic.Compatibility/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.Compatibility.dll
----------------------------------------
soldb
    Assembly Version: 8.0.0.0
    Win32 Version: 8.10.30917.00
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/soldb/8.0.0.0__31bf3856ad364e35/soldb.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Before I rip the entire build out by its roots, I was hoping to get some guidance in troubleshooting this issue. Is this a known issue? Have I missed something in the install?

Thanks,

Dean Athans

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rachel Moore Profile Picture
    on at

    Hi Dean,

    I'm not entirely sure what you mean when you say SQL Server is running within parameters on the machine. Could you clarify that?

    Typically that exact error is seen when the SQL 2012 components are not installed on the machine. However, this is usually only seen when connecting to SQL 2012 with Microsoft Dynamics SL 2011 and 2011 SP1.

    If you go to Control Panel on the machine, do you see the following items installed?

    Microsoft SQL Server 2012 Management Objects

    Microsoft SQL Server 2012 Management Objects (x64)

    Microsoft SQL Server 2012 Native Client

    Microsoft SQL Server CLR Types for SQL Server 2012

    Microsoft SQL Server CLR Types for SQL Server 2012 (x64)

    I thought that these items got installed when SL was installed, but I could be wrong. You may consider installing them from the following link:

    www.microsoft.com/.../details.aspx

    You may also want to check that the protocols are enabled.

    1) Open SQL Server Configuration Manager and ensure that Named Pipes and TCP/IP are enabled under any occurrence of Client Protocols or Protocols for MSSQLSERVER

    2) Go to Start --> Run and type cliconfg. Enabled that TCP/IP and Named Pipes are enabled

    3) If it is a 64 bit machine, browse to C:\Windows\SysWow64 and open cliconfg.exe and ensure here that TCP/IP and Named Pipes are enabled.

  • Community Member Profile Picture
    on at

    Hey Dean, did you ever figure this out?  I am running into the same  issue trying to run DB Maintenance.

  • Community Member Profile Picture
    on at

    Did you ever get this resolved?  I am getting the same error!

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…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans