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
snyderkvAsked:
Who is Participating?
 
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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Paul MacDonaldDirector, Information SystemsCommented:
...time to track down that user!
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.