SQL EXPRESS

Also make sure that you have inputted this in your web.config file under your connection string section of the config file...
<remove name='LocalSqlServer' />

 

I don't believe you can use SQL Express in a live environment.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

I have been advised to use this forum in a reply to my help ticket.

I have made a system in Visual Web Developer 2005 Express. It uses a login control made using ASP.NET configuration utility with VWD, which produced an sql express DB called 'ASPNETDB.MDF'.

It works fine on local host, but once it is uploaded on to discount asp, and try to login i'm presented with...

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)

After many wasted hours of searching for the solution i have still not been able to solve this problem.


Any help would be greatly appreciated!!!

 

Can you post the connections part of your web.config?
Just comment out the username and password information..

 

This is the entire of my web.config...


</o>
<!-- </o>
Note: As an alternative to hand editing this file you can use the </o>
web admin tool to configure settings for your application. Use</o>
the Website->Asp.Net Configuration option in Visual Studio.</o>
A full list of settings and comments can be found in </o>
machine.config.comments usually located in </o>
\Windows\Microsoft.Net\Framework\v2.x\Config </o>
--></o>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"></o>
<appSettings/></o>
<connectionStrings/></o>
</o>
<system.web></o>
<!-- </o>
Set compilation debug="true" to insert debugging </o>
symbols into the compiled page. Because this </o>
affects performance, set this value to true only </o>
during development.</o>
--></o>
<compilation debug="true"/></o>
<!--</o>
The <authentication> section enables configuration </o>
of the security authentication mode used by </o>
ASP.NET to identify an incoming user. </o>
--></o>
<authentication mode="Forms"></o>
<forms loginUrl="MANAGEMENT_SYSTEM/default.aspx" /></o>
</authentication></o>
<!--</o>
The <customErrors> section enables cPOOonfiguration </o>
of what to do if/when an unhandled error occurs </o>
during the execution of a request. Specifically, </o>
it enables developers to configure html error pages </o>
to be displayed in place of a error stack trace.</o>
</o>
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"></o>
<error statusCode="403" redirect="NoAccess.htm" /></o>
<error statusCode="404" redirect="FileNotFound.htm" /></o>
</customErrors></o>
--></o>
</system.web></o>
<location path="MANAGEMENT_SYSTEM/manager.aspx"></o>
<system.web></o>
<authorization></o>
<deny users="?"/></o>
</authorization></o>
</system.web></o>
</location></o>
</configuration></o>

 

Please refer to the following thread for detailed information on this matter:


http://community.discountasp.net/default.aspx?f=16&amp;m=16969