Microsoft SQL Server Installation

The SemmleCode plugin supports Microsoft SQL Server 2005 Express on Windows.

 

Windows

    
Quick Install Instructions
Step-by-step Install Instructions
Configuring a pre-installed database 		   


Windows Quick Install

  1. Download Microsoft SQL Server 2005 Express from microsoft.com. Download and install the .net 2.0 framework as well if needed.

  2. Run the installer, and when prompted set authentication to mixed mode. Set the password for the sa superuser, and remember this password for later use in the SemmleCode setup wizard.

    It is recommended that you set the authentication mode at installation. Setting it after installation requires modifying the registry: http://support.microsoft.com/kb/319930/en-us

  3. Continue the install with the default options. Once the installation completes, enable TCP connections to the SQL Server instance, and ensure that it is listening at 127.0.0.1:1433.

  4. Restart the SQL Server Express service.

  5. Installation and configuration of SQL Server Express should now be complete. Continue by setting up the database for SemmleCode's use.

Windows Step-by-Step Install

  1. Download Microsoft SQL Server 2005 Express from microsoft.com. Download and install the .net 2.0 framework as well if needed.

  2. Start the install wizard for SQL Server Express. Continue until you reach the "Registration Information" section.

  3. At the Registration Information section, fill in your details, and check Hide advanced configuration options.

  4. At the Feature Selection section, proceed with the default options.

  5. At the Authentication Mode section, set the authentication mode to Mixed Mode, and enter a password for the sa administrator login. Remember this password for use with the Semmlecode Database Setup Wizard later.

  6. At the Configuration Options section, proceed with the default options.

  7. At the Error and Usage Report Settings, proceed with the default settings.

  8. Once all the settings have been chosen, click on install to begin the installation of SQL Server Express.

  9. When installation is complete press the finish button to exit the SQL Server Express installer. We now need to configure SQL Server Express to listen on a TCP port.

  10. Start the SQL Server Configuration Manager (Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager).

    Expand the SQL Server 2005 Network Configuration entry and select Protocols for SQLEXPRESS. Bring up the Properties right-click menu of the TCP/IP entry.

  11. At the Protocol tab of the TCP/IP properties dialog, set Enabled to yes and Listen All to no. This makes SQL Server listen on a particular address and port, instead of all the addresses of your machine.

  12. Still at the same dialog, but in the IP Addresses tab, find the entry that contains the localhost address (127.0.0.1). Set Active and Enabled to yes, TCP Dynamic Ports to blank, and TCP Port to 1433. This will make SQL Server listen to TCP connections only on the localhost address, port 1433. Then click OK to apply the changes.

  13. Finally, the SQL Server must be restarted for the changes to take place. Select the SQL Server 2005 Services entry, then right-click on the SQL Server (SQLEXPRESS) entry and restart the database.

  14. Installation and configuration of SQL Server Express should now be complete. Continue by setting up the database for SemmleCode's use.


Configuring a Pre-installed Database

  1. First, ensure that your MSSQL database is configured to accept connections using mixed mode authentication. You can do this using SQL Server Management Studio Express if you have it installed.

    Run Management Studio and logon as the system administrator to the server you wish to use with SemmleCode. Then right click on the server entry in the Object Explorer tree and select Properties.

    In the Security page of the Properties dialog, make sure that SQL Server and Windows Authentication Mode is selected, then click Ok.

    You will have to restart your server if you had to change the server authentication.

    If you do not have Management Studio installed, you will have to manually change a registry key to enable mixed mode authentication. Instructions can be found on the Enable Mixed Mode authentication after installation section of this article: http://support.microsoft.com/kb/319930/en-us.

    Again, you will have to restart your server if you changed the existing LoginMode value

  2. Next you will have to check that your server accepts TCP connections at the localhost address. Start the SQL Server Configuration Manager (Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager).

    Expand the SQL Server 2005 Network Configuration entry and select Protocols for SQLEXPRESS. Bring up the Properties right-click menu of the TCP/IP entry.

  3. At the Protocol tab of the TCP/IP properties dialog, set Enabled to yes and Listen All to no. This makes SQL Server listen on a particular address and port, instead of all the addresses of your machine.

  4. Still at the same dialog, but in the IP Addresses tab, find the entry that contains the localhost address (127.0.0.1). Set Active and Enabled to yes, TCP Dynamic Ports to blank, and TCP Port to 1433. This will make SQL Server listen to TCP connections only on the localhost address, port 1433. Then click OK to apply the changes.

  5. Finally, the SQL Server must be restarted for the changes to take place. Select the SQL Server 2005 Services entry, then right-click on the SQL Server (SQLEXPRESS) entry and restart the database.

  6. Installation and configuration of SQL Server Express should now be complete. Continue by setting up the database for SemmleCode's use.