Hi Justin,

I moved the Strataframe database to a new SQLExpress install on another machine.  I attempted to run the strataframe installation on the machine with new SQLExpress install and I get the same error! 

I have attached the Strataframe.mdf and ldf files for your inspection.  I figure the next logical step is for you guys to look at the database to see why it is failing.

Obviously I need to get this resolve, before I can run the DDT to import an existing database which was failing to import all of my stored procedures which started this support thread to begin with several days ago.  I am anxious to get this fix so that I can start using DDT I purchased a couple of weeks ago for a current project I am working on.

Thanks for you prompt attention to this matter.

Jeff

Do you have a SQL Server 2005 Express instance that you can put the StrataFrame database on? It looks as though the SF database is trying to be exist in SQL 2000 compatibility mode, which could be the issue. Could you move that over to a fresh SQLExpress instance and retry the install?

That should give us a clean state rather than going back and forth trying to determine the differences in environment.

What is the status on both issues (DDT Import and Installation)?

Thanks,

Jeff

Hi Dustin,

I was not sure what problem you are referring to - DDT or installation? So included the Strataframe database options and the my production database options.

Thanks,

Jeff

Hi Jeff,

You are deploying this to your SQL 2005 server, correct? I just had Ben in here looking at the source of the Database Migrator class to get to the bottom of your issue, but we couldn't see any issues in the code itself. Something is preventing the retireval of stored procs and UDFs from your SQL 2005 server where it works fine on ours (and all of the other DDT users').

Could you go into SQL Management studio, and take a screenshot of the Options page of the database properties for the StrataFrame databse. Go ahead and maximize it first so that we can see all of the options. Hopefully that will shed some light as to why your server is behaving differently than ours.

Thanks!

What is the status?  Please keep in mind that what started all of this is the DDT failed to import over half of the stored procedures in my database.  Following the suggestions, I downloaded the latest release and tried to install it and that is when I encounter another problem with the installation failing.  I need to get both problems resolved.

Thanks,

Jeff

Hi Justin,

On the second or third screen of the setup wizard it verifies that the connection to the SQL Server Instance name I supplied is good before going to the next screen.  This happens before this error occurs.  So I am not sure why you are asking this question?!?!?  However, I work with this database and develop against it everyday using Strataframe so I know it is good.

Do you have the correct server name supplied?

You can test the connection settings in SQL management studio to ensure it all lines up as you are expecting it to from your development machine.

I have attached the latest log.

You should be able to find it at:Where "X" is an incrimenting number (one for each install). You want the highest number (most recent log).