1

when I try to connect to a SharePoint site from Visual Studio 2015 I get an error in the Event Viewer. The user who logged in to WFE server is site collection administrator of the site

Site is connected after I add the login user as db_owner to config database, here why site collection administrator required permissions on config db connect to site through Visual Studio?

screenshot

SQL database login for 'SharePoint_Config_2016' on instance 'SQL2016' failed. Additional error information from SQL Server is included below.

Login failed for user 'domain\med'.

0

As per my knowledge, configuration database maintains list of farm solutions and their deployment status, so in order to deploy farm solution you need access to Configuration database, content database in addition to local admin access on server and farm admin access.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.