I have a user that is a local user on a machine. Is it possible that it coul
d
access SQL server on another machine, if they are both under the same domain
.
E.g.
User1 is on Box1
SQL Server is on Box2
Box1 and Box2 are both part of the Boxes domain.
Can I give User1 permission to access to a database on the Box2 SQL Server
without actually making User1 part of the Boxes domain as a user on its doma
inDoes this local user in Box1 has a valid domain user login in the Boxes
domain?
Anith|||No. User1 is only a user in Box1
"Anith Sen" wrote:
> Does this local user in Box1 has a valid domain user login in the Boxes
> domain?
> --
> Anith
>
>|||If it is not a valid domain user, then you have to use SQL Server
authentication.
AMB
"DBA" wrote:
> I have a user that is a local user on a machine. Is it possible that it co
uld
> access SQL server on another machine, if they are both under the same doma
in.
> E.g.
> User1 is on Box1
> SQL Server is on Box2
> Box1 and Box2 are both part of the Boxes domain.
> Can I give User1 permission to access to a database on the Box2 SQL Server
> without actually making User1 part of the Boxes domain as a user on its domain[/co
lor]|||In that case, you cannot use windows authentication in SQL Server, use SQL
Server authentication with a valid SQL login and password instead.
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment