I made a Web Service, use windows authentication, and I need to have permissions in the MSSQL database
There are other databases that have a user added "$ webserver"
Security / Users / $WebServer
I am trying to add my user in the same way, but no, the user is not found:
1.- Right click on Database - > Security - > Users - > New User
2.- In the pop-up window - > User Type - > I select Windows user
3.- User Name I select the button ... and in the popup window Select User or Group en Locations Select Entire Directory
In the same window, in Object Types active all tables:
Finally, I write Dominio/$ServerName and I give it in Check Names
And I get this error:
If I try to give permissions to a folder of the file system to the server, in Object Types I see this element that does not appear in MSSQL:
And when I hit it in Check Names , it finds it correctly
Why does not the Computers Object appear in the user search box in MSSQL?
The answer to this, I suppose, is because MSSQL does not want you to add server accounts as users. Why?
How can I give my WebServer permissions on my database?
