I had an SBS 2003 R2 Server crash . I set up a new server with a new name. I was able to slave the drive and retrieve the mdf files server2005 and the config files (old server) and copy them to a new sub directory in the new server (server2009) . I followed the instructions per Microsofts document "Moving Data Folders for Windows Small Business Server 2003" see attached. I substituted the OLD server names when doing the attach. It appeared to go ok at the command prompt. Now when I go to Companyweb I get an "unable to connect to database"
Old server is SERVER2005 . New server is SERVER2009. Am I able to do this without exactly duplicating the old servers credentials ?
To attach the databases to the SharePoint instance of WMSDE
You must attach the databases you moved to the destination partition back to the SharePoint instance of WMSDE.
1. Click Start, click Run, and then type Cmd.
2. Type the following command, considering the following bullet points, and then press ENTER.
" The -E, -S, and -Q command line parameters must be typed as capital letters as they are case sensitive.
" ServerName is the name of the computer running Windows Small Business Server 2003
" D is the drive letter for the new location of the database.
Osql -E -S ServerName\SharePoint -Q sp_attach_db 'STS_Config', 'D:\MSDEDatabases\SharePoint\STS_Config.mdf', 'D:\MSDEDatabases\SharePoint\STS_Config_Log.ldf'
3. Repeat the command from Step 2 for the STS_ServerName_1 database, where ServerName is the name of the computer running Windows Small Business Server 2003.
Osql -E -S ServerName\SharePoint -Q sp_attach_db 'STS_ServerName_1', 'D:\MSDEDatabases\SharePoint\STS_ServerName_1.mdf', 'D:\MSDEDatabases\SharePoint\STS_ServerName_1_Log.ldf'