Re: Problems changing the password for the service account in SQL

Jill
If I change the account running SQL to Local system everyone
can logon. Any idea what is going on?

It is because there is BULTIN\Administrstors Login that alllow access to
everyone who is a memeber of LOCAL Administrators Group

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".

Let me understand you. You have a domaim account group that SQL Server
Services run under (you have a login in SQL Server DOMAIN/blblbla) , so now
you are saying that "no other domain accounts can access SQL" , so I think
you need to add this account to DOMAIN/blblbla group OR create a login for
this domain account in SQL Server






"Jill" <Jill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6A0B3814-AB1A-4836-BC79-FB10B0944D86@xxxxxxxxxxxxxxxx
The account which SQL Server is running under is a Domain account and it
doesn't matter whether MSSQL Server is running Windows Authentication or
mixed security no one using a domain account can logon
--
Jill


"Uri Dimant" wrote:

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





.

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: MSSQL$SBSMONITORING Login to Disabled Account?
    ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
    (microsoft.public.windows.server.sbs)
  • Re: xp_cmdshell issue, local system
    ... So initially I tried to change the login using EM, ... account to the localsystem for SQL Server and the same for agent which worked ... Now when I go and try the same for the agent startup account it ...
    (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)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... >gave that login full access to all SQL DB's. ... >group and rights to all the SQL Server databases. ... >Administrator Server role explicitly. ... >account that is a member of the DBA group and this group ...
    (microsoft.public.sqlserver.security)