Post-installation steps – SQL rights

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Post-installation steps – SQL rights

Viewing 1 reply thread
  • Author
    Posts
    • #18216

      Hi,

       I"ve installed BTS 2006 and the required databases on both different servers. The user under which BTS was configured, must be part of the local admin group on the SQL server, and must have DBA rights on SQL server. After this installation, I would like to lower these rights. What exactly can be changed to which level?

       thanks

      Jens

    • #18237

      Jens,

      The user you used to *run* the install process needs to be admin/dba, *not* the user biztalk services will run under. If you did it that way, though, then simply remove it from the administrators group and remove the user the sysadmin and related privileges in sql.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.