sql server 2008 db depolyment to shared hosting server

Posted on 2011-04-30
Last Modified: 2012-05-11
I am new to sql server.

I need to deploy a Sql server 2008 db from my local host to my Godaddy shared hosting.

I am using ms Visual Studio 2008 to deploy.

I can connect to the Godaddy server, but I get a error when I try to deploy. The database I am deploying has different tables than the db that is currently on my Godaddy server.

The db name and password are the same on local host and godaddy host databases.
Godaddy has not been much use so far.

Here is the error:
Error 1 The project could not be deployed to the '' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

(Yes I did check the server name)
Should this work? Or, am I totally lost.

Question by:williecg
    LVL 29

    Expert Comment

    by:Paul Jackson

    Author Comment

    thanks, but that solution is for sql server 2005 only.  I am using sqlserver 2008.
    LVL 21

    Accepted Solution

    Hey, please try to check to connect SQL SErver using Remotely. If possible then have some issue with database. otherwise credential problem is there.

    You can publish application manually. Publish it to local drive and copy-paste ti

    Author Comment


    thanks for your insight.

    my frame of reference is ms access.  i am new to sql server.

    it is more complex.

    i will check the connection string.

    what do you mean by manually publishing?


    Author Closing Comment

    I am still having problems, but I can connect now.  Thanks I will post new question in future

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now