Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Use Windows sysadmin to create primavera DB

4 replies [Last post]
Michalis Kolivas
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 25 Sep 2019
Posts: 3
Groups: None

Dear All

thank you for hosting me first of all, this is my first topic (hopefully i opened it correctly)

i would like to ask you the below question:

is there a way to use a windows account (that already has sysadmin role) in my MS SQL to create a primavera P6 (16.2) database? i am trying through the DBSetup script and i get "SQLServerException: Login Failed for user '...' " of course when i use the sa or any other SQL authenticated account with sysadmin rights i am able to proceed.

So, is there any way to create an SQL DB for primavera by using a windows authenticated account?

 

thanks

Michalis

Replies

Zoltan Palffy
User offline. Last seen 3 days 13 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2433
Groups: None

Santos is correct if you want to switch over you will have to use LDAP Authentication which is a windows log in user based environment. 

Santosh Bhat
User is online Online
Joined: 15 Apr 2005
Posts: 215

Is it LDAP Authentication you require?

Link below from Oracle might help

https://support.oracle.com/knowledge/More%20Applications%20and%20Technologies/913433_1.html

Michalis Kolivas
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 25 Sep 2019
Posts: 3
Groups: None
The sa is working fine, but my manager wants to stop using the account and use windows authenticated accounts for better tracking\auditing. How can i have a clear official answer if what i am asking is doable or not?
Zoltan Palffy
User offline. Last seen 3 days 13 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2433
Groups: None

I dont think so I have only use the sa Sys admin user name

why dont you want to use this if it wroks ?