1

I have installed SharePoint Foundation 2010 Foundation in Single mode. At installation a local db service was created at .\sharepoint and I haven't got permission on the databases to create a database dump from them.

How can I get permission to this database? I have local admin permission on this server.

Improve this question
1

1 Answer 1

Reset to default
0

SharePoint 2010 uses SQL Server Express edition as database server and you can connect to it using SQL Server Express Manage Studio. Connect to database using your admin account or the service account you had provided.
Also refer to this blog post: http://weblogs.asp.net/jevgeni/archive/2010/01/14/connecting-to-sharepoint-foundation-2010-internal-database.aspx

Improve this answer
1
  • I know how I can connect to SQL Server Express, and I can do that. But if I try to do something with WSS_Content (show all table for example) in SQL Managment Studio I get exception. I think at installation SharePoint create db with SQL Server authorization as well
    – Иван Гришин
    Commented Aug 20, 2013 at 10:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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