Cannot access recovered SQL databases from sharepoint
share point services 3.0 being used.
the sql 2000 server being used for the sharepoint databased crashed and was unrecoverable.
databased were restored from back and put onto another sql server, which is sql server 2008.
sharepoint is not able to connect to the databases that are housed on the sql 2008 server. whenever a user tries to access sharepoint the following information is added to the application log on of the sharepoint server.
event id 3351
sql database login failed. additional error information from sql server is included below
login failed for user sa
at this time i am unsure if the previous sa account password is available from the sql 2000 server the databases were restored from.
not certain this is the only issue at this time but its one we need to get past to uncover anything else that may exist.
the question is what is the procedure to restore sql databases to an alternative sql server and make them available to sharepoint.