Should one even try to install SQL Server 2000?

[gusbrunston]

[tt]
Hi:

I have been programming in Basic, Visual Basic, and Access 97, 2000, 2002 for some years. I have had a copy of MS Office XP Developer for about a year, and I would like to experiment with developing one or more stand-alone programs.

I find the documentation for the installation of a server almost overwhelming.

For example,[/tt]

"-------------------------------------------------
2.6 Requirements for Active Directory Integration
-------------------------------------------------
To register an instance of Microsoft SQL Server 2000 in
Active Directory, the instance of SQL Server must be installed on a computer running Microsoft Windows 2000 with the Active Directory service enabled. The SQL Server service must also be configured to run under either the Windows LocalSystem account or a Windows domain account in the local administrators group. This requirement must be met to add databases and publications from the instance to Active Directory. Instances of SQL Server 2000 configured to run under a power user account
do not have sufficient permissions to invoke all of the
SQL Server components required to work with Active Directory."

[tt]I tried to find out if on my computer the Active Director service was enabled (through Administrative Tools, in the Control Panel). I couldn't find Active Director service, but I did find a lot of errors represented by white x's in red circles.

I'm really discouraged about this. I don't have time to learn a discipline that's going to take a lot of time.

My question: Once I get through the installation process, is there a lot more maintenance to be done for using the server? And should I just forget the whole thing? And how could anyone answer that. Just frustrated right now I guess.

Need your encouragement or discouragement I guess.

Thanks for reading this,

Cheers,[/tt]

[tt]Gus Brunston - Access2000(DAO Intermediate skills.
Webmaster: www.rentdex.com[/tt]

 

[nigelrivett]

Ignore all this - if it affected you you would probably know about it. Sql server is very simple to install.

Get the evaluation version - or better developer version (about $50) and just install it.

During installation use the local system account and give an sa password. Enable mixed security and that's about it.

The only thing to be cautious about is that you will have to set all databases to simple recovery model (setting model database will default all new databases).

Good luck.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[nigelrivett]

forgot something very important - make sure you install service pack sp3 or sp3a.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[SQLBill]

You don't need Active Directory to install SQL Server 2000. BUT if you do have Active Directory, then you need to follow those directions.

Question: What OS do you have?
You can only install Personal, MSDE, and Developer on 'workstations', all other versions have to be installed on a system with a SERVER or DATACENTER OS.

-SQLBill

 

[gusbrunston]

[tt]
Hi:

Thank you for your attention to my petulant thread. I did install sp3 (it was on a disk that came with Office XP Developer). My computer OS is W2K pro.

I went to the download site for SQL Server and saw there were some 286 downloads available, including one sp3a.exe.

I have to leave this whole process and get back to work. I may someday have an opportunity to come back to it. In the meantime we have Office XP on the workstations for the front end, and our back end on one network computer for the database is not broken, is fast enough for all purposes, so I think I'll just stay in my slot for a while. Maybe later I'll go to med school, or become a rocket scientist, or learn SQL Server, whichever is easier. Who knows?

Thanks again for your suggestions.

Cheers,

[tt]Gus Brunston - Access2000(DAO Intermediate skills.
Webmaster: www.rentdex.com[/tt]