Solved

SQL Job authentication on dual-NIC VM

Posted on 2014-02-10
6
283 Views
Last Modified: 2014-02-21
I have a Server 2012 R2 VM running SQL 2012. The VM has two NICs, one is NAT to a local domain controller, the other is bridged so I can access the VM from outside the NAT network.

With only the NAT NIC attached, my SQL jobs run fine, with job owners authenticating to the local domain controller.
With both the NAT and bridged NICs attached, my SQL jobs fail with error code 0x54b (The specified domain either does not exist or could not be contacted) SQLSTATE 42000 Error 15404. It appears as though SQL favors the Bridged adapter for authentication when both bridged and NAT adapters are present.

Does anyone know of a way to tell SQL to always authenticate on the NAT adapter, even if the bridged adapter is present?
0
Comment
Question by:athemelis
  • 3
  • 2
6 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 39849880
In the SQL Server Configuration manager is the Named Pipes protocol turned on? If it is turn it off.

And then look at your routing (route print from DOS) and see what the metric is for the NAT adapter compared to the bridged NICs.
0
 

Author Comment

by:athemelis
ID: 39850075
Thank you for the information. In the SQL Server Configuration Manager, I found the following:
- SQL Native Client 11.0 Configuration (32 bit): disabled
- SQL Server Network Configuration: enabled
- SQL Native Client 11.0 Configuration: enabled

I have disabled the bottom two above, is that correct?

route print shows the following output. Please let me know what I should do:

C:\Users\admin>route print
===========================================================================
Interface List
 16...00 0c 29 dd 29 cd ......Intel(R) 82574L Gigabit Network Connection #2
 12...00 0c 29 dd 29 c3 ......Intel(R) 82574L Gigabit Network Connection
  1...........................Software Loopback Interface 1
 14...00 00 00 00 00 00 00 e0 Teredo Tunneling Pseudo-Interface
 15...00 00 00 00 00 00 00 e0 Microsoft ISATAP Adapter #2
 17...00 00 00 00 00 00 00 e0 Microsoft ISATAP Adapter #3
===========================================================================

IPv4 Route Table
===========================================================================
Active Routes:
Network Destination        Netmask          Gateway       Interface  Metric
          0.0.0.0          0.0.0.0    192.168.116.2    192.168.116.4    266
          0.0.0.0          0.0.0.0      10.11.200.1     10.11.202.69     10
      10.11.200.0    255.255.252.0         On-link      10.11.202.69    266
     10.11.202.69  255.255.255.255         On-link      10.11.202.69    266
    10.11.203.255  255.255.255.255         On-link      10.11.202.69    266
        127.0.0.0        255.0.0.0         On-link         127.0.0.1    306
        127.0.0.1  255.255.255.255         On-link         127.0.0.1    306
  127.255.255.255  255.255.255.255         On-link         127.0.0.1    306
    192.168.116.0    255.255.255.0         On-link     192.168.116.4    266
    192.168.116.4  255.255.255.255         On-link     192.168.116.4    266
  192.168.116.255  255.255.255.255         On-link     192.168.116.4    266
        224.0.0.0        240.0.0.0         On-link         127.0.0.1    306
        224.0.0.0        240.0.0.0         On-link     192.168.116.4    266
        224.0.0.0        240.0.0.0         On-link      10.11.202.69    266
  255.255.255.255  255.255.255.255         On-link         127.0.0.1    306
  255.255.255.255  255.255.255.255         On-link     192.168.116.4    266
  255.255.255.255  255.255.255.255         On-link      10.11.202.69    266
===========================================================================
Persistent Routes:
  Network Address          Netmask  Gateway Address  Metric
          0.0.0.0          0.0.0.0    192.168.116.2  Default
===========================================================================

IPv6 Route Table
===========================================================================
Active Routes:
 If Metric Network Destination      Gateway
  1    306 ::1/128                  On-link
 12    266 fe80::/64                On-link
 16    266 fe80::/64                On-link
 15    266 fe80::5efe:192.168.116.4/128
                                    On-link
 16    266 fe80::50a6:6b89:c1ad:ee54/128
                                    On-link
 12    266 fe80::7de7:ea7:2829:a29/128
                                    On-link
  1    306 ff00::/8                 On-link
 12    266 ff00::/8                 On-link
 16    266 ff00::/8                 On-link
===========================================================================
Persistent Routes:
  None
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39850206
This is the SQL 2005 configuration manager, but the 2008 has a similar locations and looks.
SQL ConfigYou want to turn off the Named Pipes like I show in the image.

The native clients are fine being enabled.
0
 

Accepted Solution

by:
athemelis earned 0 total points
ID: 39862687
I was able to resolve the problem using the following article:

http://technet.microsoft.com/en-us/library/cc732472%28v=ws.10%29.aspx

Open the Network Connections folder and view available connections.

Press ALT to display the menu bar, and then on the Advanced menu, click Advanced Settings. The Advanced Settings dialog box opens.

In the Advanced Settings dialog box, on the Adapters and Bindings tab, in the Connections list, click the connection that you want to modify. If you wish to change the order in which your connections are tried, click the up or down arrow buttons to rearrange the order.
0
 

Author Closing Comment

by:athemelis
ID: 39876313
It resolved the problem, I hope it benefits others as well.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now