[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

Can't login to SQL Server?

EE,

Nobody has a domain login that can be used to login to SQL and nobody knows the SA account password for local login. We just installed SQL 2008 with management studio but the user who set it up is gone.

Please assist :)

Thanks again
0
snyderkv
Asked:
snyderkv
  • 5
  • 3
  • 3
  • +3
1 Solution
 
LelikInsideCommented:
You can write a bruteforce for sa login
0
 
snyderkvAuthor Commented:
Do we have to I mean we are all local admins with domain admin rights. You'd think their was an easier way.
0
 
Paul MacDonaldDirector, Information SystemsCommented:
...time to track down that user!
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
snyderkvAuthor Commented:
so there is no other way?
0
 
Bhavesh ShahLead AnalysistCommented:
Hi,

have you tried to login with windows authentication mode?
0
 
Paul MacDonaldDirector, Information SystemsCommented:
Evidently it's set up for SQL users only, or I'm pretty sure local admins could log in.
0
 
radcaesarCommented:
Go to that server box

Login to the windows server as "administrator"

Open Management Studio and Login using Windows authentication

SET the SA Password (Security -> Login -> Right click 'SA' ->Properties)
0
 
Daniel WilsonCommented:
>>Evidently it's set up for SQL users only

Is that possible?  You can certainly set it for Windows Authentication only -- which actually is the default on SQL 2000 and 2005.
0
 
snyderkvAuthor Commented:
Yes Daniel it's Windows Authentication but to Id like to say to all those responses that we can't login using either local SA because we don't know the password or using windows authentication even as domain admins because the one userw ho set it up is gone.

I'll try the back door, thanks Daniel and everyone.else
0
 
snyderkvAuthor Commented:
I really wish they would give us 30 seconds to edit posts so I can go back and correct spelling grammers errors. How frusterating.
0
 
Paul MacDonaldDirector, Information SystemsCommented:
"Is that possible?"


Hahahahaha!  Can you tell I'm not a DBA?
0
 
snyderkvAuthor Commented:
Daniel,  Just to note, I remember modifying a table before and changing a 0 to a 1 or something in order to elevate logins. You don't also happen to have that trick do you?
0
 
Daniel WilsonCommented:
>>Can you tell I'm not a DBA?

Lol.  I've gotten rusty enough on some points, that I wouldn't have been too surprised to find out that under SQL 2008 I was the one wrong.  

>>changing a 0 to a 1 or something in order to elevate logins. You don't also happen to have that trick do you?

No ... I'm afraid I don't know that one.  Sorry!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now