Hello, I am having difficulty publishing my database to the Winhost server using MS SQL server management studio 2008. At the top of the script i have USE <Winhost provided database name> and when I execute i get an error: Database 'Winhost provided database name' does not exist. Make sure that the name is entered correctly. This name doesnt come up on intellisense but i can see it listed on the server on the left, i have checked and double checked I have spelt it correctly. I have also tried using my local database name and this works but its not writting to the remote Winhost server, presumable its just overwritting my local database. Any help please? Im not a master of SQL server of databases and just want to get this up so my site works. Thanks, James.
Make sure your SSMS is connected to our SQL Server before you run the script. Try looking at this kb article. http://support.Winhost.com/KB/a689/how-to-connect-to-sql-server-2008-using-sql-server.aspx
