|
Install SQL Server 2005 or SQL Server 2005 Express onto the Database Server In order to complete this part of the installation process, you need to install the database to your server, know how to create database users and know how to restore databases, and attach databases. If you have not already done so, at this point you have to install either SQL Server 2005 or SQL Server 2005 Express into your machine. You need to make sure that you have already installed the Dot Net Framework 2.0 onto your machine. You should also have used the Windows Update to make sure that you are using the latest Dot Net 2.0 Framework patch and that your system is current with updates before you continue.
If you are not familiar with SQL Server Express 2005, you may want to view this tutorial here: SQL Server Express 2005 Tutorial
Installing SQL Server 2005 Please follow the instructions that came with the SQL Server 2005 CD or defer this task to your systems administrator. During the install you may see a checkbox that says "Hide Advanced Configuration Options" you will need to make sure that this is not checked so you can see the configuration options that you need to adjust. The Integral Accounting Enterprise system uses SQL Server Based Security, not integrated windows, for a much better level of security. This means that your SQL Server 2005 implementation must have "Authentication: SQL Server and Windows" set in the Server Security Properties for the Enterprise Database to function properly. This is typically called "Mixed-Mode" If it is not enabled the software will not function. Once you are familiar with the construction of the Integral Accounting Enterprise System, you can change the passwords and users and such to your liking. Your default instance should be set to (local) which is the default setting during the installation. If you change this, and it is no longer set to (local), you will need to remember what you changed it to since you will need this information when you install the rest of the application and will have to modify the web.config files.
Installing SQL Server Express 2005: SQL Server Express 2005 is the free version of SQL Server 2005. You can use this in place of the standard or enterprise versions of SQL Server 2005 for smaller customers. Please follow the instructions that came with the SQL Server 2005 CD or defer this task to your systems administrator. During the install you may see a checkbox that says "Hide Advanced Configuration Options" you will need to make sure that this is not checked so you can see the configuration options that you need to adjust. The Integral Accounting Enterprise system uses SQL Server Based Security, not integrated windows, for a much better level of security. This means that your SQL Server 2005 implementation must have "Authentication: SQL Server and Windows" set in the Server Security Properties for the Enterprise Database to function properly. This is typically called "Mixed-Mode" If it is not enabled the software will not function. Once you are familiar with the construction of the Integral Accounting Enterprise System, you can change the passwords and users and such to your liking. SQL Server 2005 Express installs to an instance called "SQLSERVEREXPRESS" or "(local)\SQLSERVEREXPRESS" by default. You should leave this setting alone and accept the default. The software is pre-configured to use the (local) instance by default. If you are not using an Enterprise Manager to administer your database, most third-party database tools come with this feature, check your documentation for your particular database tool.
1) Enable Protocols: After you install SQL Server 2005, you may have to use the management tool that comes with SQL Server 2005 to make sure you enable the proper protocols for SQL Server 2005 to function properly. All of the protocols are disabled by default. When you enable protocols, you need to be sure that you do this in accordance with your site's security policies. The software requires the TCP/IP{ protocol to operate. 2) Create Database Users: You must create a user in the system named "enterprise" and this needs to be done before you install the enterprise databases. You can create the "enterprise" user in the master database using the user tool in the Enterprise Manager. Right click on the master database and select "New" then "User", When you setup the user, the username should be "enterprise" and the password should be "entx!2003n". 3) Verify your database installation: Before you proceed with the installation, you need to verify that the installation was done properly. Use a tool like Microsoft Access to connect to the database server, and make sure that you can connect to and read the sample databases that come with SQL Server 2005. If you are using SQL Server 2005 Express, you will not have the tools required to easily manage users in the database or attach databases to the installation. In this case, you can install the free management tool from Microsoft called SQL Server Management Studio Express CTP, and this will allow you to create the users and attach databases.
|