Cannot access recovered SQL databases from sharepoint

You need to set up your SP farm (WFE and Apps servers) to point to the new SQL backend, but this is complicated by the fact that most of the configuration settings for Sharepoint are themselves stored in an SQL DB (the Config DB) so first you need to get to a state that you can access that.
   
Can you run the Sharepoint Configuration Wizard and use it to change the SQL connection settings?
Can you even get into Sharepoint central admin?

I would assume not, so here are some resources that should help you sort this out.  You do not need to create any new Sharepoint WFE so ignore anything about settting up a new WFE etc, you simply need to reattach first the config DB and from that you can reattach your web apps and reset your service applications to use the new SQL back end.

http://www.egroup-us.com/2011/04/sharepoint-how-to-move-databases-to-a-different-sql-server-or-instance/

http://technet.microsoft.com/en-us/library/cc671616%28v=office.12%29.aspx

http://www.ungertech.com/dbrestore.html

hey.. thanks for the reply.
no cannot get the admin url, receive the "cannot connect to the configuration database" message for both client and admin urls

will review the links you sent..

thanks again.

Here are some more specific discussions of re-attaching the databases using the stsadm.exe tool.  If you don't have the names of your databases documented anywhere then use SQL Management studio to see the database names and you should be able to guess which one is the config db etc.   By default content DBs ( the actual web apps/sites) have a GUID in the name.  If you don't know your original SA password then it might be an idea to start using a network account to attach to the databases rather than SA.


http://technet.microsoft.com/en-us/library/cc263422%28v=office.12%29.aspx

http://social.technet.microsoft.com/Forums/sharepoint/en-US/6b6945ea-4d7d-4c98-acb6-5b8d4995dd4c/attaching-the-config-database-in-sharepoint-2007-with-stsadm?forum=sharepointadminlegacy

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/8185cb0d-2a07-4a8c-845d-0ce31435e28d/trying-to-reattach-config-db-to-wss-30-installation

thanks again.. so lets say i'm using the stsadm .. the command set shows connection to one database. i am told 5 where restored for sharepoint.

i have the names of them, but just wondering how i would connect more than 1 db if i had to or is that i connect to one, which allows me back into the admin area, where i can make the further adjustments?

Steps implemented to resolve.

1. Setup SQL Aliasing on SharePOint server to point to the new SQL server "SQLCLUSTER02"

2. Disconnected the existing SharePoint server farm by running the SharePoint Configuration Wizard.

3. Ran SharePoint configuration wizard to connect to the old configuration database "sharepoint".

4. It failed as we weren't aware of the password for "Network Service" account.

5. Therefore, we created a new SharePoint farm by creating new SharePoint Configuration Database "Sharepoint_Config" on SQLCLUSTER02

6. Created a new host header web application with URL "http://intranet.amslgroup.com/default.aspx".

7. And attached the original content database "STS_sharepoint01_1" to the new web application with help of command "stsadm -o addcontentdb -url < > -databasename < >"

8. Started the SharePoint Search Service from Central Administration with new search database name "WSS_Search_SHAREPOINT01-VM_New"

9. Started Full crawl with help of command "stsadm -o spsearch –action fullcrawlstart"