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 |
|
jar21
51 Posts |
 Posted - 2008-10-31 : 11:04:58
|
| my server error log is reporting that almost every single minute there is a failure audit below is the info in the messageLogin failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: x.x.x.x.]I'm not sure how to fix this error - or even find out what is trying to login - does anyone know how i can troubleshoot this error?Enjoy Life This Is Not A Rehearsal. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-31 : 11:23:41
|
| Are you using IIS on this server? If so, then you need to either change the IIS Predefined Security Account in DefaultAppPool to Local System, or adding the user to SQL and giving it rights to the databases your web server apps use. |
 |
|
|
jar21
51 Posts |
Posted - 2008-11-03 : 12:30:14
|
| Yes I'm using IIS will changing it to local system effect anything else on the server?I just want to know how (or if) this will effect anything else, thanks for your help! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-11-05 : 07:04:01
|
| Not as far as I know, do a google search as there are a few articles out there. |
|
|
|
jar21
51 Posts |
Posted - 2008-11-07 : 09:06:57
|
| it looks like a very big security issue to change it to the Local system - can you explain how to add the user to SQL and giving it rights?Enjoy Life This Is Not A Rehearsal. |
|
|
|
|
|
|
server error log failure audit