AD account permissions required to access SQL Server host

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johno - 24 Jan 2008 12:39 GMT

Hi

What permissions are required by an AD account/login to access a SQL Server
host? For example, if my login - [mydomain\myuserid] needs trusted access to
remote databases on the host MYSQLSERVER, does my account require "connect to
machine" access as well as being granted access to the database? Assume that
[mydomain\myuserid] is a restricted account in that it cannot logon
interactively anywhere.

TIA for any feedback and information.

Reply to this Message

Sean McCown - 24 Jan 2008 14:52 GMT

Yeah, windows validates the user before it ever gets to SQL so if you're
logging in with windows auth, then you have to have windows rights on the box
as well.

> Hi
>
[quoted text clipped - 6 lines]
>
> TIA for any feedback and information.

Reply to this Message

Johno - 24 Jan 2008 15:08 GMT

Thanks very much for the quick response

> Yeah, windows validates the user before it ever gets to SQL so if you're
> logging in with windows auth, then you have to have windows rights on the box
[quoted text clipped - 10 lines]
> >
> > TIA for any feedback and information.

Reply to this Message

Sean McCown - 24 Jan 2008 15:14 GMT

Sure thing. Don't forget to mark this thread complete if you're done.

> Thanks very much for the quick response
>
[quoted text clipped - 12 lines]
> > >
> > > TIA for any feedback and information.

Reply to this Message