SQLS newbie - client tools - please help!

[AlbertAguirre]

I've been through the SQLS documentation and I cant figure out how to do this. Please help.

I am developing a web app and my web host has created my SQL Server database.
They asked that I use client tools to administer the database.
I cannot find "client tools" anywhere. I have SQLS 2000.

-Do I need to install client tools separatly?
-How do I configure a connection to the host to create tables?

Please help. Sorry about the newbie question...

 

[tlbroadbent]

Client tools are on the SQL 2000 CD. Run setup and walk through the selections to install the client tools.

You'll need to have an IP address to access the SQL server over the internet. The ISP may also need to provide a listen-on port of not using the default. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AlbertAguirre]

Thanks for the help.

I tried running install again and I realized that I chose "Install server and Client Tools"

So I must have Client Tools installed already.

Can you give me an idea on how to start up client tools?

Under the SQLS menu I have "Client network utility". I tried using this but I found no reference to a remote host.

Again, sorry about the stupid questions...

 

[tlbroadbent]

You should have a folder with shortcuts for several client tools. Most administrative work is done with Enterprise Manager (EM) and Query Analyzer (QA). Other tools are Profiler, Import/Export Wizard, Client Network Utility and Service Manager.

You should also find the SQL Books Online (SQL BOL) in the same folder. I suggest opening BOL and reading about the client tools. It would be just too much to try to explain how to use them in this forum. There are too many details that I'm sure to miss. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AlbertAguirre]

Tried using BOL. I ran a search for "client tools" and did not find anything useful.
Of course, I also have no idea what I'm looking for.

I assume with Client tools, I can set up IP address info for the remote server and somehow open a connection to the database that my host set up for me, but I cant find where to define that.
If you could give me steps as to how to do it, even if I dont know the terminology, then I could look it all up.
I need some structure to go by.

Thanks for your help...

 

[tlbroadbent]

You need to look up each tool individually using the names I provided.

Use the Network Utility to establish an alias name for the server. See the topic "SQL Server Network Utility" in BOL.

Open Enterprise Manager and register the server. Details are in BOL. Look in the Index for references to Enterprise Manager. one of the topics is "How to register a server (Enterprise Manager)."

You'll find SQL BOL is much better than Office/Access Help. It isn't perfect but is much more useful and it is easier to find what you need. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.