Solved

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

Posted on 2009-04-11
5
1,702 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
  • 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

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2010 - migrate MySites to a new server? 5 38
DataTables Form Input issue. 3 53
SharePoint 2013 List with Ratings 6 39
SharePoint Online Security 5 49
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

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

22 Experts available now in Live!

Get 1:1 Help Now