all groups > sql server programming > january 2006 >
You're in the

sql server programming

group:

service account


service account Mahesh
1/8/2006 11:39:02 PM
sql server programming:
i am starting my sql server and agent with a domain account

for eg domain/user..

Is this account should be present in sql server logins...?
what problem i will face if i remove this login?
i have removed this account but everything seems to be ok...
please help

Re: service account Jens
1/9/2006 12:02:11 AM
"Is this account should be present in sql server logins...? "

No, this is just the account for the service to start.

"What problem i will face if i remove this login? "

-Serious problems, because, if you try to restart the sql server
service, it won=B4t start.

"i have removed this account but everything seems to be ok... "

Seems, that you didnt restart the service :-) Everything will run fine
UNTIL you restart the service or aquire additional ressources from the
network, e.g. backing up to a network share.

HTH, jens Suessmeyer.
Re: service account Mahesh
1/9/2006 12:51:02 AM
What i wanted to know can i remove this account from SQL Server Logins
without any issuses?

[quoted text, click to view]
Re: service account Jens
1/9/2006 12:58:02 AM
We can=B4t tell you that, maybe another process from another server or
some program is using the login to do some stuff. If you have somebody
being responsible for the lohin, ask him.

HTH, Jens Suessmeyer.
Re: service account Jens
1/9/2006 1:00:09 AM
We can=B4t tell you that. Perhaps you are using this login in another
process from another server and/or application. Best would be to ask
the responsible for the account if somebody aquired the use for some
work.

HTH, jens Suessmeyer.
Re: service account Jens
1/9/2006 1:05:35 AM
We can=B4t tell you that. Perhaps you are using this login in another
process from another server and/or application. Best would be to ask
the responsible for the account if somebody aquired the use for some
work.

HTH, jens Suessmeyer.
Re: service account Mahesh
1/9/2006 1:21:02 AM
The Service Account is not used in application..It is only for starting Sql
Server.
Can we remove this from SQL Server Login list?

[quoted text, click to view]
Re: service account Jens
1/9/2006 1:23:40 AM
Then you are free to delete it.

HTH, Jens Suessmeyer.
AddThis Social Bookmark Button