Managing Database Users and Updating

Viewing 1 post (of 1 total)
  • Author
    Posts

  • DMIMAGE
    Member
    #163775

    Hello, I’m going to say I have never worked with SQL Server itself but find myself needing to learn quickly. We recently changed a long over due password for one of our admin accounts on our 2008 [email protected] domain controllers and noticed that account has been getting locked out. We thought we had tracked all the accounts utilizing this account and updated the password.

    Today I find the account locked out so combing through our event logs I find the account being locked out then determine at the time of lock out, we have our MSSQLSERVER starting up a DB at the exact time.

    I open up the MSSQL Management Studio, locate the DB in my list and see this account is listed and is assigned db_owner. Now what we actually want to do is replace this account with another, is it as simple as as right clicking the Users folder under Security, adding this new account and assign it the db_owner status within the Management Studio, it can’t be this simple is it.

    Thank you.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by:

 
Office 365 Coexistence for Mergers & Acquisitions: Don’t Panic! Make it SimpleLive Webinar on Tuesday, November 16, 2021 @ 1 pm ET

In this session, Microsoft MVPs Steve Goodman and Mike Weaver, and tenant migration expert Rich Dean, will cover the four most common steps toward Office 365 coexistence and explain the simplest route to project success.

  • Directory Sync/GAL Sync – How to prepare for access and awareness
  • Calendar Sharing – How to retrieve a user’s shared calendar, or a room’s free time
  • Email Routing – How to guarantee email is routed to the active mailbox before and after migration
  • Domain Sharing – How to accommodate both original and new SMTP domains at every stage

Aimed at IT Admins, Infrastructure Engineers and Project Managers, this session outlines both technical and project management considerations – giving you a great head start when faced with a tenant migration.the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

Sponsored by: