|
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 our website at the following link.
Click here to download SQL
Server 2005.
If you are running Windows 7, you will
need to download and install SQL Server 2008 Express directly from the
Microsoft website -
click here.
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 works with
SQL2005, SQL2000 and SQL7.
Click here to download SQL Server Management Studio Express.
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
information below explains the best options for installing SQL Server
and enabling TCP/IP protocol
for SQL Server.
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 to
Enable TCP/IP:
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
Be sure to note the name of the SQL
Server as you may need it when connecting ExpressMaintenance the first
time.
SQL Server 2005 will now be installed and
ready for use.
For more information on recommended SQL
2005 Server Properties - click
here.
|
