Installing applications that need sysadmin privileges on a SQL instance

  • I always like to create a separate login. temporary if possible (set a note in Outlook to delete it) with a strong password.

    I'd consider that it might need to be permanent as the app might bury it somewhere, so be sure that you conform to standards you have for naming, roles, etc. If it has to remain perm, I'd likely remove some permisions or roles from the login after install.

  • Thx for the quick reply! I kinda expected this answer. But I seldom feel comfortable with these situations. You never know what the installer is doing. Or, it's probably just me being paranoid... 🙂

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply