Can't Import restored SQL MS CRM 4.0 Database get error below

I have restored the CRM databae from backup *.bak but when I try to import the organization in the deployment manager I receive "the import organization wizard cannot connect to the sql server or cannot find an organization database on domain\server. Verify that the server name in the sql server box is correct and that the computer is running microsoft sql server where an organization database is stored"

All services are running not sure how to proceed, how do I get pass this so I can bring back an organization after a server has failed
fantnetAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bmosoftwareCommented:
So I assume from your message that your server failed and that you have re-installed and are trying to restore the CRM database. Which database did you restore ? the orgname_MSCRM one and / or the MSCRM_Config one ?

The correct process should have been to install CRM 4.0 on the server with a Temp organisation name, this would then create a Temp_MSCRM and MSCRM_Config Database, you would then restore the backup of your orgname_MSCRM database only (not the MSCRM_Config one), you would then import the restored organisation via CRM Deployment manager, after which you can delete the Temp_MSCRM database if you so wish.
0
fantnetAuthor Commented:
What you stated above is what I an trying to do.I installed a new installation of CRM and SQL and then only restored the organization database. I didnt touch the Config database. I see the following under system databases.

System
master
model
msdb
tempdb - should this be deleted? This is also help explain the error message?
0
bmosoftwareCommented:
No you shouldn't be deleting any of system database. Only the _MSCRM one that was created when you installed CRM, but only after you have restored and imported your backup.

Are you overwriting the existing _MSCRM database with your restore or are you restoring to a seperate database ?
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

fantnetAuthor Commented:
overwriting
0
fantnetAuthor Commented:
does this make a huge difference?
0
bmosoftwareCommented:
yes it does. that is most likely why you import organisation is failing as the current default organisation is no longer there as you have overwritten the database. This is why you need to create a temporary organisation first, then restore to a new database, and then import the newly restored organisation
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fantnetAuthor Commented:
Should I reinstall SQl Server?
0
fantnetAuthor Commented:
After reinstalling SQL Server and CRM Server. When I go to restore database. I receive error  "restore failed for server"

and "reissue the restore statement using with replace to overwrite pre-existing files" I attached I screenshot with the exact error message
EE.doc
0
bmosoftwareCommented:
When you do the restore under Options (on the left) there is a check box for overwrite existing database. Use that.
0
fantnetAuthor Commented:
I did that before I  reinstalled SQL Server  and it didnt find the database when I tried to import. So if I select the temp database to overtwrite during the restore process after it is restored it will find it in the deployment manager?
0
bmosoftwareCommented:
Nope, you should not be overwriting any database. Just restore to a new database.
0
WilyGuyCommented:
When you clean installed CRM, did you try to use the name you were using before?

I recommend on Install (or you can probably just create a New Org) setting the name to Temporary or ToDelete or something.

Then you should see MSCRM_CONFIG and ToDelete_MSCRM databases.  My guess is you already have a database with the name of your soon to be restored DB.

See if CRM will let you create a new ORG (call it ToDelete) and then remove the install ORG and delete THAT database so that you have the databases above.

Then restore the database you have <yourorg>_MSCRM (easiest way is to open SQL, right click the Databases area and select Restore Database, find the BAK file and check it in the bottom box, then on the top dropdown, you should see the correct name.  On the next page of the restore, make sure the file paths are correct and none of the top checkmarks.

That should take care of it, but you are in fine hands with BMOS.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.