asked on

sql server 2008 db depolyment to shared hosting server

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.

Thanks,
Cgee

Paul Jackson

Have a look here : http://www.salmontraining.com/SqlExpressZone/articles/publish_sql_server_godaddy_shared_hosting.html

williecg

ASKER

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

ASKER CERTIFIED SOLUTION

Alpesh Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

williecg

ASKER

PatelAlpesh:

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?

Cgee

williecg

ASKER

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