Our SQLserver db containing the SharePoint config db went down, hardware failure, the content is on a different server, managed to get the config db from backup,
i ran stsadm -o delete configdb, but I keep getting 'access denied' when I try to reconnect to the old config db on the new server from the command:
stsdam -o setconfigdb -connect -databaseserver (newservername) -databasename SP2007_config -farmuser (SP farm admin user) -farmpassword (password)
after playing around with permissions and making sure everything is well permission wise, i got:
a network-related or instance-specific error occurred while establishing a connection to SQL server.... (provider: Named Pipes Provider, error 40 - could not open a connection to SQL server)
allow remote connections to server is turned on, I am running stsadm on the same server because its all a 'one box' farm expect the config db was on a seperate box which is down????
tried psconfig and it hangs on;
Performing configuration task 2 of 3 Connecting to the configuration database... THEN
Failed to connect to the configuration database. An exception of type System.Security.SecurityException was thrown. Additional exception information: Access denied.