Main Links
 About Us
 Contact Us
 Downloads
 Home
 Price & Ordering
 Products
 Support
 Tech Bulletins (FAQ)
 Training
 Trial Versions

 Updates

Technical Bulletin  

Index of topics

Subject: Installing SQL2005
Date: February 21, 2008

 

Question: What options and steps should I take to install SQL 2005.

 

Answer: SQL2005 is the new release of Microsoft SQL Server database engine.  You can download directly from the Microsoft site at the following link:

https://www.microsoft.com/express/sql/download/default.aspx

 

We also recommend you download and install the SQL Server Management Studio Express (what a name) from the same Microsoft page.  It is a great tool for managing SQL databases.  SQL Server Management Studio Express also works with SQL / MSDE 2000.

https://www.microsoft.com/express/sql/download/default.aspx

 

We recommend installing directly at the server.  When installing through remote connectivity you could encounter security or other issues.  This does not mean it cannot be installed remotely but we are unable to provide assistance if remote installation issues arise.

 

You can install SQL 2005 over a prior version of SQL / MSDE.  The install program will simply upgrade to the newest version and keep all existing databases.  However, we do recommend you backup your databases first as a precaution.

 

You do not need to download the version of SQL with Advance Services or the Toolkit.  Before installing SQL 2005, you must be logged in with full Administrative rights.

 

The SQL Server 2005 install is fairly straight forward.  However, we recommend you take use the defaults of the installation prompts with the following exceptions:

 

1.  Uncheck the option to Hide Advanced Configuration Options

 

2. Select the Default Instance option.  Named instances will create much confusion later.

 

 

3. Select Mixed Mode authentication and enter a private password for the 'sa' (system administrator) account.  Be sure to keep the password as you may need it one day.

 

Taking these steps will keep the SQL Server installation simple by giving the SQL Server the same name as the computer.

 

Once the SQL Server 2005 is installed, you should also take the following steps:

 

1. Click on Windows Start / All Programs / Microsoft SQL Server 2005 / Configuration Tools / SQL Server Configuration Manager

 

2. Double click on SQL Server 2005 Network Configuration

 

3. Click on Protocols for MSSQLServer

 

4. Right click on TCP/IP and left click on Enable.  Do the same for Named Pipes.

 

5. Double click on SQL Server 2005 Services

 

6. Right click on Restart to restart the server using the additional protocols

 

7. Close SQL Server Configuration Manager

 

SQL Server 2005 will now be installed and ready for use.

 

 
© 2004-2007 Express Technology Inc.  All Rights Reserved.