Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

localdb windows authencation

Posted on 2013-06-10
8
Medium Priority
?
382 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:Seven price
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 32

Expert Comment

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

Author Comment

by:Seven price
ID: 39236482
2012 sorry
0
 
LVL 10

Expert Comment

by:Matt Bowler
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 9

Author Comment

by:Seven price
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 10

Expert Comment

by:Matt Bowler
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:Seven price
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 10

Accepted Solution

by:
Matt Bowler earned 2000 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:Seven price
ID: 39245611
tks
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

730 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