Wednesday, March 21, 2012

Problems changing the password for the service account in SQL 2000

Jill
What is an acoount MSSQL Server running under?
Is that Windows Auithentication or Mixed?
"Jill" <Jill@.discussions.microsoft.com> wrote in message
news:C2E38E25-6D9F-4B25-A330-CAD4FF6C6AFE@.microsoft.com...
> 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?
> --
> JillWe 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 ne
w
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|||Jill
What is an acoount MSSQL Server running under?
Is that Windows Auithentication or Mixed?
"Jill" <Jill@.discussions.microsoft.com> wrote in message
news:C2E38E25-6D9F-4B25-A330-CAD4FF6C6AFE@.microsoft.com...
> 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

No comments:

Post a Comment