这个问题很多朋友都遇到过,但是情况各有不同,偶尔看了
Oracle网站,上面说了一种因为SQL端口设置产生的问题,遇到的朋友可以来这里看看。
fq-e2MCX5 __O@w. 说明,P6不能连接数据库的问题有很多种原因,还请各位对号入座! [Wf% iwB 6R1}fdHvP *.qm+#8W Receiving Errors "Error: Unable to resolve privileged username and password", "The TCP/IP Connection to the Host Has Failed" and "Connection refused: connect" When Creating a Database Configuration [ID 904332.1] G
|033(j %PW_v~sg ]6#bp, Applies to: r~N:|ip=
Primavera P6 Enterprise Project Portfolio Management - Version: 6.1 and later [Release: 6.1 and later ] sbqAjm}
Primavera P6 Enterprise Project Portfolio Management - Version: 6.1 and later [Release: 6.1 and later] JB[n]|
Primavera Web Services - Version: 6.2 and later [Release: 6.2 and later] vM5yiHI(jb
All Platforms )jc`_{PQg
O1xK\ogv
Symptoms 2nz^%pLT
Receive the errors "Error: Unable to resolve privileged username and password", jAXKp
b
e,V @t%
"The TCP/IP connection to the host has failed." and "Connection refused: connect" when creating a Database Configuration. l|{q8i#4V
xs?Ska,N
we?#
Dui
gZ!q
Cause
mQd
L"caA
The SQL Server database is not using port 1433 which is the default SQL Server port. I)]"`2w2w
D[i?T3i
Solution \k
9EimT}
Follow the instructions below to find the port the SQL Server database instance is using: C!X"0]@FA
-HQ(t
- Launch the SQL Server Configuration Manager.
- View the Protocols for database instance where the P6 database is located. For example: Primavera. e)BU6m%
- Open the TCP/IP Properties window by clicking on the TCP/IP protocol name in the list. CqFk(Td9-D
- On the IP Addresses tab scroll down to the IPAll section. Check the value of TCP Dynamic Ports. If TCP Dynamic Ports is blank, then use the value in TCP Port.
- Use the port value from the previous step for the Database Host Port when creating the Database Configuration.