sql server 2008 db depolyment to shared hosting server
Posted on 2011-04-30
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.