I have a win 2003 server which is used as a sql server. When a person that
is not admin tries to open an access database which is also on the same
server that has links to sql table structure they are asked for login info to
server. when they put in their credentials it asks for them again. Everyone
is on the win server and builtin/users and domain users are on the sql server
and the sql database instance. The user is in the everyone group. I have
admin rights but I can not open the database unless I type in administrator
with the appropriate password. How can i unconfused the win server?

"seeker" <seeker@newsgroup> wrote in message
news:43DBA120-39D1-4D57-AEF5-5F657212D6C0@newsgroup

>I have a win 2003 server which is used as a sql server. When a person that
> is not admin tries to open an access database which is also on the same
> server that has links to sql table structure they are asked for login info
> to
> server. when they put in their credentials it asks for them again.
> Everyone
> is on the win server and builtin/users and domain users are on the sql
> server
> and the sql database instance. The user is in the everyone group. I have
> admin rights but I can not open the database unless I type in
> administrator
> with the appropriate password. How can i unconfused the win server?

That's an SQL permission and not a Windows permission. This post would be
more appropriately posted in the SQL newsgroups.

Cross-posted to the following groups. Just check back in the general
newsgroup for responses, unless you want to start a new thread in those
groups.

microsoft.public.sqlserver.security
microsoft.public.sqlserver.server

--
Ace

This posting is provided "AS-IS" with no warranties or guarantees and
confers no rights.

Please reply back to the newsgroup or forum to benefit from collaboration
among responding engineers, and to help others benefit from your resolution.

Ace Fekay, MCT, MCTS Exchange, MCSE, MCSA 2003 & 2000, MCSA Messaging
Microsoft Certified Trainer
aceman@newsgroup
http://twitter.com/acefekay

For urgent issues, you may want to contact Microsoft PSS directly. Please
check http://support.microsoft.com for regional support phone numbers.