sql server 2008 db depolyment to shared hosting server

Posted on 2011-04-30
Medium Priority
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 'wizard001.db.7782197.hostedresource.com' 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
  • 3
LVL 29

Expert Comment

by:Paul Jackson
ID: 35498500

Author Comment

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

Accepted Solution

Alpesh Patel earned 2000 total points
ID: 35502912
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 goddady.com

Author Comment

ID: 35509676

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

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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 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