confusion between local system account and this account in services log on as

confusion between local system account and this account in services log on as

Post by FR » Fri, 14 Dec 2001 17:40:42



BOL states that the local system account is limited to network
rights,replication,etc.
What is the local system account ?

If i have a server that is a member server of the domain and the server is
logged on with a domain account , is this account the local system account ?
Which user holds the local system account ?

Our n/w guys says its the user who logs on to the system ?

What if no one logs on as when the server has just been restarted and nobody
logs on, the services still do start up . What account do they start up then
?

What replication factors are limited if the services do start with a local
system account ?

Ive set up transactional replication to another server and it seems to work
fine with the SQL Services log on a local system accout but the server is
logged on with a domain account

btw i am using SQL 7 and NT4

Thanks

 
 
 

confusion between local system account and this account in services log on as

Post by Bill Toleman[M » Sat, 15 Dec 2001 06:24:16


Local System Account is basically a built in local Admin account, since it
is a local account it doesn't have any domain rights. If your use this
account for server, sqlAgent, etc it limits it's functionality to access to
the local machine.

Bill Toleman [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

 
 
 

1. Local System Account or Domain Account For SQL Server Service

For SQL Server 2000 Enterprise Edition on Windows 2000 Advanced
Server, should we use the local system account to run the SQL Server
Service, or a Windows domain account?  I understand some of the
benefits of using a domain account for the agent e.g. SQL Mail,
although this is not supported for SQL Server clusters, but am
clueless when it comes to the server service.

Also, are there some security issues with using the local system
account?  Can a stored procedure writer use xp_cmd to do something
nasty, like format C:\ ?  If so, what kind of privs do you need to
give to your domain account?

Thanks in advance for sharing your knowledge!

Ken

2. Dbase III problem

3. Service Account vs. Local System Account

4. Executable SQL from export file? show=y Regular expressions?

5. comparing by first few characters of a string in SQL query???

6. Service Account vs. System Account

7. Help me please!! -newbie-

8. SQLAgent Service receiveing tran replication can start with local system account

9. Changing service account for the Cluster andSQL service account

10. domain accounts vs. local accounts

11. Tasks not running when SQL Executive using local system account

12. Cluster shares and local system account access