Support
Home > Support > Tech Support Topics > Installing SQL Server 2005

Installing SQL Server 2005

There are several things you must do if you will not be using the SQL Server 2005 Express that VersaForm installs.

If you do not understand any of these steps, you should seek qualified technical help.

During the SQL Server Install

  1. Install the SQL Server as a named instance, using any name you choose.
  2. Select both Windows and SQL Server authentication.
  3. Write down the password that you assign to the System Administrator (sa) account as you will be asked for the password during the VersaForm install.

After the SQL Server Install

  1. If you will have any client workstations, ensure that your firewalls will allow access to the SQL Server.
  2. From your Programs menu, under Microsoft SQL Server 2005, Configuration Tools, start the SQL Server Surface Area Configuration tool.
  3. Choose Surface Area Configuration for Services and Connections.
    • Click on the SQL Server Browser and set the Startup type to Automatic.

    • Open the Database Engine, and click on Remote Connections.
    • Choose Local and remote connections.
    • Choose Using both TCP/IP and named pipes.

    • Click OK to close the Surface Area Configuration for Services and Connections window.
    • Close the SQL Server Surface Area Configuration window.

  4. From your Programs menu, under Microsoft SQL Server 2005, Configuration Tools, start the SQL Server Configuration Manager.
    • If necessary, click on SQL Server 2005 Network Configurator to open it.
    • Click on Protocols for XXX where XXX is the name you chose for your SQL Server during the install.
    • Right click on each of Shared Memory, Named Pipes and/or TCP/IP that shows a Status of Disabled and choose Enable.

    • Close the SQL Server Configuration Manager.