GoDaddy SQL Server Database Setup – Connection String

July 7, 2008 · Filed Under Getting Started 

Before you upload your ASP.NET 3.5 application onto your GoDaddy hosting server, you need to modify the connection strings section of your web.config file.

<connectionStrings>

<add name=”Personal” connectionString=” Server=whsql-v04.prod.mesa1.secureserver.net; Database=DB_675; User ID=user_id; Password=password; Trusted_Connection=False” providerName=”System.Data.SqlClient” /> <remove name=”LocalSqlServer”/> <add name=”LocalSqlServer” connectionString=” Server=whsql-v04.prod.mesa1.secureserver.net; Database=DB_675; User ID=user_id; Password=password; Trusted_Connection=False” providerName=”System.Data.SqlClient” />

</connectionStrings>

NOTE: You may want to back up the web.config file on your local computer or simply comment out your current connection strings before you make any changes. This way, you can easily return to developing your application on you local computer.

This is an example of the connection strings section that will connect an ASP.NET 3.5 application to one of the GoDaddy SQL Servers:
NOTE: You can find your server name, database name, user ID, and password in the SQL Server section of your GoDaddy Hosting Control Center. These connection string values map to host name, database name, user name, and password, respectively. The user name and password values are those specified during SQL database (not hosting account) creation.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • StumbleUpon
  • Technorati

Tags: ,

Comments

5 Responses to “GoDaddy SQL Server Database Setup – Connection String”

  1. hina on December 22nd, 2008 4:58 am

    i m facing the error while uploading forum . i wrote connection string to connect sql server 2005:

    but i m getting error:
    500 – Internal server error.
    There is a problem with the resource you are looking for, and it cannot be displayed.

    link is here:
    http://punnetts.com/test/setup.aspx

    do u plz hlp me out. ad reply me on my email id

  2. jason on December 22nd, 2008 8:03 pm

    Your page is showings a 500 error but there is no detail – To enable detailed error information, in your web.config file set customErrors mode=”Off”/
    Once that is completed share what the resulting error code is.
    You should also make sure that with godaddy you have set http://punnetts.com/test/ as an application folder.

  3. almny on May 15th, 2009 1:27 pm

    thanks man
    i get the same error and i will try your conection string now

  4. andy rooney on June 2nd, 2009 3:14 pm

    Anyone have a GoDaddy account? I need to migrate my shared servers to a dedicated server and not sure how all of that works.

  5. Vaibhav on September 10th, 2009 6:36 am

    GoDaddy Sucks yaar

    first it gave error on trust level,
    resolving that gave error on ajax control

    not it is giving the error described above.

    What the hell godaddy is!!!

    Whether same application running successfully on brinkster server

    thats URL is http://www.timecardsonline.com/App2

    can anybody, who has resolves the error send me web.config file on this issue?

    my mail id is vaibhav@golsonline.com

Leave a Reply