|
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.
|
