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

Lost WIndows Authenication Means

I recently had to demote my domain controller and recreate the domain which so happened to have a SQL Server 2005 instance installed on it for some small DB SPROCS as part of an application.  Now I can only log into SQL Server with the SA account and not Windows Authenication like I had it.  Whats a quick way of fixing this?
1 Solution
Login to server using sa
Check your domain account is in security section
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: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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