Menu

• Home
• IP-Phone Pages
• ASP.Net Pages
  
• MS SQL Pages
• SQL Re-Install
• SQL De-Install
• SQL Install
• SQK Upgrade (SP-4)
• Linux Pages
• Javascript Tips
• Jtech's Misc. Tips
• Robert

Welcome to our SQL Series of pages.

We use SQL here at Jtech for various purposes. - One is for the ASP.Net Login control where we store user's login access data.

There are various 'flavors' (or distributions) of SQL ranging from the free 'Open Source' versions to the more exensive ones.

On our Windows 2003 server we have two SQL servers running, a version of 'MySQL' and a full copy of 'MS SQL 2000'. - Yes, you can have more than server running at the same time.

For these series of pages, we'll start off only discussing the Microsoft SQL Server(s).

The Microsoft SQL Servers.

Microsoft makes a whole series of SQL servers. - And keeping track of them all can be mind boggling! -

I'll only mention the three MS SQL servers I've had experience with getting the ASP.Net Login control to work.

• MS SQL Desktop Engine (SDE). - This is by far the most free of MS' freebies. - But OMG! - It is severly limited but will work with (very small) web sites and a very small (less than 8) simultaneous users with any acceptable performance.

  I tried it because the company who supplies my server also supplies the 'Plesk' control panel. - And 'Plesk' uses SDE if Plesk users want to set up SQL databases from within Plesk. - Since I never do, I deleted it.

  If you wish, you can read a little more about it here: http://en.wikipedia.org/wiki/MSDE

• MS Server #### Express. - This is a much better 'freebie' from Microsft than the SDE. - If you don't want buy a 'full blown' MS SQL server, this is the one to get. - There are two versions I know of (2005 & 2008) and I've only had experience with '2005' (but '2008' will also work for ASP.Net Login). - You can download this from Microsoft by going to this site: http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

  Two things to note about this SQL server:

  • It installs with NO password for the 'sa' account!! - The 'sa' account is the 'server administrator' used to set up databases, users, etc. - A smart hacker could get into your server and cause havoc. - Make sure you 'lock down' the 'sa' account with a password after you install it!

    There is no desktop 'GUI' for administration. - You'll need to get something like the MS SQL Server Management Studio Express (it's also free). - You can get it from this site: http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

  • MS SQL Server 2000. - This is a full blown SQL server that you would have to buy from Microsoft. - I'm not sure if MS SQL 2000 is still available for purchase. - You may have to go with one of the newer ones. - However, you'll not need any 'helper' applications (such as a desktop 'GUI').

For the remainder of these pages, we'll only address the MS SQL Server 2000. - Of course, if you have another version, you're welcome to follow along but your mileage may vary.

Next Page - SQL 2000 de-insall/install/upgrade