[Webinar] Streamline your web hosting managementRegister Today

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

MS Access 2007 connect to SQL Server 2005

Hi Everyone!

I have multiple SQL Server Instances, I am trying to write a simple Access App that I can use regularly to collect some information about these instances.  The problem I'm facing is connecting; I have 2 LAN Id's, one being 'me' and the other 'me.admin'.  'me.admin' has access to query the SQL servers and get the data I need, but 'me' does not.  The obvious solution would be to log out of the network, and then login with 'me.admin' to build/run my reporting tool, but that sure would be a pain, is there any other way that I can accomplish this when the SQL Servers use only Windows Authentication? Unfortunately giving 'me' appropriate SQL access is not an option, is it possible to specify, or prompt for windows credentials to feed the DSN or Connection String?

1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There are some methods of impersonating other users for the purpose of actions like installing programs (i.e. RUNAS) but none that I'm aware of which would allow you to impersonate someone in order to log into a SQL Server. Unless they'll set the system up such that you can use SQL Authentication, then you're out of luck on this one I believe.

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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