?
Solved

SQL Authentication issue between Domains

Posted on 2012-04-12
2
Medium Priority
?
315 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 79

Accepted Solution

by:
arnold earned 1500 total points
ID: 37840499
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Have you ever had a hard drive that you can't boot into, but need to change the registry? Here is the solution! This article guides you through accessing and editing a registry of a non-primary drive. To read registry information on a non-prim…
Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

752 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