Solved

Problem with Test-SPContentDatabase

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

861 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now