MSSqlServer service and Windows password reset

Hello,
I hope you guys can help me with a problem that I am facing...

I have started the MSSqlServer service and SQLServerAgent services
with a domain username and password.
There are periodic password resets to this user. Security policies
within the company dictate that the password for this domain account
cannot be permenant.

Would there be any way to automatically reset the pwd in these
services instead of manually changing them each time?

ThanksKannan (pv_kannan@.yahoo.com) writes:
> Would there be any way to automatically reset the pwd in these
> services instead of manually changing them each time?

I doubt there is, but since this is not really a MS SQL Server issue,
but rather a generic Windows question, a question to the approriate
newsgroup for Windows.

Personally, I would investigate possibilities to set up the account
so that it only can log in as service or some such, which would permit
unexpirable passwords.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

MSSqlServer service and Windows password reset

Hello,
I hope you guys can help me with a problem that I am facing...
I have started the MSSqlServer service and SQLServerAgent services
with a domain username and password.
There are periodic password resets to this user. Security policies
within the company dictate that the password for this domain account
cannot be permenant.
Would there be any way to automatically reset the pwd in these
services instead of manually changing them each time?
ThanksKannan,
Is there a specific reason why these can't run under
system?
If not, try to shift the responsibility back to the group
with the security requirement. It would be reasonable to
ask that the admin user who changes the password should
also update the password in the services at the same time
(to ensure continuous availability). If this becomes too
onerous for them, perhaps they'll rethink their
application of the policy in this case.
BTW, I don't think services need to be stopped in order to
change the account password (i.e., wouldn't affect
availability). Can anyone else confirm?
...Jeff
>--Original Message--
>Hello,
>I hope you guys can help me with a problem that I am
facing...
>I have started the MSSqlServer service and SQLServerAgent
services
>with a domain username and password.
>There are periodic password resets to this user. Security
policies
>within the company dictate that the password for this
domain account
>cannot be permenant.
>Would there be any way to automatically reset the pwd in
these
>services instead of manually changing them each time?
>Thanks
>.
>

MSSQLSERVER not showing in Services

Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10
Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>
|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another
>
|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>
|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?

MSSQLSERVER not showing in Services

Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
--
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
--
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> > Hello,
> >
> > We just installed SQL Server 2K on a user machine. For some reason,
> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
Services
> > to update the logon password when we change our NT password. First,
what do
> > we need to do to get MSSQLSERVER to show in Services and is there
another
> > way to update the logon password?
> >
> > --
> > Thanks in advance,
> >
> > sck10
> >
> >
>|||Perhaps you only installed the client components?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> Perhaps you installed it as a Named instance instead of a default
> instance. In that case, the
>> service name is MSSQL$InstanceName.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "sck10" <sck10@.online.nospam> wrote in message
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
>> > Hello,
>> >
>> > We just installed SQL Server 2K on a user machine. For some reason,
>> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
> Services
>> > to update the logon password when we change our NT password. First,
> what do
>> > we need to do to get MSSQLSERVER to show in Services and is there
> another
>> > way to update the logon password?
>> >
>> > --
>> > Thanks in advance,
>> >
>> > sck10
>> >
>> >
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?

MSSQLSERVER not showing in Services

Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance.
In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl..
.
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Service
s
> to update the logon password when we change our NT password. First, what
do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another[vbcol=seagreen]
>|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...

> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?

mssqlserver account

What account should run mssqlserver and sqlserveragent.
Should it be a local account or a domain account?
Thanks,
MTI like using a Domain account when there may be multiple servers because it
is easier to share file permissions etc... If there is only one server it
doesn't much matter.. If you wish to use mail integration for SQL Server
you may wish to use multiple domain accounts, since email is connected to
the login account - if you wish to separate the email for each server...
The Domain account should have limited permissions (as doc'd in BOL.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"mt" <miketownsend33@.yahoo.com> wrote in message
news:028601c37775$9fe611c0$a001280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT

mssqlserver account

What account should run mssqlserver and sqlserveragent.
Should it be a local account or a domain account?
Thanks,
MTYou often need a domain account. If SQL Server agent executes a job which fetches a file from
another machine, for instance., Or you want to use SQL Mail, where you need a domain account for the
mail account.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"mt" <miketownsend33@.yahoo.com> wrote in message news:0a7201c37775$a0c993f0$a301280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT

MSSQLSERVER & SQLSERVERAGENT startup account

I'm currently using a domain account that has sysadmin rights; does this
account need to be an administrator unter Window's 2000 server? I'm confused
by everthing I've read.
It's not necessarily required. The following article lists
the necessary rights and permissions:
http://support.microsoft.com/?id=283811
The section on Windows user rights addresses your question.
-Sue
On Tue, 28 Sep 2004 09:41:28 -0700, "Jerrick D.H"
<JerrickDH@.discussions.microsoft.com> wrote:

>I'm currently using a domain account that has sysadmin rights; does this
>account need to be an administrator unter Window's 2000 server? I'm confused
>by everthing I've read.

MSSQLSERVER & SQLSERVERAGENT startup account

I'm currently using a domain account that has sysadmin rights; does this
account need to be an administrator unter Window's 2000 server? I'm confused
by everthing I've read.It's not necessarily required. The following article lists
the necessary rights and permissions:
http://support.microsoft.com/?id=283811
The section on Windows user rights addresses your question.
-Sue
On Tue, 28 Sep 2004 09:41:28 -0700, "Jerrick D.H"
<JerrickDH@.discussions.microsoft.com> wrote:
>I'm currently using a domain account that has sysadmin rights; does this
>account need to be an administrator unter Window's 2000 server? I'm confused
>by everthing I've read.