StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Can't find Server 2005 Express

Can't find Server 2005 Express

Ivan George Borges — Sat, 02 Sep 2006 12:16:39 GMT

Hi everybody.

I've spent the weekend building a new notebook.

We are trying to work with SQL 2005 Express. For some reason, the server won't be found in the StrataFrame installation process.

I found a thread where Ben sugests to insert the server name manually. I did that, but no luck.

Honestly, I don't think it's a Straframe problem, as I then went into the Visual Studio's Server Explorer and tried to add a Database Conection, and it wasn't found there either.

Any clues that could help ?

Thanks.

RE: Can't find Server 2005 Express

Ricardo Quartier — Sat, 02 Sep 2006 12:16:39 GMT

Yo, Ben yes it's the local machine, anyway the files that trent sent me, help me, the install cannot deploy, but he give me the databases already done... Not sure what can happen in the next version, when i need to install or reinstall, but for now.. works fine.. thanks for the help. :D

RE: Can't find Server 2005 Express

StrataFrame Team — Thu, 31 Aug 2006 00:43:28 GMT

Oh, and that path is local to the server, not local to your machine (unless the SQL Server you're trying to deploy to is your local machine :))

RE: Can't find Server 2005 Express

StrataFrame Team — Thu, 31 Aug 2006 00:42:47 GMT

When you deleted the databases, Ricardo, did you also delete the .mdf files? looks like they're located in the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ directory... looks like the StrataFrameInternal.mdf and possibly the StrataFrameInternal.ldf files might be causing problem...

When you delete the database through the SQL Server management studio, check that folder to make sure the files are gone, and then you can retry the install.

RE: Can't find Server 2005 Express

Ricardo Quartier — Wed, 30 Aug 2006 06:03:35 GMT

Anyway, the translation exe worked... really cool... I have to send the dlls to the gac like ivan.. but it's really cool, and we already send it back to you.. well done Trent, congratulations.

RE: Can't find Server 2005 Express

Ricardo Quartier — Wed, 30 Aug 2006 05:59:12 GMT

:w00t:

No sir......... I done the things u said.. I deleted the 3 databases, but still no way... I hope that file help in something.. thanks.......

RE: Can't find Server 2005 Express

Trent L. Taylor — Mon, 28 Aug 2006 20:31:49 GMT

Ricardo,

Sorry....I in no way meant to keep you waiting. To short circuit any errors you are getting, I have posted the MDF files (the actual files that SQL Server creates) on the web for you to download. See the link below. You can just delete your existing StrataFrame and StrataFrameSample databases through SQL Server Management Studio and attach these. This side-steps the install and should get you going. Let me know if you have any questions.

http://www.strataframe.net/downloads/strataframe_databases.zip

RE: Can't find Server 2005 Express

Ricardo Quartier — Mon, 28 Aug 2006 20:09:10 GMT

Dear friends, please do not forget me........ :D

RE: Can't find Server 2005 Express

Ricardo Quartier — Wed, 23 Aug 2006 15:16:03 GMT

Hum.. still no lucky, i sent a pic and log files.. be patience, please :D

RE: Can't find Server 2005 Express

Trent L. Taylor — Wed, 23 Aug 2006 02:44:00 GMT

OK...let's start from the beginning and get you going :)

Open up SQL Server Management Studio or Enterprise Manager
If StrataFrame, StrataFrameInternal, or StrataFrameSample exists within your server, delete them
Make sure the MDF files do not exist. To do this, navigate to the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" folder and remove any file that begins with "StrataFrame"
At this point there should be no StrataFrame database or reference to a database
Close all Visual Studio instances
Install StrataFrame and let it re-create your data structures

This should get you going. Let me know if you run into anything I did not think of :)

RE: Can't find Server 2005 Express

Ricardo Quartier — Wed, 23 Aug 2006 01:11:05 GMT

I forgot to say, the 3 databases, doesn't exist anymore...

RE: Can't find Server 2005 Express

Ricardo Quartier — Wed, 23 Aug 2006 01:02:45 GMT

:w00t: Trent, I guess this time I really broke it... sorry........ any idea? I sent a pic to help

RE: Can't find Server 2005 Express

Trent L. Taylor — Tue, 22 Aug 2006 16:36:45 GMT

Sounds good. :)

RE: Can't find Server 2005 Express

Ricardo Quartier — Tue, 22 Aug 2006 16:34:20 GMT

OK, thanks I will, the instalation is in another comp, not with me now, but i will check it out tonight...

RE: Can't find Server 2005 Express

Trent L. Taylor — Tue, 22 Aug 2006 09:16:45 GMT

I think you are having the reverse problem that Ivan was. It seems that your SQL Server thinks that a StrataFrame database exists when it may not. Open up the SQL Server Management Studio or Enterprise Manager and see if the StrataFrame, StrataFrameInternal, or StrataFrameSample databases exist. If so, go ahead and delete them and let the install recreate the structures.

RE: Can't find Server 2005 Express

Ricardo Quartier — Mon, 21 Aug 2006 22:04:56 GMT

SF - Cannot install - Ivan's Karma

Yo Trent, it's me Ricardo, Ivan's friend, how are u?, I hope everything is fine...

Lets get to the show...

I bought the old notebook from Ivan, then formated, then I tried to install the SF again, I get the same problems as Ivan with the SQL Express, but i belive mine is more dificult, since after deleting the 3 sf databases, i cannot recreate then.. Im inserting the logs, to maybe help .. In the first intall.. the database was created, but the data cannot be deployed, the I read the post on the forum and I deleted the databases, but now, i can't even recreate.

Please, Please, Please, Please, Please, Please, help :)

RE: Can't find Server 2005 Express

Trent L. Taylor — Mon, 21 Aug 2006 17:30:45 GMT

Sure :D

RE: Can't find Server 2005 Express

Ivan George Borges — Mon, 21 Aug 2006 17:02:34 GMT

Thanks. ;)

RE: Can't find Server 2005 Express

Trent L. Taylor — Mon, 21 Aug 2006 16:34:13 GMT

Yes, you are right. That will work also :)

RE: Can't find Server 2005 Express

Ivan George Borges — Mon, 21 Aug 2006 16:32:15 GMT

Will do it.

I can use the version I got in the SF training too, can't I ? Isn't that with the wrapper ?

RE: Can't find Server 2005 Express

Trent L. Taylor — Mon, 21 Aug 2006 15:38:30 GMT

Just install the DevExpress trial. Then download the 6.1.5 version of the wrapper from the StrataFrame website and install it. Once you have done this, re-create the toolbox (where you got the error before) and it will create the StrataFrame DevEx controls.

RE: Can't find Server 2005 Express

Ivan George Borges — Mon, 21 Aug 2006 15:36:08 GMT

Did this. It worked fine.

I'm now going to install DevExpress Trial. I should then reinstall SF, right ?

RE: Can't find Server 2005 Express

Trent L. Taylor — Mon, 21 Aug 2006 15:31:06 GMT

Already been resolved. This is because you do not have DevExpress loaded on your computer. Just ignore the error and move on and you will be just fine. ;) This will be resolved in future updates.

RE: Can't find Server 2005 Express

Ivan George Borges — Mon, 21 Aug 2006 15:29:39 GMT

SUCCESSSSSSSSSS

Thanks.

Feeling home again.

Now, one small thing when I created SF Toolbox :

ReflectionTypeLoadException
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Source : mscorlib

Stack Trace:
   at System.Reflection.Module.GetTypesInternal(StackCrawlMark& stackMark)
   at System.Reflection.Assembly.GetTypes()
   at MicroFour.StrataFrame.AddIns.MenuBasics.GetToolboxItemsForAssembly(Assembly ContainingAssembly)
   at MicroFour.StrataFrame.AddIns.MenuBasics.CreateToolBoxInheritedItemList()

RE: Can't find Server 2005 Express

Trent L. Taylor — Mon, 21 Aug 2006 14:58:26 GMT

I believe you :P

The problem is that the MDF (SQL Server files) files exist but are not mounted to the server. So when the install tries to create these files, it gives an error. You can either manually mount these file or delete them and let the install recreate the files. If this is a fresh install, then I recommended just deleting them and letting the StrataFrame install recreate them; These are the files you will either need to mount or delete:

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrame.mdf'
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrame.ldf' (if it exists)

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameInternal.mdf'
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameInternal.ldf' (if it exists)

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameSample.mdf'
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameSample.ldf' (if it exists)

If you want to mount them, open the SQL Server Management Studio and open your server. Right click on the server and go to tasks and then “Attach” or “Mount.” You will select the MDF files above. This will then add them to the SQL Server which can then be updated via the DDT.