asp.net aspnetdb.mdf access from internet

Posted on 2007-07-20
Medium Priority
Last Modified: 2009-07-29
I have created a simple web application that created an aspnetdb.mdb.When I run this on my pc or upload it to our server i am able to log in ok. When I try and access my site via the web and not internal I get an error.

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)
, etc.....

What do I need to do?. Please state step by step as I am new to this.
The server I have this hosted on is windows 2000, it does have sql 2000 on it.
I think I am missing something little as when I am internal all works great.
Question by:bman9111
  • 3
  • 2
LVL 28

Accepted Solution

imran_fast earned 2000 total points
ID: 19538238
on your sql server open surface area configuration from start programs and enable remote access.

Author Comment

ID: 19539266
where is that at on sql 2000?

Author Comment

ID: 19539782
plus my sql connection to another part of the web works. It appears it is only with the aspnetdb.mdf file that is automactically placed when working with the login component.

I am not sure if I need to change the connection string for it or what.
LVL 28

Expert Comment

ID: 19545524

Author Comment

ID: 19553104
i figured out that it is an sql express issue. I am going to award you the points though for the additional info.


Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question