MS Access Connection To SQL - Cross Domain.

I have users from A domain using Microsoft Access connecting to SQL 2005 database on a B domain. It always prompts for the credential whenever user making the connection, is there a way in MS Access we can provide statically the credential, so users won't have to type in! They are very impatient! Thanks.
ITBoyAsked:
Who is Participating?
 
G GodwinConnect With a Mentor Database AdministratorCommented:
You could set up an ODBC dsn on the PC with a SQL login's name and password.  Then use this to configure MS Access connections.
-G
0
 
Reen_SCommented:
If you set up the ODBC dsn and then use this to link to the tables in SQL, the connection details are stored in the details of the linked table.
No further ODBC set up is required for other users who get a copy of the front-end.
0
 
ITBoyAuthor Commented:
My database admin actually configured ODBC like both GDG_DBA adn Reen_S but still, everytime they logoff or reboot the computer, they have to put in credentials again. This is for users from other domain. I heard that the wasy Microsoft is, because it comes in from another domain, it always prompt for credential when first try to connect. Is that right? Thanks.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
G GodwinDatabase AdministratorCommented:
That could be, if you don't have a trust relationship set up between the two domains.
-G
0
 
ITBoyAuthor Commented:
Yes, we setup Trust between two domain, but only one way trust. We have to open ports on the firewall to allow each workstations to access our resources from another domain.
0
 
G GodwinDatabase AdministratorCommented:
Sorry I can't be of more help.  
-G
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.