Home / Questions / 5997
Accepted
The One
Asked: 2020-03-19 08:12:04 +0800 CST 2020-03-19 08:12:04 +0800 CST

Create user $webserver in SQL Server

  • 772

I made a Web Service, it uses windows authentication, and I need it to have permissions in the MSSQL database

There are other databases that have a user "$webserver" added

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

enter image description here

2.- In the pop-up window -> User Type-> I selectWindows user

enter image description here

3.- User Name I select the button and in the pop- up ...window I selectSelect User or GroupLocationsEntire Directory

enter image description here

In the same window, in Object Typesactive all the boxes:

enter image description here

Finally, I write Dominio/$ServerNameand give it inCheck Names

enter image description here

And I get this error:

enter image description here

If I try to give permissions to a file system folder to the server, in Object Types I get this element that does not appear in MSSQL:

enter image description here

And when you click on Check Names, it finds it correctly

enter image description here

Why does the Computers object not appear in the user search box in MSSQL?

The answer to this, I guess, is because MSSQL doesn't want me to add server accounts as users. Because?

How can I give permissions to my WebServer on my database?

sql-server

1 Answers

  1. Best Answer

    Well, just add Domain\ServerName$ in username and login without looking for anything and I gave it OK and it worked.

    enter image description here

    After that, do not forget to give the user permissions on the database

    • 0