1 / 38

Springlake BizFiles Professional Server Installation Guide (1)

Springlake BizFiles Professional Server Installation Guide (1). Server Installation Guide (1) shows how to install the pre-requisite before installing Springlake BizFiles Professional Server Install a database (SQL Server) Setup ODBC data source for SQL Server

isaiah
Download Presentation

Springlake BizFiles Professional Server Installation Guide (1)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Springlake BizFiles ProfessionalServer Installation Guide (1)

  2. Server Installation Guide (1) shows how to install the pre-requisite before installing Springlake BizFiles Professional Server • Install a database (SQL Server) • Setup ODBC data source for SQL Server It is assumed that an existing Springlake BizFiles Express Edition needs to be migrated/upgrade on the server.

  3. Pre-Requisite Prior to installing/upgrading to Springlake BizFiles Professional Edition, we need to install a database server and setup an ODBC data source. • Database Server • For Professional Edition, only MS SQL Server 2008 Express is supported. Can be downloaded from Microsoft’s website. • MS SQL Server 2008 requires Microsoft .NET Framework 3.5 which is already pre-installed on Windows 2008 but not for Windows 2003. • Note that the MS SQL Server 2008 32-bit installer can only be installed on 32-bit Windows OS and vice versa for 64-bit installer. • ODBC Data Source • Need to setup after database is installed. For this training, will be using Windows 2008 64-bit VM and SQL Server 2008 Express 64-bit.

  4. Pre-Requisite • MS SQL Server 2008 Express is needed to store the users, roles, permissions, content metadata, audit trails and some other system information • A database user is also needed to access the database. • In the following slides, we will show how to install and setup SQL Server 2008 Express • For the most part, default SQL Server 2008 settings will be used during installation. • The SQL Server Management Studio tool will also be installed.

  5. Installing SQL 2008 Express • Start the SQL Server 2008 Express installer (SQLEXPRWT_x64_ENU.exe) Choose “New Installation”

  6. Installing SQL 2008 Express Keep default setting Rectify error, if any

  7. Installing SQL 2008 Express Keep default setting Keep default setting

  8. Installing SQL 2008 Express Choose “Mixed Mode” authentication Set password for “sa” user. Do NOT forget password

  9. Installing SQL 2008 Express Installation in progress… Installation completed.

  10. Database Setup • Start the SQL Server Management Studio

  11. Database Setup • Login to SQL Server 2008 Express The server name is <computer name>\SQLEXPRESS Choose “SQL Server Authentication” Login using the “sa” user

  12. Installation Paths Next step: (Make sure all users has already log out from Springlake BizFiles Express Edition before starting) • Detach the existing Springlake BizFiles Express Edition database from SQL Server 2008 Express • Copy the database files (SL6CD.mdf and SL6CD_log.ldf) from the computer to the server. Attached the Springlake BizFiles database • Create 1 database user for Springlake database

  13. Database Setup (A) 1. To detach adatabase: Look for the SL6CD database. Right-click and select [Tasks->Detach] menu

  14. Database Setup (A) 1. To detach adatabase: Select [Drop Connections] checkbox. Click on [OK] to detach this database

  15. Database Setup (A) 1. To detach adatabase: The database [SL6CD] mdf and ldf files. After successfully detaching the database, copy the sl6cd.mdf and sl6cd_log.ldf files to the new server.

  16. Database Setup (A) 2. To attach adatabase: Right-click on the [Database] node and select [Attach…] It is assumed that the database file has already been copied to the new server.

  17. Database Setup (A) 2. To attach adatabase: Click on [Add] button to attach a database

  18. Database Setup (A) 2. To attach adatabase: Select the database to attach.

  19. Database Setup (A) 2. To attach adatabase: The selected database is displayed here. Click [OK] to attach the database.

  20. Database Setup (A) 2. To attach adatabase: The selected the database is attached.

  21. Database Setup (A) 2. To attach adatabase: We need to delete the existing user first before creating new user Open the “SL6CD” database node until the Security->Users->sl6. Right-click on the “sl6” node and select [Delete]

  22. Database Setup (A) 2. To attach adatabase: Click on [OK] to delete the user.

  23. Database Setup (A) 3. To create a new database login user: Right-click on the [Login] node under [Security] and select [New Login]

  24. Database Setup (A) 3. To create a new database login user: Set login name as “sl6” and password “springlake” Set the new user to use “SQL Server Authentication” Uncheck the [Enforce password policy] checkbox. Set the default database to “SL6CD”

  25. Database Setup (A) 3. To create a new database login user: Click on “Server Roles”. Set the minimum Server Roles as “public” and “dbcreator”

  26. Database Setup (A) 3. To create a new database login user: Click on [User Mapping page. Select the attached database and set role membership as “db_owner” and “public” Click on [OK] button to create the user.

  27. Database Setup (A) 3. To create a new database login user: The newly created database user “sl6”

  28. ODBC Data Source • Springlake server connects to the database via ODBC • Therefore, the matching ODBC driver for the database needs to be installed. For SQL Server 2008, it is already pre-installed. • The ODBC data source needs to be created.

  29. Configure ODBC Data Source Start the ODBC Data Source Administrator

  30. Configure ODBC Data Source Create the ODBC Data Source under the [System DSN] tab Select the SQL Server driver

  31. Configure ODBC Data Source Specify the data source name e.g. Springlake Specify the SQL Server name e.g. localhost\SQLEXPRESS

  32. Configure ODBC Data Source Use SQL Server authentication Specify the SQL Server login ID and password created earlier

  33. Configure ODBC Data Source Make sure the default database is selected

  34. Configure ODBC Data Source Use the default settings Click on [Finish] to create the data source.

  35. Configure ODBC Data Source The data source is created successfully. You can test it by clicking on the [Test Data Source] The data source tested successfully.

  36. Configure ODBC Data Source The new data source created under [System DSN].

  37. Data Files • Copy the data files from the old BizFiles Express edition data directory (default is C:\Program Files (x86)\SL6\data ) to the new server. • Then, set the data path to this new path using the Server Configuration tool.

  38. Thank You

More Related