June 6, 2011 at 11:10 am
I'm developing a web app running on a domain created on Win Server 2003 and SQL Server 2008. I created my user 'webuser' and gave access to the db alright. But even with that I get the error 'login failed for user "Webuser"'. I added the login for user IUSR_domain to the DB but still get the error. Researching I found that I need to add the 'NETWORK SERVICE' user also, but when I try I get an error 'Windows NT user or group "domain\NETWORK SERVICE" not found. (Error: 15401)'
I selected it from the list provided, so how come it does not exist?
Any help woud be greatly appreciated.
June 7, 2011 at 3:00 am
I'm not 100% sure of your question but the network service belongs to the local machine so its domain will be the server name. It's a local service.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 7, 2011 at 9:43 am
Found an answer
sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'
😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply