November 19, 2018 at 11:32 am
AFter googling how to give permission to SQL to a folder, I found this possible solution:
add the user of mssql (to be found in logon in the SQL Server Configuration Manager to the folder permission through security tab.
I had to stop the instance from running in orde to be able to add the user, otherwise I could'nt not see it in the list of users /groups.
aftter giving the MSSQL$TESTSERVER full control on the folder, thinking the MSSQL$TESTSERVER is still in the permission list with others, now it's been replaced by a long number: starting with: Account Uknown (S-............................. ) ..
How to solve this issue so that the MSSQL$TESTSERVER keeps having acces to the folder?
To add some info: I have one server (connect to it through RDP) where the SQL 2016 express edition server is installed on, OS is windows server 2016 standard.
November 19, 2018 at 12:36 pm
So, I'm presuming when SQL Express was installed, you didn't specify the service account, in which case the installer would've created the account. As for why you didn't see it in Users / Groups, it's a hidden system account.
Potentially, by adding an account with the same name, you may have caused more problems.
What you should've done to add the account, is when in the Security tab of the folder, add NT Service\MSSQL and then hit the "Check Names" button, and it should've filled in the name (likely something like NT SERVICE\MSSQL$TESTSERVER)
As for the long string of characters you're seeing, that's the SID of one of the accounts.
My suggestion?
Try removing the account you added, both from the folder permissions and the User / Groups list, then try adding the service account to the folder permissions as I outlined above.
November 19, 2018 at 1:12 pm
Will give it a try, and I don't remember anymore what I selected during install of SQL epress,
in user/groups there is an account made by SQL that is has the same name as the instance with a number 01 02 untill 20 , 20 accounts.. .
Local user account for execution of R schripts in SQL Server instance TESTSERVER.
Hope I can get rid of this too?
After checking the groups there I find:
SQLRUserGroupTESTSERVER , in properties I find the 20 accounts in there, if I click detelt it warns me and I can loos ... .
same for another group: SQLSERVER2005SQLBROWSERUser$NS... (that's my server name).
when I check here the properties there is one member: NT SERVICE\SQLBrowser (S-1-5-80- ... )
Is it safe to delete the users groups ? Just to be sure..
November 19, 2018 at 1:45 pm
I did not deleted the users in users/group, as I understood only to delete the user I made, I only deleted the long ID n umber in thr permission folder, added the NT Serv . as you told and had 3 results, and added the user that is also used in the instance logon tab .
I'm afraid, that when I start the instance back, that again the account goes and a number comes in the place... .
November 19, 2018 at 2:15 pm
Thanks, your steps did the job.
So it means every folder needs the MSSQL$ user if the database want to be able to connect...hmm.
I have another folder that is now buzzy to add on every subfolder, file the permission but evrytime there is a bak file (extension bak) , it stops and says:
an error occured while applying security information to: C:\ ...... .bak.
Failed to enumerate objects in the container. Access is denied.
Strange if even telling to windows to add a user acces to files , it blocks these bak files ... .
Issue is there are a lot of subfolders in the folder I'm giving permission, this means I have to sit and click continue everytime a bak file appears... .
Is there another faster way to add the MSSQL$ user? hmmm, it's a lot of data in that folder... .
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply