After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This account:DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
(Cross-posted to microsoft.public.sqlserver.server,
microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
Are you saying that your SQL Server service is running under domain admin
user account? That is bad, that means SQL Server service can do anything
with the domain, which is really needed.
If the SQL Server service has to access something in the domain (say, you
added some extended procedures that require access files on other
computers), you can use a domain account that is only given proper
permission for just that purpose, using a domain admin account is an
overkill and dangerous.
With that said, the change you described should not affect how SQL Server is
accessed, as long as it still runs.
<bntgoogle@.yahoo.com> wrote in message
news:1194626641.221081.264340@.e34g2000pro.googlegr oups.com...
>A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>
|||Have both servers been rebooted since the domain name and password change?
Regards,
Jamie
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>
|||Jamie
No, the SQL servers were not rebooted, a realization I had only after
we backed off and returned to the previous pwd. That seems to the
other likely reason why it breaks after this.
Put another way, my question is whether the username\password for the
account responsible for the server startup needs to be changed
*separately* after having changed the AD user password...
And oh yeah, I certainly know that is a bad user to use. That is why I
need to change it...
B
On Nov 9, 12:02 pm, thejamie <theja...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Have both servers been rebooted since the domain name and password change?
> --
> Regards,
> Jamie
> "bntgoo...@.yahoo.com" wrote:
>
>
>
No comments:
Post a Comment