1

Topic: User MSSQLSERVER. Where it?

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
At the folders created at setting MSSQL is of resolution for user MSSQLSERVER.
If I want to add to other folders of this user I do not see it.
Why?

2

Re: User MSSQLSERVER. Where it?

Current of show "its Ishu"

wrote:

If I want to add to other folders of this user I do not see it.

Because it is service, and yes, cannot select/find smile To you  ?

3

Re: User MSSQLSERVER. Where it?

wrote:

If to rewrite without errors a name and to search in the local computer - is

Did not understand. How to find? In the list of users it misses.

4

Re: User MSSQLSERVER. Where it?

wrote:

Slon747;
Strange, at me is present, if through  to search on the local computer - finds.

Able to see that at you

5

Re: User MSSQLSERVER. Where it?

wrote:

TaPaK;
[A computer name] \SQLServerMSSQLUser $ [] $ [a name ]

Well indeed "to rewrite without errors a name" and MSSQLSERVER at anybody

6

Re: User MSSQLSERVER. Where it?

Slon747 wrote:

did not understand. How to find? In the list of users it misses.

Hands to hammer.
Each service has an account nt service\service_name.
Find a service name in services (mssql$sql_2012_dev)
With hands before it hammer nt service \, well i.e. that became nt service\mssql$sql_2012_dev
Check Names - all is
see attachment

7

Re: User MSSQLSERVER. Where it?

Slon747 wrote:

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
At the folders created at setting MSSQL is of resolution for user MSSQLSERVER.
If I want to add to other folders of this user I do not see it.
Why?

For  (not named)  the user is called nt service\MSSQLSERVER (so, with a gap and in flocks), and to search for it it is necessary not at domain level, and at level of the local computer.
The virtual user of the agent is called nt service\sqlserveragent

8

Re: User MSSQLSERVER. Where it?

Question on a subject.
How  nt service\MSSQLSERVER to give access on what that to a full-sphere? After all the remote computer knows nothing about it...

9

Re: User MSSQLSERVER. Where it?

odisssey wrote:

a question on a subject.
How  nt service\MSSQLSERVER to give access on what that to a full-sphere? After all the remote computer knows nothing about it...

Nt service, , it is represented the computer, therefore on a full-sphere it is necessary to give to the computer login account in AD.