Solved

SQL server password

Posted on 2015-01-09
9
117 Views
Last Modified: 2015-01-26
So SQL is loaded on a server. Apparently no one knows what the password is to get into the server, imagine that. Does anyone know of anyway to get in?
SQL server authentication...
tried Windows auth and nothing...

Thanks
0
Comment
Question by:dlewis61
  • 2
  • 2
  • 2
  • +3
9 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 40540480
So you can't get into the server or the SQL install?
0
 
LVL 39

Expert Comment

by:Kyle Abrahams
ID: 40540483
From: http://msdn.microsoft.com/en-us/library/dd207004(v=sql.100).aspx

You can pass a -m or -f and then any local administrator on the box should be able to connect to it with windows authentication.  From there you can reset the SA password.

Step by step:
http://community.spiceworks.com/how_to/show/22044-recover-sa-password-on-microsoft-sql-server
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 40540496
Once you're on the box and loaded SQL Management Studio you should be able to issue this:

exec sp_password null, null, 'sa'

Pretty sure that's the syntax.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40540524
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40540613
All the solutions (links) provided only works if there's someone with sysadmin role otherwise SQL Server would have an huge security issue.
So dlewis61 if you or someone has sysadmin role to the SQL Server, he or she need to connect to the instance and give access to the others or at least activate sa login and reset his password.
Alternative is that the SQL Server service account is a domain account so you can connect to SQL Server with that account and provide the necessary access to you or to your colleagues.
0
 
LVL 39

Accepted Solution

by:
Kyle Abrahams earned 500 total points
ID: 40540749
Vitor - you are incorrect.

An administrator on the box CAN gain administrative control and reset the password of the sa account without ever knowing a password or being apart of the DB security roles.  Please see my link.  I too view this as a security hole but the powers at be (eg: Microsoft) allow this in case of a rogue user or a legit mistake.
0
 

Author Comment

by:dlewis61
ID: 40540751
It was the case that I could get in with windows authentication, but now I can't. I do not have sysadmin role. So I have to wait for those with god rights to get me going again.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 40540945
what is your sql server version?
if sql 2005 + use the above links
if sql2000- if you are local admin on the box (same with sql 2005)
you maybe can access sql server ..
if not foe sql2000- you may need to reinstall master db (sql server) ...
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40543874
@Kyle: Yes, you're right. I did the test following the link you posted and worked. You can't perform any query but you can create a new login and give him sysadmin role. What a security hole!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now