Re: Problems changing the password for the service account in SQL 2000
- From: Ed Enstrom <nospam@xxxxxxxxxxx>
- Date: Tue, 27 Jun 2006 18:33:06 -0400
Jill wrote:
We are currently in the process of Moving all our SQL Server 2000 servers from Windows 2000 using NT security over to Window2003 using Activity Directory. We have migrated the Service account and password over to the new domain and have installed SQL Server successfully using this account. We have now testing changing the password. We changed the password on the domain controller and then in SQL Server and now the only accounts which can connect to SQL Server are the domain account running SQL Server and SQL Server accounts. No other domain accounts can access SQL. The following is the error which we get " A connection couldn't be established. Reason: login failed for user (NULL) Reason: not associated with a trusted SQL Server connection". If I change the account running SQL to Local system everyone can logon. Any idea what is going on?
Some ideas:
You refer to "the new domain". If the accounts that cannot log in are in a different domain, check the trusts between the domains.
Do you have NTLM authentication disabled? If so, SQL Server will try to use Kerberos. Make sure that TCP/IP is enabled on the server and that the client is using TCP/IP protocol to use Kerberos.
Check that the service principle name is entered into Active Directory. SQL Server should do this automatically when it starts. Check the event log.
.
- Prev by Date: Re: Session Variables and Triggers
- Next by Date: Re: sql2k5 security
- Previous by thread: Re: Problems changing the password for the service account in SQL
- Next by thread: Re: SQL 2005 - Searching Encrypted SSN
- Index(es):
Relevant Pages
|
