Solved

Create DSN for server in same forest but different domain

Posted on 2008-10-10
2
297 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 Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
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…
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.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

757 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

22 Experts available now in Live!

Get 1:1 Help Now