Solved

Trying to connect to SQL 2005 database from MS Access on a different domain.

Posted on 2008-10-13
6
188 Views
Last Modified: 2013-11-28
I have an Access 2003 front end which connects to a SQL 2005 back end on the same network but on a different domain. I have set the ODBC configuration to connect with SQL server authentication and entered a default login ID but every time I try to retrieve any data from the SQL back end I'm prompted for a password. The data is eventually displayed but the password has to be entered so continuously as to make it unusable. How can I eliminate the need to enter this password constantly?
0
Comment
Question by:davidpetersen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 9

Expert Comment

by:Sander Stad
ID: 22709040
How did you set up the connections from the front-end to the back-end. Did you use linked tables or something?
Have you checked the SQL user credentials, username and password?
0
 

Author Comment

by:davidpetersen
ID: 22709141
Yes sstad I'm using linked tables. As for the credentials, I've used the sa administrator login and password for the SQL database, so this shouldn't be an issue. I can eventually see all the data but I'm constantly being asked for the administrator password - I need to find a way to have Access remember this.
0
 
LVL 9

Accepted Solution

by:
Sander Stad earned 500 total points
ID: 22709198
There are a few solutions to this problem.
  1. Create a linked table and set the option to save the password. http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23360854.html
  2. Try to create a ADO connection to the SQL Server: http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic57266.aspx
0
 

Author Comment

by:davidpetersen
ID: 22709264
Thanks - will try this tomorrow and let you know.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question