Accenture MDR Quick Start Guide for Create a read-only database user with Windows AD Account for Microsoft SQL Server
- KS
This quick start guide will help Accenture MDR customers create a read-only database user with Windows AD Account for Microsoft SQL Server.
Create Windows AD Account for Microsoft SQL Server.
Create Windows AD Account for Microsoft SQL Server.
From Windows Domain Controller, create a standard user and note down the username and password.
Note: While Creating a Domain User ensure that you deselect the User must change password at next logon option and select the Password never expires option.
Open SQL Server Management Studio.
Log in to the SQL Database with Admin privileges.
Expand the Databases folder under Object Explorer.
Expand the database in which you want to create the new database user.
Right-click the Security folder, and then click New > Logins….
In the Login- New dialog box, perform the following steps
Under the General page, choose the Windows Authentication.
In the User name box, select Windows user from the User type list.
Note: You can also click Search (…) to open the Select User or Group dialog box.
9. In the Default database box, select the database to be read by this user.
10. In the User Mapping page, under Users mapped to this login, make sure that you have selected the database to read.
11. Enable the db_datareader checkbox in the Database role membership for Database.
12. Click Ok.
Legal Notice
Copyright © 2021 Accenture. All rights reserved.
Accenture, the Accenture Logo, and DeepSight Intelligence are trademarks or registered trademarks of Accenture in the U.S. and other countries. Other names may be trademarks of their respective owners.
The product described in this document is distributed under licenses restricting its use, copying, distribution, and decompilation/reverse engineering. No part of this document may be reproduced in any form by any means without prior written authorization of Accenture and its licensors, if any.
THE DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. ACCENTURE SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS DOCUMENTATION. THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS SUBJECT TO CHANGE WITHOUT NOTICE.
The Licensed Software and Documentation are deemed to be commercial computer software as defined in FAR 12.212 and subject to restricted rights as defined in FAR Section 52.227-19 "Commercial Computer Software - Restricted Rights" and DFARS 227.7202, et seq. "Commercial Computer Software and Commercial Computer Software Documentation," as applicable, and any successor regulations, whether delivered by Accenture as on premises or hosted services. Any use, modification, reproduction release, performance, display or disclosure of the Licensed Software and Documentation by the U.S. Government shall be solely in accordance with the terms of this Agreement.