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 |
|
montu
Yak Posting Veteran
60 Posts |
 Posted - 2008-01-14 : 21:18:03
|
| Hi Allmay be this is not the right place to put this question but still i am trying.can some there please let me know how authnetication wotks for SQL Services. i mean when we configure SQL Services run under some domain account or local system account where and how it get authenticated that these services can run under particular account. or what rights need to assign to account in order to run SQL Services if that doesn't have sys admin rights or it has to be sys admin. why i am asking this question because i come across problem where SQL Service run under domain account but SQL Agent not. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-14 : 23:32:28
|
| See your other post for this issue. |
 |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-15 : 00:04:54
|
| this sound similar to my other post but it is slightly different what i want to know is suppose servcies are configured to run under domain or local account where and how the whole authentication process held over the network. appreciate if some one can clear my confusion. Thanks for your reply to my other post |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-15 : 23:32:13
|
| Not necessary over network, sql agent connects to sql server with native sql client. |
|
|
|
|
|
|
how authentication works for SQL Services