[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Problem with Test-SPContentDatabase

Posted on 2011-02-15
4
Medium Priority
?
1,902 Views
Last Modified: 2012-05-15
I am trying to run this Test-SPContentDatabase powershell cmdlet and I am getting error that it cannot open database because login failed. Can you pls help me with the proper syntax and execution procedure? I am running it on my new Sharepoint 2010 environment and the database is on a different server and separate sql instance. What am I doing wrong?
0
Comment
Question by:MisUszatek
4 Comments
 
LVL 7

Accepted Solution

by:
AlMothanaAlOmari earned 500 total points
ID: 34904634
use administrator credential for both sharepoint and SQL server

0
 
LVL 14

Assisted Solution

by:KoenVosters
KoenVosters earned 500 total points
ID: 34904987
Did you run the powershell as an administrator? Does the administrator have the correct rights on the SQL database?
0
 

Author Comment

by:MisUszatek
ID: 34908537
I am logged in as a user who installed the farm (local admin). It is the first time I am suing Powershell. Is there anything else I should do before running this command?
0
 

Expert Comment

by:MarkTX
ID: 37973016
In addition to credential issues - the database must be on the same SQL server as the sharepoint config database.  This was my problem.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question