our server administartors want to shutdown the kerberos
service on our servers due to some problems in active
directory. When they do this, I can no longer connect to
the sql servers through enterprise manager from my
machine (login fails) nor does my merge replications
work. I dont know very much about active directory, and I
am not getting answers that I understand from our admins
why we should shut off the kerberos service. However what
I have read, that service handles security! Our admins
also tell me that microsoft says sql server doesent need
kerberos security? (we are using mixed mode,sql server
2000 sp2) Any information on this would be very much
appreciated.
Thanks!
You should be able to use the sa account and its password to logon and do your work.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Larry,
I can understand issues if there is no authentication at all possible on the
network, but there shouldn't be a dependency on Kerberos per se - is NTLM
not running in the absence of Kerberos? Can you use a domain login for
anything else? Kerberos is useful in SQL Server for a double-hop with linked
servers but is not required for replication - SQL Server is supported on NT4
which doesn't have Kerberos and replication works fine there.
HTH,
Paul Ibison
Friday, March 9, 2012
Kerberos and merge replication
Labels:
activedirectory,
administartors,
database,
due,
kerberos,
kerberosservice,
merge,
microsoft,
mysql,
oracle,
replication,
server,
servers,
shutdown,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment