Solved

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

Posted on 2008-10-13
6
182 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
  • 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

808 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