Solved

SQL Authentication issue between Domains

Posted on 2012-04-12
2
303 Views
Last Modified: 2012-04-14
I have two seperate domains and one of them is in a DMZ.I also am using a Cisco ASA 5510 for my firewall and i have any traffice configured from the DMZ domain to the corp domain. When i try to establish a ODBC connection from the DMZ domain to SQL server in the corp domain. The connection attemp fails with server not found or access denied. If i use the ( \\192.168.10.9\c$)  which is the corp domain SQL server and logon using that domain credential then the ODBC connection works. What is going on.??
0
Comment
Question by:jackelly01
2 Comments
 
LVL 76

Accepted Solution

by:
arnold earned 500 total points
Comment Utility
The SQL connection should go to ip\instance. Your example seems to be a connection to a share, admin share at that.
SQL has two authentication modes, one using Microsoft integrated authentication the other has the SQL login authentication. To use domain 1's credentials to authenticate to SQL on domain 2, there has to be a trust relationship where the credentials would be proxied as well as the SQL logins include a reference to the remote domain.

There is much that is unknown in the setup.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

743 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