User Tools

Site Tools


sql_2005_express_configuration

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sql_2005_express_configuration [2014/08/22 19:50] (current)
Line 1: Line 1:
 +=== SQL 2005 Express Configuration ===
 +A default installation of SQL Server 2005 Express edition will not work as the database server for Evolynx RADIUS. In order to allow the Evolynx setup program to install the database and the Evolynx Server and Admin programs to access the data, there are some configuration changes necessary. \\
 +SQL Server Express default configuration does not listen to the default TCP port 1433. To verify your SQL server is listening on port 1433, open a Command Prompt window and run this command:
  
 +<​code>​netstat -ano | findstr 1433</​code>​
 +
 +If you see an entry in this list with the text "​LISTENING",​ it means SQL Server is correctly configured to listen to port 1433 (or your selected port). If you do not see this entry, continue with following instructions:​
 +
 +  - Use Start menu to find and execute "SQL Server Configuration Manager"​.
 +  - Expand the node "SQL Server 2005 Network Configuration"​
 +  - Click on "​Protocols for Instance Name" (default Instance Name is SQLEXPRESS)
 +  - Right-Click on TCP/IP and select Properties
 +  - Click on "IP Addresses"​ tab
 +  - Make sure IP1 and IP2 are Active and Enabled
 +  - Clear the value in front of "TCP Dynamic Ports" (everywhere)
 +  - Set the "TCP Port" to 1433 or any other port number you choose (everywhere)
 +  - Apply changes
 +  - Re-start the service as prompted
 +  - After making these configuration changes, run the above "​netstat"​ command to verify SQL server is listening on port 1433 (or your selected port).
 +
 +When installing Evolynx Server database, enter complete "​Server name\Instance Name". Also, specify port number (1433 or your selected port number), Asmin User name (sa), and related password.
 +It is very important to modify the Connection String in both (server and admin) configuration files to include instance name and port number. Following example can be used with a default installation of SQL Express on the same computer as the Evolynx runs:
 +
 +<​code>​localhost\sqlexpress,​1433</​code>​
sql_2005_express_configuration.txt ยท Last modified: 2014/08/22 19:50 (external edit)