.NET Role/Membership - SQL Server/Express

[RFH Reseller: alano999]

Can't find a definitive answer in this forum...

Does anyone know whether RFH provide support the default .NET Role/Membership database and providers that uses SQL Server 2005 Express?

I've developed a website locally with Role/Membership functionality using VWD2008E. By default a SQL 2005 Express database is created in the app_data folder.

I then used VWD2008E Copy Website to publish the site (including app_data folder) to my RFH hosting (SQL Server 2005 enabled on site, although possibly not relevant?).

I get an error whenever Membership functionality is accessed (e.g. Login)...

System.Data.SqlClient.SqlException: 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Do I need to upscale .NET Membership settings to full-blown SQL Server 2005 instead of Express? If so, how do I migrate from the local SQL Server 2005 Express database?

Thanks in advance.

Alan

[Staff: Warren Ashcroft]

Hello Alan,
Yes, you will need to connect your application to a full SQL Server 2005 database, since we dont run SQL Server 2005 Express on each web server.

There are a number of tools you can use to transfer the database, check the "Online Management" link of the database once created in the control panel.

[RFH Reseller: davidbending]

As Warren says you will need to migrate to using a full-blown database.

You can configure a database for .Net membership using aspnet_regsql. If you run the command-line version you can configure the RedFox hosted database from your desktop machine with no problems.

[RFH Reseller: alano999]

Thanks guys. Sorted.

I used Microsoft's "*NEW* Database Publishing Wizard" listed in the RFH Database Management Utilites web page. Took me a while to spot the required settings at the bottom of the web page!

Cheers,
Alan