Pohsze.net

DinnerNow is a fictitious marketplace where customers can order food from local restaurants for delivery to their home or office. This sample is designed to demonstrate how you can develop a connected application using several new Microsoft technologies.
The demo utilizes several technologies including: IIS7, ASP.NET Ajax Extensions, LINQ, Windows Communication Foundation, Windows Workflow Foundation, Windows Presentation Foundation, Windows PowerShell, and the .NET Compact Framework

Some of you might facing some error messages when installing the DinnerNow solution, as show below:
….
Property ‘ConnectionString’ cannot be found on this object; make sure it exists
and is settable.
At C:\DinnerNow25\scripts\install\library.ps1:7 char:6
+     $sa.C <<<< onnectionString=’MSSQL$SQLEXPRESS\sql\query’
Property ‘ProtocolName’ cannot be found on this object; make sure it exists and
is settable.
At C:\DinnerNow25\scripts\install\library.ps1:8 char:6
+     $sa.P <<<< rotocolName=’np’
Property ‘ServerName’ cannot be found on this object; make sure it exists and i
s settable.
At C:\DinnerNow25\scripts\install\library.ps1:9 char:6
+     $sa.S <<<< erverName=’.\SQLEXPRESS’
You cannot call a method on a null-valued expression.
At C:\DinnerNow25\scripts\install\library.ps1:10 char:12
+     $sa.Create( <<<< )
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [53].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections.
Creating DinnerNow Workflow database…
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [53].
….

The error is because of the missing assembly. Here is the solution you can try it out:

1. Edit the library.ps1, under the C:\DinnerNow25\scripts\install folder
2. Go to the function new-DatabaseAlias
3. Instead of Microsoft.SqlServer.Smo use Microsoft.SqlServer.SqlWmiManagement. refer to below:function new-DatabaseAlias
   {
       [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SqlWmiManagement”) | out-null
       $sa = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ServerAlias “.”,”DinnerNow”
       #Assume SQLExpress for now
       $sa.ConnectionString=’MSSQL$SQLEXPRESS\sql\query’
       $sa.ProtocolName=’np’
       $sa.ServerName=’.’
       $sa.Create()
   }