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.

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

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.

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.

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.

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.

I believe you

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.

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

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.

Did this. It worked fine.

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