Savance
Phone: 248-478-2555 | Fax: 248-478-3270 www.savanceenterprise.com
© 2014
Table of Contents
Software Programs Needed 3
Create Folders 3
Install SQL Server 4
Configure SQL 13
Open Ports 22
Conclusion 22
Software Programs Needed
Microsoft Server 2003 or Later
Microsoft SQL Server 2005, 2008, 2008 R2, 2012: Express, Workstation, Web, Standard, Enterprise, or Datacenter
Create Folders
Identify the largest drive and create a folder called ‘Savance’ as shown below.
Within the ‘Savance’ folder, create the following folders as shown below.
Unzip the C:\Savance\Releases\{Latest Release}\Web\Web.zip file into the C:\Savance
\Web folder you created. The copy over the contents of the C:\Savance\Releases\{Latest Release}\Web\Web_ToBeMerged\ folder to the C:\Savance\Web folder, if those files don’t already exist.
You will want to make sure that you Share the following folders with everyone on the network
eDocs - Read/Write access OSSetup - Read access OSSync - Read access
Install SQL Server
***This is only for installing SQL on a server that does not already have SQL
installed on the default instance. The screenshots and instructions apply to
SQL Server 2008 but should apply to all versions.
Requirements (Depends on version of SQL being installed. Refer to Microsoft’s Website for more exact requirements)
Microsoft 2003 Server Service Pack 1 or Higher .NET Framework 3.5 Service Pack 1 or Higher
Install SQL Server
Download and install your selected version of SQL Supported versions
o Microsoft SQL Server 2005, 2008, or 2008 R2 Express, Workstation, Web, Standard, Enterprise, or Datacenter
Installation
Choose: New SQL Server stand-alone installation or add features to an existing installation
Setup Support Rules (all passed)
Choose: next>
Enter Product Key
Choose: next>
Setup Support Files
Choose: Install
Agree to the License Terms
Choose: next>
Setup Support Rules (all passed)
Choose: next>
Feature Selection
Choose:
Full Text Search
Client Tools Connectivity
SQL Books Online (called Documentation Components in SQL Server 2012) Management Tools - Complete
Choose:next>
Instance Configuration
Choose: Default Instance
Choose:next>
Disk Space Requirements
Choose:next>
Server Configuration
SQL Server Agent
Service: NT Authority Network Service Password: Not Required
Startup: Manual
SQL Server Database Engine
Service: NT Authority Network Service Password: Not Required
Startup: Automatic
SQL Server Browser
Service: NT Authority Local Service Password: Not Required
Startup: Disabled Choose: next>
Database Engine Configuration
Authentication Mode
Choose: Mixed Mode (SQL Server Auth and Windows Auth) Password: **********
Note: Enabled on domain controllers and disabled on stand-alone servers.
The password must be at least 7 characters on domain controllers and 0 on stand-alone servers.
Not contain the user’s account name or parts of the user’s full name that exceed two consecutive characters.
Contain characters from three of the following four categories:
o English uppercase characters (A through Z) o English lowercase characters (a through z) o Base 10 digits (0 through 9)
o Non-alphabetic characters (for example, !, $, #, %)
o Complexity requirements are enforced when passwords are changed or created
Specify SQL Server Administrator Choose: Add...
Choose: Advanced Choose: Find Now Under Name (RDN) Choose: Users Choose: next>
Choose: next>
Installation Rules
Choose: next>
Ready to Install Choose: Install
Configure SQL
*Enable TCP/IP and Named Pipes to network configuration
Go to SQL Server Management Studio
1. Open the SQL Server Configuration Manager (Start > SQL Server 2008 >
Configuration Tools > SQL Server Configuration Manager)
2. Navigate to the SQL Server Network Configuration > Protocols for MSSQLServer node in the tree view
3. Enable TCP/IP and Named Pipes (you’ll be warned that these changes will not apply until the service is shutdown)
4. Restart the SQLServer Service
Create Database in SQL Server
Launch the SQL Server Management Studio
Connect to the Server
Choose Authentication: SQL Server Authentication Login: sa
Password: *******
Choose: Connect
Create New Database
Right Click on Database and select > New Database
Database name: SolutionSavant
Change the path to: C:\Savance\Database (or wherever you placed the savance folder)
****Do this for both the Database file as well as the log file
Choose: OK>
Database Created
Create Database User
Drill down into the SolutionSavant database > SolutionSavant > Security > Users Right Click on Users > New User
Type Username > Enterprise Type Login > Users
Add user to Owned Scheme > db_owner Add user to Role Member > db_owner
Create SQL Database User
Drill down into the Security folder of the Server> Server Name> Security > Logins Right Click on Logins > New Login
Open Ports
The following port numbers need to be opened so that the Enterprise application can properly communicate with the server.
1433 - SQL Server 8734 - Savance Server
Conclusion
This concludes the customer setup process. Your Savance Enterprise install specialist will take over from here. Please contact them for further details.
Savance
Phone: 248-478-2555 | Fax: 248-478-3270 www.savanceenterprise.com
SE-SG-Server 1.0.0
