Solved

Create DSN for server in same forest but different domain

Posted on 2008-10-10
2
301 Views
Last Modified: 2012-05-05
I have an Access front end to a SQL server database that I am distibuting to users in two domains within our forrest, along with a file DSN to enable the Access app to connect to the server. Users that are in the same domain as the server can use the application without any problem. Users in the other domain report ODBC errors. I have VPNed into their machines and tried to set up system DSNs 'manually'. When I do, I get to the dropdown box that shows the list of servers and they can only see the servers withing their domain. I get this on all the machines I have looked at so i assume it's not a probblem local to their individual machines.

How can I create a DSN that will  work accross domains?
is there another way of connecting the Access app to the server?
0
Comment
Question by:Blim2
2 Comments
 
LVL 13

Accepted Solution

by:
adraughn earned 250 total points
ID: 22688590
when you create the dsn connection, use the server IP address instead of the server name. You will also need to change the connection string property on any pass thru queries you may have.
0
 

Author Comment

by:Blim2
ID: 22728930
In fact there were permissions issues as well, but using the IP address looks like a better oprion.
Thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now