Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

How to Download and install primavera p6 and configure SQL as the database
Download the Primavera p6 8
...
2 through this below link
http://www
...
com/file/2qn28z09az0tw5l/Primavera+P6
...
3+setup
...
Click Install

Click Run

Click Next

Choose Advance option for a 64 bit OS

Change location to avoid certain issues to connecting to database
...
3
...
And install SQL
server 2008 R2 according to this following procedure
...
microsoft
...
aspx?id=22973
File name: SQLEXPRWT_x64_ENU
Then Right click the setup file -> Run as Administrator
SQL Server installation center dialog box appears and continue

Select the New installation option

Accept the terms and click NEXT

IF you see this message, do this:
- Download update KB968930
[http://www
...
com/downloads/details
...

- Once installed, click ‘Re-run’
...

Password = your password for your Windows account
...

Click NEXT
...

Enter a password of your choosing and make a note of it
Click NEXT
...


Go to SQL server management Studio
Change Authentication to ‘SQL Server…’
Login is ‘sa’
...
A successful login of
the Management Studio proves you now have a working SQL Server Express instance on
your machine
...


How to set the TCP/IP port in your new SQL Express instance:
1
...
In the Configuration Manager, select the SQL Server Network Configuration |
Protocols for SQLEXPRESS

3
...
Click OK to the resulting prompt – you will
restart the service after the next steps
...
Right-click again on TCP\IP and choose Properties
...
In the TCP\IP Properties dialog, click on the IP Addresses tab, scroll to the
bottom of the dialog and then enter 1433 in the last field at the bottom of the
dialog labeled TCP Port
...
Click OK and again click OK to the prompt
...
Now restart the SQL Server Service to have your changes take effect
...

8
...


You need to run the dbsetup file
...
If you don’t have Java, install it NOW from p6
folder
...
bat tool won’t work without it
...
bat tool fails to run and you’ll see the following message
...
Open the Windows Control Panel
...
Type ‘system’ in the search field
...
In the resulting list, select ‘View advanced system settings’
...
In the Environment variables dialog, click the lower New… button to add a
new System Variable
...
In the Variable name: JAVA_HOME
3
...
For
example: C:\Program Files (x86)\Java\jre7

Now you can run the dbsetup
...

After a few seconds the following dialog should appear
...
Select the ‘Install a new database’ and ‘Microsoft SQL Server’ options and then
click Next >
...
In the Connection Information dialog, enter the DBA user name (sa) and
password that you specified in during the setup of your SQL Express database
...
Also be sure to enter the full host name for your SQL Express instance, in this
example aasanarangan-PC\sqlexpress; where sqlexpress is the name of the
instance defined during the installation of SQL Server
...
(Ensure the machine has other antivirus/firewall software)
...


How to: Configure a Windows Firewall for Database Engine Access
1
...
msc, and then click OK
...
In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound
Rules, and then click New Rule in the action pane (upper right corner)
...
In the Rule Type dialog box, select Port, and then click next
...
In the Protocol and Ports dialog box, select TCP
...
Click Next
...
In the Action dialog box, select Allow the connection, and then click Next
...
In the Profile dialog box, I am going to Leave Domain turned on and turn private and public
off
...


7
...
Then click Finish
...
Now you can run the dbsetup
...
In the Configure Microsoft SQL Server dialog, enter a name for your database
...


9
...
MAKE A NOTE of your passwords for these two
...

Click Next >
...
In the Configuration Options dialog, enter a password for your P6 administrator
login
...
You may also want to load the sample data, particularly if you are new to P6
...


CLICK INSTALL and NEXT

WAIT FOR A WHILE TO COMPLETE

CLICK FINISH AFTER COMPLETION

Now you can connect P6 to the new SQL Database
...
Run P6 Professional and in the Login dialog, click on the ellipse button

2
...
In the Select or Create Alias dialog, select Microsoft SQL Server/SQL Express in
the Driver type field
...
In the Configure SQL Server Connection dialog, enter the host name and
database name for your SQL Server database
...
In the Enter Public Login Information dialog, enter the pubuser as username
and password you defined during the database setup process at create SQL
SERVER USERS DIALOG BOX
...


With a successful connection, you are now ready to login to your new SQL Server
Express database
...


Login to P6 with your admin password entered during the database setup
...


Go to Admin | Admin Preferences menu
...


You are now running Primavera P6 on a standalone database using SQL Server

Thank you…!!!



---