Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Job authentication on dual-NIC VM

Posted on 2014-02-10
6
Medium Priority
?
317 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
5 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
In this article, WatchGuard's Director of Security Strategy and Research Teri Radichel, takes a look at insider threats, the risk they can pose to your organization, and the best ways to defend against them.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses

876 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