locked
SCCM 2012 Setup error when setting SQL connection info "Network Path Was Not Found" RRS feed

  • Question

  • Hello.

    I'm facing an issue during CCM 2012 SP1 Beta Setup on step "DB INFORMATION"

      • My lab is set like that:

      1x Front-end WS 2012 rtm "CCM Install on it" (Fresh install = no features installed)

      1x Back-end WS 2012 rtm SQL Server 2012 SP1 (I don't know if this is supported).

      • On the sql Side there is already a first instance with SCVMM 2012 SP1(beta) environment that work well.

      A second dedicated instance is ready for CCM install.

      Named Pipes enabled , TCP/IP Enabled

      Firewall rules for 1433 and 4022 are enabled on the Domain profile ,other profiles are disabled.

      Instance Service is running with a domain account

    • Everything is published in AD (delegations for computer account), Schema Prep already done manually.
    • I'm Able to resolve dns name of the SQL server on the CCM VM and telnet 4022 + 1433 ports.

    • For the finish here is the end of Setup Wizard logs:

    Exception rethrown at [0]:
       à System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
       à System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
       à Microsoft.SystemCenter.ConfigMgr.Setup.CheckSqlAsync.EndInvoke(IAsyncResult result)
       à Microsoft.SystemCenter.ConfigMgr.Setup.DatabasePage.ValidatePage()
       à Microsoft.SystemCenter.ConfigMgr.SetupFramework.WizardForm.ActivatePage(String pageId, Boolean goingNext)
       à System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       à System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       à System.Windows.Controls.Button.OnClick()
       à System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
       à System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       à System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       à System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
       à System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
       à System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       à System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       à System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       à System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
       à System.Windows.Input.InputManager.ProcessStagingArea()
       à System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
       à System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
       à System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
       à System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       à System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       à MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       à MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
       à System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
       à System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)].
    14/12/2012 08:21:06: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database SCCM\master on server SQL001.IT-DEPLOYMENT.LAB.
    14/12/2012 08:21:53: ConfigMgrSetupWizard Error: 1 : Exception message: [Le chemin réseau n’a pas été trouvé.
    ], Exception details: [System.IO.IOException: Le chemin réseau n’a pas été trouvé.


    Server stack trace:
       à Microsoft.Win32.RegistryKey.Win32ErrorStatic(Int32 errorCode, String str)
       à Microsoft.Win32.RegistryKey.OpenRemoteBaseKey(RegistryHive hKey, String machineName)
       à Microsoft.SystemCenter.ConfigMgr.Setup.DatabaseUtility.GetSqlConnection(String databaseName, String serverName, Boolean encrypt)
       à Microsoft.SystemCenter.ConfigMgr.Setup.DatabaseUtility.CheckSqlConnection(String serverName, String instanceName)
       à System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       à System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

    Exception rethrown at [0]:
       à System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
       à System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
       à Microsoft.SystemCenter.ConfigMgr.Setup.CheckSqlAsync.EndInvoke(IAsyncResult result)
       à Microsoft.SystemCenter.ConfigMgr.Setup.DatabasePage.ValidatePage()
       à Microsoft.SystemCenter.ConfigMgr.SetupFramework.WizardForm.ActivatePage(String pageId, Boolean goingNext)
       à System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       à System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       à System.Windows.Controls.Button.OnClick()
       à System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
       à System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       à System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       à System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
       à System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
       à System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       à System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       à System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       à System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
       à System.Windows.Input.InputManager.ProcessStagingArea()
       à System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
       à System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
       à System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
       à System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       à System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       à MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       à MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
       à System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
       à System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)].

    Please help me; I'm driving crazy.


    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization

    Friday, December 14, 2012 7:24 AM

Answers

  • Ok I dont know why but when disabling all Firewall Profiles I got it working...

    Even I if created the firewall rules for TCP Port 1433 and 4022 allowed in inbound request for all Firewall Profiles...I got successfull test with telnet the 1433 ports from the CCM VM .

    It is a network filtering issue


    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization


    Monday, December 17, 2012 2:01 PM

All replies

  • Is your named instance listening on port 1433?


    Jason | http://blog.configmgrftw.com

    Friday, December 14, 2012 1:51 PM
  • Yes. I set it manually like suggested in a tutorial in SQL Management Console in the network services "tcp/ip" options

    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization

    Monday, December 17, 2012 1:29 PM
  • since the SQL and SCCM servers are on different machines, did you add the sccm computer account as a local administrator on the SQL server?
    Monday, December 17, 2012 1:34 PM
  • User Account used for SCCM Setup is sysadmin on SQL Server.

    Computer Account of SCCM server is Local Admin on the SQL Server.

    I tryed with a fresh New Instance SQL 2012 CU3 that I think is better supported scenario than using a SQL 2012 SP1 Instance.

    I set in the SQL Server Configuration Console "SQL network Config"

    Listen All = No

    IP 1 "IPV4 Address" Enabled,Active = Yes

    TCP Dynamic Ports = blank

    TCP Port = 1433

    IP 2 "Loop Back IPV4 address" Enabled,Active = Yes

    TCP Dynamic Ports = blank

    TCP Ports = 1433

    IP 3,4 is equal to IPV6 are sets to Active but Disabled = False

    Named Pipes are also actived

    Is this right ?

    FYI: I also created an ODBC DSN on the CCM server with same credentials and settings as SCCM Setup and everything is working well...


    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization



    Monday, December 17, 2012 1:41 PM
  • Ok I dont know why but when disabling all Firewall Profiles I got it working...

    Even I if created the firewall rules for TCP Port 1433 and 4022 allowed in inbound request for all Firewall Profiles...I got successfull test with telnet the 1433 ports from the CCM VM .

    It is a network filtering issue


    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization


    Monday, December 17, 2012 2:01 PM
  • For non-default instances of SQL Server, you must also allow UDP port 1434 so that the client can locate the correct port number (using the SQL Browser) *and* you must enable unicast responses to multicast traffic through the firewall on the source system (not the SQL Server) because this is how the SQL Browser works.

    http://msdn.microsoft.com/en-us/library/cc646023(SQL.110).aspx

    http://technet.microsoft.com/de-de/library/cc786826(v=ws.10).aspx

    http://msdn.microsoft.com/en-us/library/ms181087(v=SQL.105).aspx


    Jason | http://blog.configmgrftw.com

    Monday, December 17, 2012 4:07 PM
  • No its not working!

    First of all "IN MY LAB environment",the problem was the SQL 2012 SP1 Instance wich is not supported. I open up the ports on the SQL server like suggested in this link(1434/UDP was in the list) :

    http://myitforum.com/myitforumwp/2012/01/11/how-to-open-required-firewall-ports-for-sql-for-configmgr-2012-installation/?goback=%2Egde_3726656_member_88833366

    I set the rules not only for the domain profile but to any profiles of advFirewall...

    Currently my new lab work well but I must disable the Firewall on the SQL Server to get it done...

    I think something more than that ports list blocking the traffic.

    I tried to search on technet what is the real full ports list required cause in AdvFirewall we can't monitor "rules matching"that allow or drop the network traffic.


    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization

    Tuesday, December 18, 2012 6:52 AM
  • Did you also allow "unicast responses to multicast traffic through the firewall on the source system (not the SQL Server)" as stated above?


    Jason | http://blog.configmgrftw.com

    Tuesday, December 18, 2012 5:01 PM
  • Sorry I miss to told you that Firewall was disabled on the Source machine.

    So I think Unicast response to multicast through firewall is an isolated case in my LAB


    Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization

    Monday, December 24, 2012 8:19 AM
  • Opening TCP445 on the SQL server resolved this issue for me.

    The stack trace shows an attempted Remote Registry connection which fails due to TCP445 being blocked. 

    Sunday, June 2, 2013 4:07 AM
  • 3 Steps are neccessary:

    1. Make sure the Windows Firewall Service on the SQL Server is running and set to automatic

    2. Add the SQL EXE as a Program Exception to the Firewall on the SQL Server:

    To add a program exception to the firewall using the Windows Firewall item in Control Panel.

    - On the Exceptions tab of the Windows Firewall item in Control Panel, click Add a program.

    - Browse to the location of the instance of SQL Server that you want to allow through the firewall, for example C:\Program Files\Microsoft SQL Server\MSSQL11.<instance_name>\MSSQL\Binn, select sqlservr.exe, and then click Open

    - Click OK.

    From http://technet.microsoft.com/en-us/library/cc646023.aspx

    3. The last step neccessary, on the SQL Server, is to set File and Printer Sharing "on". When this is off, the following error occurs: "Network Path was not found"

    • Proposed as answer by Kearsing Friday, August 16, 2013 12:31 AM
    • Unproposed as answer by Kearsing Friday, August 16, 2013 12:31 AM
    • Proposed as answer by John Muller Monday, April 28, 2014 9:38 AM
    Friday, July 5, 2013 9:41 AM
  • Opening TCP445 on the SQL server resolved this issue for me.

    The stack trace shows an attempted Remote Registry connection which fails due to TCP445 being blocked. 

    Fixed my issue, thanks.

    MCITP-EA | "Never test how deep the water is with both feet"

    Tuesday, July 16, 2013 9:51 PM
  • I have the same issue here. Simply if I turn off firewall, everything works.

    It takes less than one second to connect to SQL and proceed. If I enable File and Print Sharing rule on SQL server (port 445) it works but it takes more than 10 seconds to connect. I guess this can be performance issue later.

    For some reason SQL server is using port 445 instead of 1433. I already enabled 1433 (and 4022) ports on firewall and allowed sqlservr.exe. Also, netstat -an showing that server is listening on port 1433 and 445 but always using 445.

    In SQL Server Configuration Manager for MSSQLSERVER (default) instance named pipes are disabled so server should not be using port 445. Dynamic ports are disabled and server listen on 1433 port.

    Using Firewall log file on SQL server I noticed that server is dropping 445, 137 and 135 packets.

    Any ideas? I really want to set my lab with firewall enabled :)

    Monday, September 2, 2013 10:29 AM
  • The following is also required.

    1. Open port 49154 (TCP) on SQL Server

    2. Execute 'netsh advfirewall set service type = remoteadmin mode =  enable' in SQL Server


    Director

    Wednesday, March 5, 2014 9:42 PM
  • The following is also required.

    1. Open port 49154 (TCP) on SQL Server

    2. Execute 'netsh advfirewall set service type = remoteadmin mode =  enable' in SQL Server

    Sorry, but where did you get that from? It is not correct at all.

    Jason | http://blog.configmgrftw.com

    Thursday, March 6, 2014 2:22 AM