INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

ODBC Connection Across Domains

ODBC Connection Across Domains

(OP)
I have client users on one domain and an SQL Server on another domain.
The clients want to connect to the SQL server with Crystal reports.
I usually set up a .dsn file for the client computers to use as the connection in a common network location.

Clients can connect to the SQL Server via an SQL Server account using the following dsn:-

CODE

[ODBC]
DRIVER=SQL Server Native Client 10.0
UID=mysqlaccount
DATABASE=MySQLServer
WSID=W7NTG1619
APP=Microsoft® Windows® Operating System
SERVER=xx.xx.xx.xx\MYINSTANCE
Description=SQLServer Test 2 

Client computers cannot however connect via windows authentication when specifying a username and password:-

CODE

[ODBC]
DRIVER=SQL Server Native Client 10.0
DATABASE=MySQLServer
WSID=W7NTG1619
APP=Microsoft® Windows® Operating System
Trusted_Connection=Yes
SERVER=xx.xx.xx.xx\MYINSTANCE
Description=remotesql Test 

Crystal reports asks for a username and password when using the second connection ( which is what I want ) but
when I enter MyRemoteDomain\MyRemoteWindowsUser and password I get :-
'SQLState 28000' and 'SQL Server Error 18456'.
There are lots of posts out there on this but none are very clear or specific to my case.

So...
I can connect via an SQL authentication connection across the domains.
I can log on to the remote server and sql server using RDP with MyRemoteDomain\MyRemoteWindowsUser.
I cannot connect to the remote server and sql server using windows authentication with MyRemoteDomain\MyRemoteWindowsUser.

Anybody have any ideas?

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

RE: ODBC Connection Across Domains

Skittle,

I am not sure if this will work but try using the fully qualified domain name of the server (FQDN). I.e, yourserver.yourdomain.com\myinstance.

Good luck!

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA), Training HOTT cert SQL Server 2012 Business Intelligence (SSIS, SSAS).

RE: ODBC Connection Across Domains

Windows accounts are 'confirmed' by Active Directory. Are the accounts in the Active Directory used by the SQL Server server?

Example:
Clients are authenticated through Domain Controller A.
The SQL Server server is on a network that uses Domain Controller B.
Do DCA and DCB 'talk' to each other? Do they get each other's Active Directory entries?

In our system, we have multiple Domain Controllers and they have to replicate between each other so any system on the network will be able to authenticate via Active Directory.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close