Sharepoint Foundation Error 10016

1. Error 10016 logged in Event Viewer stating that user has no permission for Local Activation.



2. Go to Regedit, locate these folders:
- Computer\HKEY_CLASSES_ROOT\AppID\{61738644-F196-11D0-9953-00C04FD919C1}
- Computer\HKEY_CLASSES_ROOT\AppID\{000C101C-0000-0000-C000-000000000046}

Right-click on the folder and select Permissions. (Repeat Step 2, 3 and 4 for each of the above folder)

3. Add Full Control for the Administrators group then click on Advanced button.

4. Go to Owner tab and replace the owner from TrustedInstaller to Adminstrators or other administrative accounts and press Ok twice to confirm.

5. Run dcomcnfg then go under Component Services -> Computers -> My Computers -> DCOM Config.

Search for IIS WAMREG admin Service and double-click on it.

6. In the Security tab, under Launch and Activation Permissions, select Customize then click on Edit then add the user account to the list if it is not already there.

Ensure Local Launch and Local Activation is ticked.

How to connect to Windows Internal Database instance MICROSOFT##SSEE

Using SQL Management Studio, instead of trying to connect into the instance using: SERVER\MICROSOFT##SSEE

Try using:
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query