Solved

Moving Config database with "psconfig.exe -cmd configdb" is not complete

Posted on 2009-04-11
5
1,728 Views
Last Modified: 2012-05-06
Dears

Good day. I have moved configuration database from SQL 2000 to 2005 using:

psconfig.exe -cmd configdb -connect -server ruh-003-sql-01 -database SharePoint_Configeration -user "" -password

the database was moved and I took 2000 database offline but now I find error:

SQL Database 'SharePoint_Configeration' on SQL Server instance 'ruh-001-sql-001' not found. Additional error information from SQL Server is included below.

Cannot open database requested in login 'SharePoint_Configeration'. Login fails.

I can access Central Admin links

I get the below when I access "Timer job status "
 
 Unable to connect to database.  Check database connection information and make sure the database server is running.
Troubleshoot issues with Windows SharePoint Services.
 
 
the strange thing also is the farm information:
Farm Information
Version: 12.0.0.6219
Configuration database server: ruh-001-sql-001
Configuration database name: SharePoint_Configeration

when I run configuration wizared it ask me if I want to disconnect from SQL 2005 (ruh-003-sql-01)

ruh-001-sql-001 is the 2000 SQL

Thanks
0
Comment
Question by:MOSS_Lover
[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
  • 2
5 Comments
 
LVL 21

Expert Comment

by:66866
ID: 24129164
Can you revert back to the original configuration? If you can, here are couple of recommendations:
1. Backup your farm using the Sharepoint backup tool
2. Create a new farm using the Sharepoint Technologies Wizard
3. Restore the farm using the Sharepoint restore tool

0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 500 total points
ID: 24135315
The one database that is nearly impossible to move is the configuration database.  You might have to contact Microsoft support to fix this.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 26068896
http://#24135315 is an appropriate answer
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 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