Solved

ODBC Connectivity

Posted on 2011-03-08
2
280 Views
Last Modified: 2012-05-11
I am running Server 2008.  On this server I have two MS Access databases.  On these data bases are several macros that connect to a SQL Server database on another server.  My problem is that I have to give the db users domain admin rights to get the macros to run correctly.  For security reasons I do not want them to have domain admin rights.  Is there another type of user on Server 2008 which would allow the ODBC connectivity to take place without allowing to much user rights?
0
Comment
Question by:submarinerssbn731
2 Comments
 
LVL 11

Accepted Solution

by:
Bruce Smith earned 500 total points
ID: 35075079
This may help you: http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/539d53f0-012a-4ff3-85f8-cb9e88b2acc7/

It seems that the "SQL Server Management Studio" tool may help you here.
0
 

Author Closing Comment

by:submarinerssbn731
ID: 35082675
Worked perfect!!!  Thanks so much!!!
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

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

895 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

15 Experts available now in Live!

Get 1:1 Help Now