G
geedeearr
Hi All,
I'm trying to sequentially connect to multiple sql servers, both 2000 and
2005, from Access 2003 or 2007. Due to sensitivity of data, in compliance
with "our" imposed version of the Sarbanes-Oxley Act, the group username of
Builtin\Administrators has been removed (disabled actually) from the list of
sysadmins in about 1/4 of our SQLServers. I (we as sql db admins) have 2
username accounts. One for our desktop/day to day usage and an admin username
for db server administration tasks.
We can only access these "locked down" servers by logging into SSMS as SA or
we do have a network account which is used as an SQL services owner that can
also be used.
It is this network account I want to use.
As far as I can tell, there are 2 ways to connect to SQLServer through code
using ADO and Access: a trusted connection using the current logged-in
Windows user ("Integrated Security=SSPI" or "Trusted_Connection=True") or
using standard security (SQL Authentication). It is logistically impossible
to use standard security as each server's SA password is different and I
don't have or want a db table with ALL the passwords. I am also using this
program to ferret out clandestine installs of SQLServer, which means I
wouldn't be able to access that server anyway with standard security. So this
would require me to set up some type of impersonation to be able to log into
a SQLServer. I have not been able to find a way to be able to do that.
Is there a way to use impersonation in Access? and if so, which type library
do I need to reference?
Is there an impersonation method to be able to use SQLServer?
Can I use .NET? again if so, which type library is referenced?
Thank you.
I'm trying to sequentially connect to multiple sql servers, both 2000 and
2005, from Access 2003 or 2007. Due to sensitivity of data, in compliance
with "our" imposed version of the Sarbanes-Oxley Act, the group username of
Builtin\Administrators has been removed (disabled actually) from the list of
sysadmins in about 1/4 of our SQLServers. I (we as sql db admins) have 2
username accounts. One for our desktop/day to day usage and an admin username
for db server administration tasks.
We can only access these "locked down" servers by logging into SSMS as SA or
we do have a network account which is used as an SQL services owner that can
also be used.
It is this network account I want to use.
As far as I can tell, there are 2 ways to connect to SQLServer through code
using ADO and Access: a trusted connection using the current logged-in
Windows user ("Integrated Security=SSPI" or "Trusted_Connection=True") or
using standard security (SQL Authentication). It is logistically impossible
to use standard security as each server's SA password is different and I
don't have or want a db table with ALL the passwords. I am also using this
program to ferret out clandestine installs of SQLServer, which means I
wouldn't be able to access that server anyway with standard security. So this
would require me to set up some type of impersonation to be able to log into
a SQLServer. I have not been able to find a way to be able to do that.
Is there a way to use impersonation in Access? and if so, which type library
do I need to reference?
Is there an impersonation method to be able to use SQLServer?
Can I use .NET? again if so, which type library is referenced?
Thank you.