Windows Vista (IIS 7.0)

SQL Azure

mojoportal-2-3-1-9-sqlazure

I have no problems in installing Mojo portal in my local IIS using SQL Azure as backend. I visited home page and it worked like a charm. I went into the content layout page and added Links module to the left side of my home page. Visted the Homepage and Boom, error cropped up

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have noticed if you try to add some modules then it is throwing this kind of error.

I am planning to write an article about taking mojo CMS to Cloud computing. If I can sucessfully manage to install and use all the futures then it will be a testimonail for both mojo and for SQL Azure. help me.

Many Thanks,

Supremestar

Joe,

It is not a service issue. Cause when I am adding links module to the left of my homepage it is causing that error. When I deleted that module then it renders fine. That means some of the modules are not picking the SQL Connection.

I think when you compile some modules you might forgot to include the SQL Azure settings. Why I am saying this is, I have seen this line in WEB.config

<!-- Note that each db platform has its own connection string, but the database used depends on which data dlls are in the bin folder

it is not determined by configuration settings. -->

That means some of the dlls are not compiled using SQL AZURE or something like?

Many Thanks

Supremestar

Joe,

Many Thanks for your help. I will wait here for your signal.

Many Thanks,

Supremestar