bman9111
asked on
asp.net aspnetdb.mdf access from internet
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
I am not sure if I need to change the connection string for it or what.
check this site
http://www.connectionstrings.com/?carrier=sqlserver2005
http://www.connectionstrings.com/?carrier=sqlserver2005
ASKER
i figured out that it is an sql express issue. I am going to award you the points though for the additional info.
ASKER