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.

	Post Attachments
	deploy_error.bmp (14 views, 133.34 KB)

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

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.

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.

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.

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.

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