asked on Granting permissions on a specific database to the NT AUTHORITY\NETWORKSERVICE?
I can't seem to do this from the Management gui, it doesn't list this object. When I try and type:
1) USE DATABASENAME
2)GRANT UPDATE TO NT AUTHORITY\NETWORKSERVICE
3)GO
It tells me there is a syntax problem. I'm no sql admin, just trying to learn and get this application working the way I need it to. Thanks in advance!
1) USE DATABASENAME
2)GRANT UPDATE TO NT AUTHORITY\NETWORKSERVICE
3)GO
It tells me there is a syntax problem. I'm no sql admin, just trying to learn and get this application working the way I need it to. Thanks in advance!
Microsoft SQL Server 2005Microsoft SQL Server
Last Comment
instaIT
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
2> GRANT UPDATE TO [NT AUHTORITY\NETWORKSERVICE]
3> GO
Changed database context to 'databasename'.
Msg 15151, Level 16, State 1, Server database\instance, Line 2
Cannot find the user 'NT AUHTORITY\NETWORKSERVICE',
you do not have permission.
I have full permission, so why is it not seeing this? I just want to be able to have network services log in and edit the database. This is for a monitoring app.