Solved

localdb windows authencation

Posted on 2013-06-10
8
376 Views
Last Modified: 2013-06-13
I have a localdb database. the windows authentication was removed now I cannot connect to the localdb. Is there a way to restore the windows authentication or add a username so I can connect to it.?
0
Comment
Question by:sevensnake77
  • 4
  • 3
8 Comments
 
LVL 32

Expert Comment

by:bhess1
ID: 39235913
What version of SQL Server?
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 39236482
2012 sorry
0
 
LVL 9

Expert Comment

by:MattSQL
ID: 39236722
By windows authentication removed - do you mean that all windows accounts have been removed? (because AFAIK it's not possible to remove windows authentication entirely...)

Do you have the sa password?

If not - and you are an administrator on the server/machine try this:

http://mattsql.wordpress.com/2012/04/30/locked-out-of-sql-server/

Once you're connected to the instance with a sysadmin level account - you can add back windows accounts to your heart's content.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 9

Author Comment

by:sevensnake77
ID: 39240077
Yes but this did not work. get an error. See screen shot. And i also get another error say corrupt please reinstall inwhich I did reinstall. maybe should just remove the entire sql then reinstall. or do you think a system recovery would work?
ScreenHunter-13-Jun.-12-00.40.png
0
 
LVL 9

Expert Comment

by:MattSQL
ID: 39240078
I'm sorry - I can't really read that screenshot.

If you are able to reinstall SQL Server you can opt to add your current user account to the sysadmin role. (you can also create and remember the sa password)
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 39241168
How can I create a password when i cannot even connect?
Sa password not remembered.  Maybe uninstall the entire ms-sql then reinstall which will take forever.?
0
 
LVL 9

Accepted Solution

by:
MattSQL earned 500 total points
ID: 39242637
Well your options are, if you are an administrator on the local machine, you could follow the steps in the link above. I'm sorry but I couldn't read the screen grab you posted earlier - so if you have issues let me know...

Another option (which I've not personally tried) is:

http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20130607

A probably easier but more drastic solution is to uninstall and reinstall SQL Server. You'll be prompted for an sa password during the install.
0
 
LVL 9

Author Closing Comment

by:sevensnake77
ID: 39245611
tks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 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