The web blog http://www.learnsccd.com strives to be a comprehensive guide to SCCD, TADDM, SERVICE NOW and MAXIMO tools. This is a personal site maintained solely by me. I intend to update it regularly.For live updates please follow us on.

Manually configuring Microsoft SQL Server 2014

Manually configuring MS SQL Server 2014


1. Configure the listener port.
If the default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. Named instances of the Microsoft SQL Server Database Engine and Microsoft SQL Server Compact Edition are configured for dynamic ports, which means they select any available port when the service starts. When connecting to a named instance across a firewall, configure the Database Engine to listen on a specific port, to open this port in the firewall.
a. Open Programs > Microsoft SQL Server 2014 > Configuration Tools > SQL Server Configuration Manager
b. From the Microsoft SQL Server Configuration Manager Navigation pane, expand SQL Server Network Configuration > Protocols for <instance name>, and then double-click TCP/IP.
c. In the TCP/IP Properties dialog box, click the IP addresses tab.
d. For each IP address listed, ensure that the TCP Dynamic Ports field is blank. If the TCP Dynamic Ports field contains a value of  0, that IP address is using dynamic ports. Since Maximo 7.6  requires Microsoft SQL Server to listen on a static port, this field must be blank.
e. For each IP address listed, enter 1433 for the TCP Port field.
f. Click OK.
g. From the SQL Server Configuration Manager Navigation pane, click SQL Server Services.
h. Right-click SQL Server (<instance name>) and then click Restart, to stop, and restart Microsoft SQL Server.
i. Verify the Microsoft SQL Server instance is running, and then close SQL Server Configuration Manager.
2. Verify that you enabled the Full-text Search setting during the installation of Microsoft SQL Server 2014. To determine if Full-text Search is installed on your existing Microsoft SQL Server database, perform the following steps:
a. Open SQL Server Management Studio, select SQL Server Authentication as the authentication type, and enter the credentials for the sa user ID, and then click Connect.
b. Click New Query.
c. Type the following command:
select FULLTEXTSERVICEPROPERTY ( 'IsFulltextInstalled' )
If you did not install Full-text Search (the resulting value is zero), you must do so at this time. To install Full-text Search, insert the Microsoft SQL Server 2008 product media into the system and start the installation wizard. Navigate through the wizard and enable the Full-Text Search option located on the Custom portion of the Setup Type dialog box. To finish the installation process, restart the server.
3. Create a Microsoft SQL Server Database.
a. Open SQL Server Management Studio (Start > Programs > Microsoft SQL Server 2014 > SQL Server Management Studio)
b. Right-click the Databases folder from the navigation tree, and select New Database.
c. In the Database name entry field, specify a unique database name (for example maxdb76)
d. For the maxdb76 Logical Name, change the Initial Size (MB) attribute to 500 (MB), and also set the value of the Auto growth field to By 1MB, unrestricted growth.
e. If you prefer, modify the log settings to accommodate your production environment.
f. Click OK.
4. Create the Maximo® User for Microsoft SQL Server.
a. Open Microsoft SQL Server Management Studio (Start > Programs > Microsoft SQL Server 2014 > SQL Server Management Studio)
b. Click New Query.
c. Select the maximo 7.6  database (maxdb76) from the Available Databases menu,
d. Enter the following script to create the Maximo database user MAXIMO with a password of  MAXIMO.
e. sp_addlogin MAXIMO,MAXIMO
go
This value is case-sensitive.
f. Click Execute.
g. Enter the following script to change the database owner to maximo.
h. sp_changedbowner MAXIMO
go
i. Click Execute.