N
N
NNS2021-03-02 04:19:56
SQL
NNS, 2021-03-02 04:19:56

How to properly set up sql server accounts?

Hello.
In the logs of the sql server, it always writes this error:

Error: 18456, Severity: 14, State: 5.
Login failed for user 'Domain\PC$'. Reason: No login was found that matched the given name. [CUSTOMER: ]

Domain\PC$ is the name of the computer on which the sql server is running.
Installed sql with all default values, then created a service plan that has a "Manage connection" button. If you create a connection the same as created by default, there will be an error "Failed to connect to the server"
603d8ff2e5508035352256.png.
I've read a lot and haven't found anything like it. Namely, why by default sql performs its tasks on behalf of the computer account, and does not let this account itself. And you can't create a computer login.
If you add a domain user login and connect on its behalf, the same error will appear in the logs, indicating the computer user.

Authentication costs mixed603d92aa6a6e0619481652.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question