Re: run services as domain account

- You should give those SQL Server accounts Log on as a service right (this is given automatically when you perform this via Services MMC). Of course the recommended method is changing accounts via SQL Server Configuration Manager.
- After changing accounts, you should restart SQL Server services
- Be sure that you setup those accounts "Never Expires"

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT



"jason7655" <jason7655@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:29BD7EB1-27BB-4DA5-93EF-EABD13204249@xxxxxxxxxxxxxxxx
This may sound like a networking issue, but I don't believe it is.

We changed the domain on the box that our SQL Server 2000 runs. At the time,
we didn't know that you should do this through the Services MMC. We have
since
learned that you should do it through Enterprise Manager. I have seen the
article from Microsoft about going through and making sure the registry and
other items have proper permissions for those accounts. We went to
Enterprise Manager and put back in the the domain account for both services,
so that
it would make the necessary changes.

Here's the problem. If if the server and agent are running under a local
service account, then users can connect through enterprise manager using
their
windows account. The accounts are setup and they work. If you change the
server and agent to run under the domain account, then they cannot login with
their
windows information. That domain account is configured in SQL Server logins
as well as in windows. We ge the "Login failed for user '(null)'.Reason: Not
associated
with a trusted SQL Server connection. Change the services to run as local
account, that goes away. Problem is that agent jobs fail because of that.

We want to run it as a domain account, so I guess I need to ask does anyone
have any idea why it's doing that?

.

Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Get "credentials not valid" message installing SQL2008 Failver
    ... The user account (domain account) has to be pre-created. ... The network name gets created during the install process. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • SQL services failing on startup
    ... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
    (microsoft.public.sqlserver.server)
  • Re: Connections errors
    ... Jasper Smith (SQL Server MVP) ... accounts and not the NT domain account. ... >> been observing connection errors that we can trace back ...
    (microsoft.public.sqlserver.security)