• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 17
  • Last Modified:

trouble connnecting active directy account to SQL

We have been instructed by the IT director to created an active directory service account and give it "access to a SQL 2016" database. In our test environment, we have several active directory user accounts that have been granted Sys Admin on our test databases and we can connect fine. Today we created the same kind of AD account and logged into our SQL server and opened Management Studio, from there we tried to connect to our production database with WIndows Authentication and our active directory service account but got the error "18456". We created a local SQL server account with the exact same username and password and are able to connect SQL Server Authentication, however that is not what our director asked for. Does anyone know the error we are getting and what might be different about our production SQL server?
0
Thor2923
Asked:
Thor2923
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
When using Windows Authentication you need to run the Management Studio with the AD account that you've created.
For that you need to login in the machine with that AD account credentials or when you're logged in with a different user, right-click on the SSMS icon, at the same time you press the Shift key, then you can choose the option "Run as different user", where you'll need to provide the AD account credentials. With that you'll be connect to SQL Server with the provided AD account.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Solution provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now