asp.net aspnetdb.mdf access from internet
Posted on 2007-07-20
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)
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.