?
Solved

Lost WIndows Authenication Means

Posted on 2009-04-22
1
Medium Priority
?
220 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:chrisryhal
1 Comment
 
LVL 8

Accepted Solution

by:
tpi007 earned 2000 total points
ID: 24205421
Login to server using sa
Check your domain account is in security section
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question