January 14, 2013 at 1:18 pm
I have a db that I am trying to export from a slightly older version to a newer version. Vendor says the db structure is the same. Both are created on SQL 2005, schema should be the same. App version moved from 3.0.x to 3.0.3 so no big change.
I installed the 3.0.3 app and deleted the default (empty) db. Then I ran this script.
USE master;
GO
CREATE DATABASE SLMD_ABP
ON (FILENAME = 'C:\Database\SLMD_ABP.mdf'),
(FILENAME = 'C:\Database\SLMD_ABP_Log.ldf')
FOR ATTACH;
GO
I refreshed the view so I could see the new db. Now when I try to open it I get this message ...
"The application XXX is not configured for this database. The application will shut down".
Any ideas on what I can do to resolve this. There is no support coming from the vendor.
January 14, 2013 at 2:18 pm
i'm guessing that the application does not expect an empty database...it expects a database with specific tables, procedures, views etc to exist, but probably many of those objects are allowed to be empty(as in now ROWS of data) for a new installation.
it looks for a certain table, and if it doesn't find it, it knows the "database is not configured for this application", and bails out.
Lowell
January 14, 2013 at 2:30 pm
I may not understand correctly what you are stating so please bear with me. The database I am transferring isn't empty. It has lots of information across the tables.
I am upgrading the application which requires an uninstall of the old app to install the new app. I wouldn't uninstall the old until I was certain the new could recieve the db from the old. So I am testing it on another Win 7 computer.
I was wondering if there was some step I should have made before I created the backup, copy of the detached db and simple copy of the db folder to prepare it for the move to the new app? There were no active connections when I performed any of these steps.
Thanks for replying !!
January 14, 2013 at 2:35 pm
cummings.rd (1/14/2013)
I may not understand correctly what you are stating so please bear with me. The database I am transferring isn't empty. It has lots of information across the tables.I am upgrading the application which requires an uninstall of the old app to install the new app. I wouldn't uninstall the old until I was certain the new could recieve the db from the old. So I am testing it on another Win 7 computer.
I was wondering if there was some step I should have made before I created the backup, copy of the detached db and simple copy of the db folder to prepare it for the move to the new app? There were no active connections when I performed any of these steps.
Thanks for replying !!
that seems to be the issue: the command you pasted(CREATE DATABASE SLMD_ABP)
creates an empty database...that's not what you wanted.
you've got the plan mostly right: you need to backup the existing database, copy it to the other server, and RESTORE the database as the name of your choice. just copying alone is not enough...you need to run the RESTORE command; probably through the GUI, since it can help you the best.
Lowell
January 14, 2013 at 3:20 pm
I may not understand correctly what you are stating so please bear with me. The database I am transferring isn't empty. It has lots of information across the tables.
I am upgrading the application which requires an uninstall of the old app to install the new app. I wouldn't uninstall the old until I was certain the new could recieve the db from the old. So I am testing it on another Win 7 computer.
I was wondering if there was some step I should have made before I created the backup, copy of the detached db and simple copy of the db folder to prepare it for the move to the new app? There were no active connections when I performed any of these steps.
Thanks for replying !!
January 14, 2013 at 3:21 pm
Oh man, thanks for pointing that out. I'll try the restore operation. I appreciate the help.
January 16, 2013 at 9:14 am
Hi
The DB I restored is 8.25 MB; I use SQL management studio 2008, I set the options for the restore as follows...
Overwrite existing database WITH REPLACE
Leave db ready ..RESTORE WITH RECOVERY
The restore successfully completes BUT when I attempt to open the application the error is that the "...application is not configured for the db. Application will shut down"
I can see the restored db in SQL studio 2008; should I have set my options to Preserve replication?
Thanks for replying
January 16, 2013 at 9:32 am
cummings.rd (1/16/2013)
HiThe DB I restored is 8.25 MB; I use SQL management studio 2008, I set the options for the restore as follows...
Overwrite existing database WITH REPLACE
Leave db ready ..RESTORE WITH RECOVERY
The restore successfully completes BUT when I attempt to open the application the error is that the "...application is not configured for the db. Application will shut down"
I can see the restored db in SQL studio 2008; should I have set my options to Preserve replication?
Thanks for replying
well you need to do two things, because it sounds like a basic setup issue.
The application is reporting the database is not what it expects, so all you can do is check that the application and the database are where everyone expects them to be.
#1: make sure the application's connection string information is actually pointing to that specific database. if the database is blank, it would probably connect to the master database, and you'd see the application report that same error, since it seems to be looking for specific objects that should exist and don't seem to.
#2: Expand the database you say your restored in object explorer, and browse through the tables/procedures.
do they exist, or is the folder empty, so all the objects are missing? that might be as simple as restoring the wrong backup.
#3: The Login/USER that is being used: make sure that user actually has permissions to connect to that database; if that user did not have access to the dbo schema for example, it might look for dbo.MyApplicationSettingsTable, but not find it, due to permissions, and not due to non-existence.
#4: You said you upgraded From version 3.00 to 3.03.
were there any scripts that should have been run that changes the database to match this 3.03 verison, so if the app connects to a 3.00 database, it reports that error because it's checking/validating 3.03 verison objects?
Lowell
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply