Solved

Problem with Test-SPContentDatabase

Posted on 2011-02-15
4
1,808 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 7

Accepted Solution

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

0
 
LVL 14

Assisted Solution

by:KoenVosters
KoenVosters earned 125 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

728 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