ODBC : How to access to a server on another domain?

[dicolas]

Hello, I would like to know if it's posible to define a Data Source Name (through ODBC) for reach a server on another domain than current mine.

On this far domain, I've created a NT & SQL login with all grant access.

With my ODBC administrator, I've put the \\IP address of the remote server and with SQL the authentification the DOMAIN\login and password I've had created.

Issue : It doesn't work - Connection failed & SQL Server does not exist or access denied message.

Is it possible (I think so because I succeeded to register the server with SQL Enterprise Manager)? What did I forget ?

Thanks to all

 

[JJayUK]

I think the problem here isn't SQL but NT. Try just using SQL access.

If you're using NT trusted access the ODBC will try to connect using the user account of the domain you're currently logged in to. User accounts are exclusive to domains and the problem here may be that it simply doesn't exist in the other domain.

You need to make sure both domains can accept that account. Regards,
JJayUK

 

[dicolas]

Effectively, once the account is accepted by both domains, it works fine.

Good job JJayUK & great thanks.