Solved

Problem with Test-SPContentDatabase

Posted on 2011-02-15
4
1,758 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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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 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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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