Linked Server Access 97 Database

Hello,
I have had some problems attaching an Access database (which resides on a
server other then the SQL server in our domain)
If the Access DB is on the SQL server machine there is no problem querying
from other workstations in the domain. If the Access DB is on the Network,
only SA can query the database from other workstations.
The MSSQLServer service is running under a domain account that has access to
everything. I have two question (1) what am I missing to allow anyone to
access this file (2) What account will a job that queries and updates this
Access file run under if it is scheduled?
Thanks,
DanIf the system administrator is the only account that can access the
database, then you haven't configured security by granting database
access and permissions to other roles/users. You can bone up on basic
security concepts by starting here:
http://www.microsoft.com/sql/techinfo/administration/2000/securityWP.asp
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 22 Aug 2003 13:05:14 -0400, "solex" <solex@.nowhere.com> wrote:
>Hello,
>I have had some problems attaching an Access database (which resides on a
>server other then the SQL server in our domain)
>If the Access DB is on the SQL server machine there is no problem querying
>from other workstations in the domain. If the Access DB is on the Network,
>only SA can query the database from other workstations.
>The MSSQLServer service is running under a domain account that has access to
>everything. I have two question (1) what am I missing to allow anyone to
>access this file (2) What account will a job that queries and updates this
>Access file run under if it is scheduled?
>Thanks,
>Dan
>