Recovering from server crash...

[Intelliflex]

Version: AC 7.6
Server: Windows 2008 Server
SQL Server: MS SQL Server 2008 Express.
===
I had a server go down after a lightning storm which trashed the OS on the Raid 5. Although I have backups of the database, I would prefer to use the database files that were in use at the time so the data will be as up-to-date as possible, which appear to be in good condition.

I have copied the database and log files over to another server and attached the database and the data appears to be intact. I have copied the contents of the web folder and recreated the website in IIS7. Now, I have to recreate a database connection user/password to access the database. How can I enter that into the system from the Able Commerce Admin so Able will connect? I assume it is encrypted in the database, so I don't think I can just enter it in the database from the SQL Manager. Can I get into the Admin without connecting to the database to start with?

If anyone has any experience with this, I would sure appreciate a little direction...

Thanks...

[jmestep]

You can replace the code in your App_Data/Database.config file with the following, only use your connection information for the connection string.
<connectionStrings>
<add name="AbleCommerce" connectionString="CONNECTIONSTRING" providerName="System.Data.SqlClient" />
</connectionStrings>
It would be something like this:
Server=Precision;Database=14481Test1;Uid=xxxx;Pwd=xxxxx;

[Intelliflex]

Thanks Judy!

You always come through!