Hello, Hoping someone can help me. I have a database in SQL Express 2010 that I'm trying to publish to the Winhost SQL 2008 server. In the Winhost-provided instructions below, I'm stuck on steps 3 and 4. Here are my questions: For step 3, where am I supposed to type the name on the database? I've opened the long script per step 2---then, in step 3, I don't know where I'm typing the database name. For step 4, do I start by using the "Connect" drop down menu (under object explorer on the right hand side of studio management)? My database is currently located on my own PC created in SQL Server Express and using Windows Authentication. If I change the server and authentication method, I can no longer access my database. Please help. Thanks. Winhost Instructions: To run the script that will publish your database to our SQL 2008 Server you will use SQL Server Management Studio Express or SQL Server 2008. Follow the steps below to publish the database to the Winhost SQL 2008 Server: 1.Open your database in SQL Server Management Studio 2008. 2.Click File/Open/File and navigate to the SQL script you just created from your SQL Server. 3.Type the SQL database name provided for you in Control Panel under Site Info Manager/MS SQL 2008/Manage. 4.Choose SQL Server Authentication in the "Authentication" drop down box. 5.Input your database login and password from Control Panel (see #3). 6.Once the script is opened, navigate to the very top of the page and type: ◦USE [database name] (without the brackets) ◦GO 7.Click the "Execute" button.
Step 3.. Choose the Script to file option and type the name of the script you will be generating. Click "Next." Is simply telling you to open the script you generated .sql file with SSMS. Where you able to generate the .sql file? If you did you will need to use SSMS to open it. Also look at this kb article how instructions on how to setup SSMS to connect to our SQL server. http://support.Winhost.com/KB/a689/how-to-connect-to-sql-server-2008-using-sql-server.aspx
