• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1921
  • Last Modified:

Problem with Test-SPContentDatabase

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
MisUszatek
Asked:
MisUszatek
2 Solutions
 
AlMothanaAlOmariCommented:
use administrator credential for both sharepoint and SQL server

0
 
KoenVostersCommented:
Did you run the powershell as an administrator? Does the administrator have the correct rights on the SQL database?
0
 
MisUszatekAuthor Commented:
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
 
MarkTXCommented:
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now