Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Newbie: installed SQL Server 2000; now what?
Message
From
16/06/2003 12:34:35
 
 
To
14/06/2003 02:46:53
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00800086
Message ID:
00800376
Views:
17
>What I do have is the Enterprise Manager (& if I start the Enterprise Manager, and right click on the SQL Server Group, then 'register': I can see the name of the NT server).

That is a good start. If SQL was installed properly on the server it should start automatically when the server is started. You should not have to do anything from the client machine.

>I'm also now looking for a good book for a newbie like me, for taking care of the SQL server: assign users + passwords, assign rights to database & tables, how to keep SQL server running smoothly, how to backup, etc., but most importantly for now: what to do once the SQL server is installed, how to set up my local PC so I can manage all that + create database & tables, etc. from my local PC. Please recommend me a book.<

If you have Enterprise Manager on your local PC and can connect to the server, you have all the basics necessary to get started. the SQL Server "Books Online" (the online help) is actually a very good reference. However, I have also used "Mastering SQL Server 2000" (Gunderloy & Jorden, published by Sybex) for a hardbound reference. There are LOTS of other good SQL books available.
Dan LeClair
www.cyberwombat.com
SET RANT ON - The Wombat Blog

Life isn’t a morality contest and purity makes a poor shield. - J. Peter Mulhern
Disclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
Previous
Reply
Map
View

Click here to load this message in the networking platform