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!!

You say you want to be able to "see" both databases - see them where?

As for "trusted authentication", SQL Server has two authentication modes. Windows Authentication (where you login to SQL Server based on your Windows account) -and- Mixed Mode Authentication (which allows both Windows login, and the creation of SQL Server only logins).

If you are getting the "not associated with a trusted connection" error, then SQL Server is running in Windows authentication mode. You need to grant permission for your Windows account to login to SQL Server.

Cheers
Ken

www.adOpenStatic.com

Ken,

Will you show the steps how to grant permission for my windows account to login to SQL Server (MSDE 2000)? I have the same problem.

Thanks a lot,

Diana ([email protected])


Diana

Hi all
I have found one possible and immediate 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.