How to install SQL Server 2005 Express to use with SOAPware 4.X

SQL SERVER 2005 EXPRESS SP2 INSTALLATION\SETUP.

SQL Server 2005 Express is the free version of SQL Server 2005 & has the same limitation of MSDE (free version of SQL Server 2000).  MSDE will not install on Windows VISTA, so SQL Server 2005 Express will have to used as your database engine on VISTA.  Just like MSDE, SQL Server 2005 Express has a 2GB limit per database.

 

1. Download SQL SERVER 2005 EXPRESS SP2 & double click on the file to start the installation or start the installation from the CD if you got it. 
2. Files will be Extracted, then you will need to Agree to the license agreement by clicking the check box by “I accept the licensing terms and conditions” > click Next. 
3. The Installing Prerequisites screen will appear > click Install, a few drivers will install, you will get a message stating "The required components were installed successfully" once complete, click Next.
4. The System Configuration Check screen will appear & scan the computer, click Next. 
5. The Install Wizard screen will appear, click Next. 
6. Several Items will be installed, then the Registration Information screen will appear, enter something for the Name & Company and uncheck "Hide advanced configuration options."  

7. The Feature Selection screen will appear, click the down arrow on Connectivity Components > then click "Will be installed on local hard drive" > if you would like to install to a specific drive or folder click Browse & make your selection > once finished click Next.  

8. The Instance Name screen will appear, select "Default Instance" (SQLEXPRESS is default) or if you have a preference select "Named Instance" & enter a name (SWDATA, SOAP, etc...), once complete click Next.

9. The Service Account screen will appear, select "Use the built-in System account" > make sure both services are checked "SQL Server" & "SQL Browser"

10. The Authentication Mode screen will appear, click "Mixed Mode (Windows Authentication and SQL Server Authentication)" and enter a password (soapware, soapware1, etc...) for the "sa logon" > click Next.  It's very important you remember\record this password.

11. The Configuration Options screen will appear, make sure "Enable User Interfaces" and "Add user to the SQL Server Administrator role" are checked > click Next.

12. The Error and Usage Report Settings screen will appear, uncheck both options > click Next.

13. The Ready to Install screen will appear and state was items are about to be installed > click Install.

14. The install will commence and get a green check mark once complete, after all are complete the Next button will become available > click Next.

15. Finally > click Finish.  You are finished with installing SQL Server 2005 , however, now the connections must be enabled so that it can be used.

SQL SERVER 2005 CONFIGURATION.

 

1. Open the Configuration Manager, Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
2. Click the + button next to "SQL Server 2005 Network Configuration," Protocols for SQLEXPRESS will appear.   
3. Click on TCP\IP > right-click, then click Properties > on the Protocol Tab, make sure Enabled is set to "Yes" > on the IP Addresses Tab, make sure Enabled is set to "Yes" for IP1, IP2, etc... > click Apply then OK once finished.  
4. The SQL Service will now have to be restarted, click on "SQL Server 2005 Services" on the main screen > on the right click on "SQL Server (SQLEXPRESS)" > right-click, then click RESTART. 
5. The "Stopping service..." status bar will appear, then immediately flash over to the "Start service..." status bar.  If there is a green triangle next to "SQL Server ((SQLEXPRESS)" then the Configuration is complete & you can close out of the SQL Server Configuration Manager.

    

To finish the SERVER install, you will need to install the SQL DATA MANAGER which will attach the databases.