Error Message Logging In (aspnetDB)

Hi,

construir

build

© Webster's

I am programing a site in aspnet 2005

I contructed space from my host for my Database.

In the web.config I added a connection string with username and password <configuration>

<appSettings/><connectionStrings><add name="oseriConnectionString" connectionString="Data Source=sql2005.digiweb.com.br;

Initial Catalog=zzz;

User Id=xxx;Password=yyy"

providerName="System.Data.SqlClient"/>

and I have access to this database when I work on my station as well when I am working on line.

Unfortunately I also gained for free the ASPNETDB.mdf file...

The ASPNETDB is automaticaly created in the ~/app_data together with a web.config.

I use the following connectionstring:<add name="aspNetDBConnectionString" connectionString="Data Source=sql2005.digiweb.com.br;

initial Cataloge=htdocsapp_DataASPNETDB.MDF;

Integrated Security=True"/>

Working on my station I have access to the aspnetDB file, I can add users roles etc..

notice that I use ConnectionString to my provider!

My first question is whether I really load the information also to the file in my site Because on my station I can find the changes.

If the answer is no then do I load the file simply through the FTP ?

and how can I open the file in the provider side?

In any case when I run the site on line, trying to log in, I get an error message 26

 

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

If I insert a wrong password I get the same error message. Which means that I don’t have access to the file.

I definitely could use some help since from my provider I get none.

Thank you

Dov Kruman