Re: Network logon issues

"Quexlia" <Quexlia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18D5E95D-F7A7-4C16-A750-35BDB3260279@xxxxxxxxxxxxxxxx
> Hi,
>
> I hope someone can help on this, as I'm stumped.
>
> We have a Win2k SQL Server on our network that simply cannot log on at the
> moment.
>
> You can log onto the machine itself using the local administrator account,
> but if you try logging onto the domain with any user you get the following
> error:
>
> The system could not log you on because the system's computer account in
its
> primary domain is missing or the password on that account is incorrect.
>
> When logged in on it's local account, it's picking up its static IP
address
> and DNS entries fine by DHCP, and can see the network okay (although you
get
> prompted for login details when trying to access any resource - which
works
> when given). However the network cannot see it. If viewed through
explorer,
> you can see the system in the list of networked machines, but that's as
good
> as it gets. Not irrational as it's not logged onto the network, but it
does
> at least show that it's capable of talking to other machines and yet
failing
> to do so when trying to log on.
>
> Any thoughts anyone? I'm unable to change it to belong to Workgroup rather
> than the domain for some reason, and there's no wizard option with which
to
> force it to run through all of the setup again, which I've found works
before
> in this sort of scenario on 2k pro machines.


It sounds like you're running Active Directory. Don't change it to
Workgroup - you'll get in worse strife.

Disconnect the SQL server from the network, Run ADUC on one of your DCs,
right-click on the Computer account for the dodgy server and click "Reset
Account". Restart the server and reconnect and you should be able to get
going again.

HTH,
Cameron:-)


.

Relevant Pages

  • Re: XP HOME does not work like XP PRO
    ... >>>network (although the other two PC PRSs can see, but not access the PC HOME. ... >>>I have all users and administrators set ut identically on all three machines. ... >server as all my machines are simply plugged into a Netgear ADSL router. ... >BTW is it normal that each machine has an account administrator, ...
    (microsoft.public.windowsxp.network_web)
  • Re: Trusted SQL Connections & NT AUTHORITYNETWORK SERVICE
    ... SYSTEM account in terms of the credentials it uses on the network. ... hitting a SQL Server on the same machine as the web app. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Server trust connection failed in Windows 2003 for ASP.NET
    ... >where to set SQL Server DB permission for machine.config account since it ... >does show in the user list when I tried to add this account to SQL Server new ... >for SQL Server trust connection without impersonation. ... >machine.config for both machines. ...
    (microsoft.public.sqlserver.connect)
  • Re: Question on XP network security
    ... I'm not sure whether you meant adding each and every user account to ... that it gives every user full access to all other machines ACROSS the ... network security. ... > Add each user's domain account to the local administrators group. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: backing up to network share issue.
    ... I guess I was confused by your later text where I read it as if you stated that it would be the Agent account ... Tibor Karaszi, SQL Server MVP ... >> impersonation when it accesses the backup file on behalf of the SQL Server ... >>> As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)