If you have one domain of application servers running win2000 and seperate
user domains with no trust relationships accessing sql databases on the
application domain what needs to be done rights wise and is this possible
without connectivity issues. Currently these servers are standalone not in
a
domain and users can currenlty access this through local logon sql rights on
the stand alone servers. Thanks.If there is no domain trust then you will either need to use SQL
authentication or create NT accounts on the SQL Server machines that mirror
the accounts that the users logon to their client machines with. The
accounts will have to have the same name and password. Using this method
you can use NT authentication to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
Friday, March 23, 2012
odbc connection multi domain no trust
Labels:
accessing,
application,
connection,
database,
databases,
domain,
domains,
microsoft,
multi,
mysql,
odbc,
oracle,
relationships,
running,
seperateuser,
server,
servers,
sql,
trust,
win2000
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment