Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Connection Across Domains

Status
Not open for further replies.
Skittle

Skittle

ISP
Sep 10, 2002
1,528
US
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'.
 
Sort by date Sort by votes
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).
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
530
dhookom
dhookom
Farrukh hameed
  • Locked
  • Helpful tip
Single Connection string control multiple database connection on case condtion
Replies
1
Views
376
fredericofonseca
fredericofonseca
mrmovie
  • Locked
  • Question
ODBC connection, or other from Linus system using AD account details 2
Replies
2
Views
313
mrmovie
mrmovie
mekohler
  • Locked
  • Question
Steps to Set Up Trusted Connection
Replies
1
Views
449
philhege
philhege
bordway
  • Locked
  • Question
ODBC for remote clients MS SQL
Replies
0
Views
164
bordway
bordway

Part and Inventory Search

Sponsor

Back
Top