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:-
Client computers cannot however connect via windows authentication when specifying a username and password:-
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?
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
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
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?