Advertisement

07.13.2008 at 02:19PM PDT, ID: 23561249
[x]
Attachment Details

deploying asp.net 3.5 website database including MS Web Site Admin Tool security tables

Asked by jat465 in Programming for ASP.NET, Microsoft Visual Basic.Net, Microsoft Visual Studio Express

Tags: asp.net 3.5, visual basic, ms sql 2005, Exception Details: 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

I developed website in Visual Web Developer 2008 Express Edition. I used the built-in security functions in Web Site Application Tool. I placed by application data tables in the same database with the security related tables, so I would have only one database. I deployed the website to a remote server. The application functionality that does not require the WSAT datatables works fine. However, when I try to login to my website as a user or create an account I get the error message below. I did not get this error (everything worked fine) when I ran the website on the local server on my own machine.

Error Message:
Exception Details: 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
Start Free Trial
[+][-]07.14.2008 at 03:15AM PDT, ID: 21996834

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.14.2008 at 07:12PM PDT, ID: 22003704

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 12:15PM PDT, ID: 22010056

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.16.2008 at 12:35AM PDT, ID: 22013907

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Programming for ASP.NET, Microsoft Visual Basic.Net, Microsoft Visual Studio Express
Tags: asp.net 3.5, visual basic, ms sql 2005, Exception Details: 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
Sign Up Now!
Solution Provided By: G0ggy
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628