• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

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

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
davidpetersen
Asked:
davidpetersen
  • 2
  • 2
1 Solution
 
Sander StadSysteemontwikkelaar, Database AdministratorCommented:
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
 
davidpetersenAuthor Commented:
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
 
Sander StadSysteemontwikkelaar, Database AdministratorCommented:
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
 
davidpetersenAuthor Commented:
Thanks - will try this tomorrow and let you know.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now