Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question

1 Answer

up vote 2 down vote accepted

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

share|improve this answer
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
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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