Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2003-05-16 : 06:22:03
|
| Hi everybody,What is the meaning of the "Startup Service Account" option in SQL Server Properties - Security? The book says "In the Startup Services Account section, specify which Windows NT account to use when starting up the SQL Server service.". Could you elaborate on this? |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-16 : 06:25:10
|
| It's the windows nt/2000 account which starts the actual MSSQL service. The same as you can se under "services" in the control panel.You can either use LocalSystem or a local or domain user account. This will be used to check for the permissions of the SQL Server. For example, if you want to read a network drive with xp_cmdshell or something, ther SQL Server service account will have to have access to the folder, and hence must be a domain account. |
 |
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2003-05-16 : 07:59:18
|
Thanks a lot Andraax!  I have 2 accounts Administrator & "Utpal Nandi" on my Windows 2000 Professional system. I believe these are domain accounts, am I right? What is a LocalSystem or a local account? |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-16 : 08:23:55
|
| LocalSystem is a "fake" account which has full access to the local system but nothing else.Every server and workstation (except domain controllers) has their own user database. That's what I call local accounts. The domain accounts are accounts on a domain.You can see where the account belongs when you log in the workstation. If there is no "domain" drop down list or if the domain name is the same as your computer name, then you are using local accounts. |
|
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2003-05-16 : 09:04:54
|
| Thanks a lot again! You have helped me a lot! |
|
|
|
|
|
|
What is the meaning of "Startup Service Account"?