I need to run the SharePoint Content Deployment Wizard (2.8) on SP 2010. It tries to read the database "WSS_Content" using my login account but keeps blowing up with this error when it tries to do the Binding to site - please wait:

 Cannot open database "WSS_Content" requested by the login. The login failed.
 Login failed for user 'MYDOMAIN\mylogin_id'.

I'm admin on the box but not sure if I need to add myself to other groups on the box as well. Your help is much appreciated. Thanks.


You probably don't have proper permissions on the SQL side. Add your login as the SQL administrator or grant the permission directly on the databsae WSS_Content, for example db_owner role.

UPDATE: This should help You: Link but You should select "Windows authentication" and YOu should search for Your login name MYDOMAIN\mylogin_id

  • Thanks, zavaz. I think you're right; this article also talks about the same thing: social.technet.microsoft.com/Forums/en-US/sharepointadmin/… Now I need to contact our DBAs and ask them to fix this.
    – Alex C
    Aug 30 '11 at 8:31
  • If this is a standalone installation (not a farm), where SharePoint created the database itself and we've never logged into it directly ourselves, will we be able to connect and add/remove users? Or do we need a farm installation to have that level of control on the database? Thanks.
    – Alex C
    Aug 30 '11 at 8:36
  • 1
    I think You can instal SQL Management Studio Express and connect to the database using account under which SharePoint was installed.
    – zavaz
    Aug 30 '11 at 8:47
  • Thanks, zavaz. How do you find out which account SharePoint was installed under? On Central Admin > Default Database Server, it's blank for the Database Username and Password, meaning it's using Windows authentication instead.
    – Alex C
    Aug 30 '11 at 10:13
  • 1
    That's correct. The best way is to log in to windows as the user ude who YOu instaleld SharePont and then rum SQL management studio to connect to the DB
    – zavaz
    Aug 30 '11 at 10:51

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.