StrataFrame Forum

Can't find Server 2005 Express

http://forum.strataframe.net/Topic2300.aspx

By Ivan George Borges - 8/21/2006

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.

By StrataFrame Team - 8/21/2006

When you tried to add the name manually, did you try this: "localhost\sqlexpress"?

By default, TCP/IP communication is turned off on SQL Server Express, so you have to enable it if the database is on a remote machine.  But, if the database is on the local machine, you have to use the full name (so you can use named pipes) or you have to turn on TCP/IP for the browser to find it.

Here's a link to a topic that lists the instructions to enable TCP/IP on the server:

http://forum.strataframe.net/FindPost35.aspx

By Trent L. Taylor - 8/21/2006

When you install SQL Server Express, it installs with an instance name by default:

localhost\SQLEXPRESS

Try the installation again and when prompted add the SQLEXPRESS to the end of the server name and see if it can be seen.  This is the most common issue when using SQL Server Express.

By Ivan George Borges - 8/21/2006

Did the whole thing, still didn't work.

It stops when Deploying StrataFrame Data.

It builds both StrataFrame and Sample Databases, but it won't deploy the data.

This machine came with Windows Media Center, which is based on Windows XP Pro. Just in case you might know of any issues.

By Trent L. Taylor - 8/21/2006

If you open the server using the SQL Server Management Studio, do the StrataFrame and StrataFrameInternal databases exists?   If so, delete them and start the install from scratch.  Also, you can send the log file which will include any errors.  The log file should be located at the following location:

C:\Program Files\Common Files\MicroFour\StrataFrame

or

C:\Program Files\MicroFour\StrataFrame

The name of the file will be StrataFrame_resultsX.log.  This might help determine what is going on.

By Ivan George Borges - 8/21/2006

In a previous try, I checked in the Management Studio and they were there, empty. Ricardo is my witness, I swear !!!

But now, after some 10 install and uninstalls, I tried it again and it hasn't even created the database.

I've sent you the log files. If you find out something stupid, don't worry, I can take it.

By Trent L. Taylor - 8/21/2006

I believe you Tongue

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.

By Ivan George Borges - 8/21/2006

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()

By Trent L. Taylor - 8/21/2006

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. Wink  This will be resolved in future updates.
By Ivan George Borges - 8/21/2006

Did this. It worked fine.

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

By Trent L. Taylor - 8/21/2006

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.
By Ivan George Borges - 8/21/2006

Will do it.

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

By Trent L. Taylor - 8/21/2006

Yes, you are right.  That will work also Smile
By Ivan George Borges - 8/21/2006

Thanks. Wink
By Trent L. Taylor - 8/21/2006

Sure BigGrin
By Ricardo Quartier - 8/21/2006

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 Smile

By Trent L. Taylor - 8/22/2006

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.
By Ricardo Quartier - 8/22/2006

OK, thanks I will, the instalation is in another comp, not with me now, but i will check it out tonight...
By Trent L. Taylor - 8/22/2006

Sounds good. Smile
By Ricardo Quartier - 8/22/2006

w00t Trent, I guess this time I really broke it... sorry........ any idea? I sent a pic to help
By Ricardo Quartier - 8/22/2006

I forgot to say, the 3 databases, doesn't exist anymore...
By Trent L. Taylor - 8/22/2006

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

  1. Open up SQL Server Management Studio or Enterprise Manager
  2. If StrataFrame, StrataFrameInternal, or StrataFrameSample exists within your server, delete them
  3. 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"
  4. At this point there should be no StrataFrame database or reference to a database
  5. Close all Visual Studio instances
  6. 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 Smile

By Ricardo Quartier - 8/23/2006

Hum.. still no lucky, i sent a pic and log files.. be patience, please BigGrin
By Ricardo Quartier - 8/28/2006

Dear friends, please do not forget me........   BigGrin
By Trent L. Taylor - 8/28/2006

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

By Ricardo Quartier - 8/29/2006

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.......

By Ricardo Quartier - 8/30/2006

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.

BigGrin

By StrataFrame Team - 8/30/2006

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.

By StrataFrame Team - 8/30/2006

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 Smile)
By Ricardo Quartier - 9/2/2006

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.   BigGrin