I dont know where else to put this question. After an extensive period of time trying to get my site to run on Go.Daddy, I reduced the number of pages to two: the login page and the default (home) page. The problem simply is that after the login screen appears, I enter my user name and password, click "login" and the application stops. Now there are NO DB accesses on the home page so I concluded that the problem must be in the way I configured the connection strings for what I think must be associated with the login screen; and there were only two. I sent the following  email to go.daddy which here is preceeded by their answer: (The app runs 100% on my machine)

Discussion Notes
Support Staff Response
You will need to set the directory permissions for this folder so that you can write to it from an ASP script. Click on My Account. Log into your account. In the My Products section, click Hosting Account List. Click the “Open” link to the right of the domain you would like to modify. Click on Content: File Manager. Check the box to the left of the folder you want to modify the permissions for. Click on the ‘Permissions’ button. Set the permissions you need for this folder then click ‘OK.’
Customer Inquiry
I am trying to run my first non-trivial site and it crashes after completing the login screen. Error message says that the database file specified in the connection string cant be found. The site configuration has been reduced to two pages: Login and default. Default accesses NO databases. I am assuming that something must be wrong with my connection string setup: The connection strings working on my development computer are: <!-- <add name="PINEMgtConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&quot;C:\Documents and Settings\a\My Documents\Visual Studio 2005\WebSites\Pinetools\App_Data\PINEMgt.mdf&quot;;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> <add name="PINEMgtConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&quot;C:\Documents and Settings\a\My Documents\Visual Studio 2005\WebSites\Pinetools\App_Data\PINEMgt.mdf&quot;;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> --> They are commented out so I can run the GoDaddy configured strings which are: <add name="PINEMgtConnectionString" connectionString="Server=p3swhsql-v10.shr.phx3.secureserver.net; Database=PINEmgt; User ID=PINEmgt; Password=XXXXXXX; Trusted_Connection=False" providerName="System.Data.SqlClient" /> <add name="PINEMgtConnectionString2" connectionString="Server=p3swhsql-v10.shr.phx3.secureserver.net; Database=PINEmgt; User ID=PINEmgt; Password=XXXXXX; Trusted_Connection=False" providerName="System.Data.SqlClient" /> The Xs replace my actual password. I am using the Microsoft VWD 2005 to build by site I configured the login page and and then moved the ASPNETDB to GoDaddy. I have been trying to get this simple configuration running for days. Appreciate your help

---

I  tried to follow their directions but it turns out that no "Permissions" button appeared  and I called their help line. After also failing to find a "permissions" button, they put me on hold for a short time and gave me the following data. The said that I need to download a tool called WSFTP  which would give me the ability to set "READ, WRITE, EXECUTE" permissions for each page of my VWD 2005 developed application and that unless I did that, my application would not run because Microsoft Front Page controlled the app after it started and these were Front Page requirements!  I looked up WSFTP and it is a FTP application (but I admit I didnt study the application).

Have I made some other error that is really stopping my app? Do I really need WSFTP? Or do I need to find another, amd more VWD friendly host?

Buddypup

Where is your database, on a godaddy sql server or in the app_data directory as an mdb file?

It is in a go.daddy server. I reviewed those files and they look OK

Buddypup

Hey Buddypup,

this might sound very wired, can you please try to remove trusted_connection="false" from your connection string and try. i thinking that where is the problem, i hope it helps.....

just a suggestion......

Thanks

Got the following response:

Server Error in '/' Application.

---

The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Configuration.Provider.ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.] System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString) +2555237 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +87 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Hey Buddypup,

sorry that didnt work.......thanks for trying. i did some research and on the godaddy site, this is what i found. i hope it helps you or give you some ideas. they are using something like

Thanks for your research. I have to go install a wireless site (900 MHz) on a 500 ft tower tomorrow so I wont get a chance to try it until I get back. If I get careless, I probably wont get a chance to try it.

 

Buddypup

Hey

Have fun.............looks like kool thing to do

Thanks

 

I decided it was easier to cancel my Go.Daddy site than try for more months to get it going. Thanks to anyone that tried to help.

you are not referencing your connection string properly.  I have a couple of sites under godaddy. 

By the way, what type of database are you using?  SQL, MYSQL, ACCESS?  Just want to make sure...

 If your site is still up, and you didn't cancel, let me know, and I'll tell you how your connection string should be setup. 

I am trying to change the strings from support to SQLExpress to SQL on Go Daddy.

Did you get it working?

Hi,

Based on my understanding, the database you use on the local is SQL Express, and you want to use the SQL Server 2005 on the remote server. If I have misunderstood you, please feel free to let me know.

You can use Database Publishing Wizard to create .SQL Installation Scripts for your Express Database and then using this .SQL files to create your remote databases on the SQL Server 2005. For more information, see http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

 

I hope this helps.

the solution is what novicehere suggested.  That should solve your db connection issues.

Thank you for your reply. Although I gave up on GoDaddy, I will followup on the article you indicated.