<div>
Raja,<br />
<br />
I have followed the instructions in the URL you provided.<br />
<br />
Now when I launch SQL Server Management Studio what options do I use to login with the new account I just created named <b>security</b>?<br />
<br />
What do I change the &quot;Server Type&quot; &quot;Server name&quot; &amp;&nbsp;&quot;Authentication&quot; fields too?<br />
<br />
Or do I need to launch or do something else?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/07_w27/1347142/Management-studio-logon-screen.PNG" target="_blank" title="Management studio logon screen (28 KB)"><img alt="Management studio logon screen" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/07_w27/800_1347142/Management-studio-logon-screen.PNG" /></a>
</div>


Raja,

I have followed the instructions in the URL you provided.

Now when I launch SQL Server Management Studio what options do I use to login with the new account I just created named security?

What do I change the "Server Type" "Server name" & "Authentication" fields too?

Or do I need to launch or do something else?

Management studio logon screenhttps://filedb.experts-exchange.com/incoming/2018/07_w27/1347142/Management-studio-logon-screen.PNG

Management-studio-logon-screen.PNG

<div>
As mentioned in the other thread, it would be SQL Authentication instead of Windows Authentication and you might need to provide the user name and password which you have created as per the URL.
</div>


As mentioned in the other thread, it would be SQL Authentication instead of Windows Authentication and you might need to provide the user name and password which you have created as per the URL.

<div>
Raja,<br />
<br />
I've responded to your message.<br />
<br />
Please let me know if any further info is needed.
</div>


Raja,

I've responded to your message.

Please let me know if any further info is needed.

<div>
<div class="content wysiwyg-content">
Please provide me with detailed step-by-step instructions on how to create a SQL 2016 login account for an Active Directory account.<br />
<br />
In my other question <a href="https://www.experts-exchange.com/questions/29107294/Setup-is-unable-to-connect-to-SQL-Server-with-the-connection-information-provided-error-while-setting-up-SCCM.html?anchorAnswerId=42612755#a42612755" rel="ugc">here</a> I have been instructed to create a SQL login account for the 'BAYITNC\Administrator' account (which is the domain admin account).<br />
<br />
I am very new to SQL.<br />
<br />
Please provide me with the exact steps on how to do this.<br />
<br />
If any further information is needed please let me know.
</div>
</div>


Please provide me with detailed step-by-step instructions on how to create a SQL 2016 login account for an Active Directory account.

In my other question here (https://www.experts-exchange.com/questions/29107294/Setup-is-unable-to-connect-to-SQL-Server-with-the-connection-information-provided-error-while-setting-up-SCCM.html?anchorAnswerId=42612755#a42612755) I have been instructed to create a SQL login account for the 'BAYITNC\Administrator' account (which is the domain admin account).

I am very new to SQL.

Please provide me with the exact steps on how to do this.

If any further information is needed please let me know.

Create SQL 2016 logon account for AD account

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

Windows Server 2016 is the successor to Windows Server 2012 R2. Built upon the same core code as Windows 10, Windows Server 2016 brings enhancements in security, servicing, and connectivity. A particular focus on this release was hybrid-cloud scenarios, and has close ties to Azure and other Microsoft cloud initiatives. This does not detract from the many improvements that are available for on-premises-only deployments

Windows Server 2016 comes in Datacenter, Standard, and Essentials editions, and for servicing, has adopted windows 10's cumulative model. The new nano-server install is designed to be remotely managed and is designed to be kept current through continuous feature updates. The full GUI install operates similarly to windows 10's "Long Term Servicing Branch" (LTSB) model with cumulative security updates.

Windows Server 2016 has also shifted from a per-processor-and-CAL licensing model to a per-core-and CAL licensing model. This brings Windows Server's licensing more in line with Microsoft's other products and makes hybrid-cloud license planning easier as well.

Windows Server 2016

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.