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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

G GodwinDatabase 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.