Moving Config database with "psconfig.exe -cmd configdb" is not complete
Posted on 2009-04-11
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:
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