Skip to content

Use Windows sysadmin to create primavera DB

Michalis KolivasMember for 7 years
Created
4
3
0

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

4 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    I dont think so I have only

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

    why dont you want to use this if it wroks ?

  2. 0
    Michalis Kolivas ·

    The sa is working fine, but

    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?
  3. 0
    Santosh Bhat ·

    Is it LDAP Authentication you

    Is it LDAP Authentication you require?

    Link below from Oracle might help

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

  4. 0
    Zoltan Palffy ·

    Santos is correct if you want

    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. 

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?