Totally newbie help for MSSQL

[nettproffen]

Hi there.

I `m totally new to mssql server, and need some basic help.

I have downloaded and installed MSSQL server 2000 and enteprise manager on my local computer. Then I have upzized a access db to SQL server and installed it on my localhost mssql server. This works ok.

No - next step is to get this online on the internet.

I have paid and got a MSSQL server db at a ISP.
They have then provided me with login info and server name.

Can anyone now tell me - step by step - on how to get my local mssql db online on the internet, connected to my webpage?

Thanx in advance.

Bjørn-T

 

[nomadicalloy]

Did you get instruction from your ISP to connect sql enterprise manager to online sql db? if yes then use DTS to transfer local db to online db.

please look at following links

http://www.interspace.net/sql2000.html

http://www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp

http://www.tnsites.com/support/s_sql2000dbbak.asp

SQL Help Blog

http://www.xpherion.com/blog.asp

 

[nettproffen]

Hi.

Thanx.

A lot of useful info there.

I still cant connect to my db, "login failed for user..."
So i guess i must check my ISP account info first.

Thanx.

Bjørn.