I just want to simply upload my database to a Web Hosting service. I’d like to be able to see both databases local and on Web Host, and just copy and paste.

I’ve received some responses, but either they didn’t work for me, or I did not understand them completely. Please assume nothing about my level of intelligence.

I’m new to doing this, but can anyone walk me through some simple steps on uploading my local database from my PC (has tables and stored procedures) to my Web Hosting Service SQL Server.

I’m a unemployed home user with few $$$ to spend, but can consider purchasing a cheap utility if that’s what this takes, and I am open for suggestions on database management utilities.

Also, I already tried one utility that had a login screen, but when I tried to logged in to my local database, I kept getting “Not associated with a trust SQL Server.” Can someone also tell me on my PC (step by step) how I can become associated with a trusted SQL Server?

My local PC has installed:
MSDE 2000
Visual Studio .NET Professional Academic 2002 & 2003

Web Hosting Service has setup a Microsoft SQL Server database for me.

Thank you!!

Hi,

The problem you are facing about the trusted SQL server connection is because of by default installation mode MSDE. You need to change the MSDE authentication mode to SQL server Based authentication from the by default Windows integrated authentication mode. There is one possible solution at the Microsoft Knowledge Base. These articles will give you in-depth information on the various topics such as changing the MSDE authentication mode From Windows integrated to mixed mode at the time of installation and even after the installation. Just browse the two URLs give below.

http://support.microsoft.com/default...b;en-us;319930


http://support.microsoft.com/default...b;en-us;322336

The first URL will contain the information about your problem, while the latter one will give you the information on SA PASSWORD settings related information.

Hope this will help you.

Charul Shukla