SQL Enterprise Server 2005 is used to create and maintain the database instance needed by the SoftGrid system to track and collate usage, license and application statistics for the entire Organisation. This database is important for a number of reasons- without it, the SoftGrid Clients will default to disconnected mode, in which only applications stored in the local cache will be available for use. Additionally, this database allows for all reporting needs with regard to user access to applications.
The intended audience for this documentation is Systems Administrators, Workstation Management staff and other interested technical staff. This is only an example installation and a guide that can be used.
Based on SoftGrid Architectural concerns, it is estimated that a minimum of 40GB of usable storage space is needed to store the instance and approximately 730 days (2 years) of usage data.
SQL server 2005 requires Windows 2000 Server or above. In keeping with our overall system architecture, Windows Server 2003 R2 will be used for all SQL installations in this project.
IIS and ASP.net need to be enabled.
Join the machine to the Domain (it is needed)
Installing SQL server 2005 is relatively straightforward, with little variance from the defaults required. You will need a domain level administrative account, and in this case either the installation media or an executable copy of SQL Server 2005.
Step 1. Log in with your domain credentials. Locate either the CD-ROM or executable media
Step 2. Begin installation- double click 'setup.exe'. When prompted to accept licensing terms and conditions, check the box and click 'next'.
Step 3. Click 'Install' and wait for SQL Server to configure components and setup the installation. Once the required components (.NET Framework 2.0, MS SQL Native Client and the SQL Server 2005 setup support files) have been installed click 'Next'.
Step 4. Click 'next' when prompted with the screen 'Welcome to the Microsoft SQL Server Installation Wizard. The installation will then proceed through the 'System Configuration Check'- click 'next' to proceed.
Step 5. Registration Information
Name: Any Authorised User
Company: Any Authorised Company
Step 6. Components to Install- Select all components (SQL Server Database Services, Analysis Services, Reporting Services, Notification Services, Integration Services, Workstation components) , then click 'next'
Step 7. If this is the first installation of a new database instance for SQL server, select 'Default Instance'. (If this is a second or further installation of SQL server, such as for a clustered server farm, contact the SQL database administrator for relevant database information) then click 'Next'.
Step 8. Service Account-
Use a Domain Account (See SoftGrid or Active Directory Administrator)
Domain- contoso.com (or whatever domain is relevant for the circumstance)
Start services at the end of setup-
SQL Server, Analysis Services, Reporting Services, SQL Browser
Step 9. Authentication Mode-
Mixed Mode (Windows Authentication and SQL Server Authentication)
Sa account password: S0ftgrid1
Step10. Collation Settings
Keep the default settings (SQL Collations- Dictionary Order, case-insensitive, 1252 character set)
Step 11. Report Server Installation options
Install the default configuration
Step 12. Error and Usage Report Settings
Leave defaults (none checked)
Step 13. Check installation Settings, click 'install'. Once the installation process is completed, click 'next'
Step 14. Select the 'Surface Area Configuration Tool'; then 'Surface Area Configuration for Services and Connections'
Select 'Database Engine'; 'Remote Connections'
- 'Local and Remote Connection'- 'Using both TCP/IP and named pipes'
- click 'Apply', receive the message stating 'changes will not take effect until you restart the Database Engine service'- click 'Ok', then 'Ok' once more.
- click 'finish'
Step 15. Open 'services.msc' and restart the SQL server service.
Step 15.1 Install SQL Server 2005 SP1 and make sure to stop ALL the SQL services and the Network Connections service to avoid locked files. When done, restart the server.
Step 16. Connect to the server and go to the Security / Logins and create a new SQL account called softgrid
Step 17. Select "Sql Server Authentication", enter the same password than above and untag "Enforce password expiration" then select the default database as tmpdb for the time being.
Step 18. Migrate the softricity database using the SQL Wizard (right click on one of the database then select Tasks and Copy database on the server you want to migrate from). If the Softricity database already exists on the target server, delete it otherwise the migration will create a Softricity_new database.
Step 19. When the database is migrated, make sure that the user softgrid has the rights on it and you can remove the user from the tmpdb database and select softricity as the default database.