Re: Problems changing the password for the service account in SQL 2000
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Mon, 26 Jun 2006 08:52:53 +0300
Jill
What is an acoount MSSQL Server running under?
Is that Windows Auithentication or Mixed?
"Jill" <Jill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C2E38E25-6D9F-4B25-A330-CAD4FF6C6AFE@xxxxxxxxxxxxxxxx
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?
--
Jill
.
- Prev by Date: Re: LINKED server problem..
- Next by Date: Re: Problems changing the password for the service account in SQL
- Previous by thread: Re: LINKED server problem..
- Next by thread: Re: Problems changing the password for the service account in SQL
- Index(es):
Relevant Pages
|
