ODBC Connection Across Domains

[Skittle]

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:-

[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:-

[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'.

 

[TheBugSlayer]

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).

 

[SQLBill]

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