• State Not Answered
  • Locked Locked
  • Replies 7 replies
  • Subscribers 20 subscribers
  • Views 5803 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

C.A

shaimaa
over 6 years ago

I installed SQL server 2012 sp2 , and after we installed change auditor coordinator with domain Admin account, we don't find any database created in SQL server.

Can I know why this happen?

Thanks

Parents
  • 0 over 6 years ago
    Couple of thoughts here:

    When you installed SQL, what groups did you grant administrative rights to SQL? By default, Domain Admins and/or local admins of the SQL host DO NOT have rights to the SQL server.

    When you ran your CA install, did your "domain admin" account get correctly added to the DEFAULT - Change Auditor Administrators group?

    Regardless, you probably want to make sure that "DEFAULT - Change Auditor Administrators" has at least DBOWNER rights over the CA DB.
Reply
  • 0 over 6 years ago
    Couple of thoughts here:

    When you installed SQL, what groups did you grant administrative rights to SQL? By default, Domain Admins and/or local admins of the SQL host DO NOT have rights to the SQL server.

    When you ran your CA install, did your "domain admin" account get correctly added to the DEFAULT - Change Auditor Administrators group?

    Regardless, you probably want to make sure that "DEFAULT - Change Auditor Administrators" has at least DBOWNER rights over the CA DB.
Children
No Data