does sql user need to be an admin?
From: Dan C. (danc@nospam.com)
Date: 12/10/02
- Next message: Dan Guzman: "Re: Error 21776: after transferring databases"
- Previous message: Michael: "How to restrict MSDE service to be made available to local host only"
- Next in thread: Dan Guzman: "Re: does sql user need to be an admin?"
- Reply: Dan Guzman: "Re: does sql user need to be an admin?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dan C." <danc@nospam.com> Date: Mon, 9 Dec 2002 17:35:20 -0800
I have an application that logs onto SQL server using
integrated Windows authentication.
On client machine:
Created an account called "APPUSER" that belongs to
the "Users" group. The application (actually a web app)
uses impersonation to create a database connection using
that account.
On server machine:
Created the same account and also added it to SQL server
with rights to the desired table.
The problem I have is that if that account does not belong
to the "Administrators" group, I get a message that the
user is not a member of a trusted SQL connection. If the
account belongs to the administrators group then
everything works perfectly.
I do not want clients to use an administrative account to
access the database. Does anybody know what I am
missing? "Everyone" has "full control" to the sql server
directory.
Thanks in advance.
Dan
- Next message: Dan Guzman: "Re: Error 21776: after transferring databases"
- Previous message: Michael: "How to restrict MSDE service to be made available to local host only"
- Next in thread: Dan Guzman: "Re: does sql user need to be an admin?"
- Reply: Dan Guzman: "Re: does sql user need to be an admin?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
