snyderkv
asked on
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
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
LelikInside
You can write a bruteforce for sa login
ASKER
Do we have to I mean we are all local admins with domain admin rights. You'd think their was an easier way.
...time to track down that user!
ASKER
so there is no other way?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
have you tried to login with windows authentication mode?
have you tried to login with windows authentication mode?
Evidently it's set up for SQL users only, or I'm pretty sure local admins could log in.
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)
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)
>>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.
Is that possible? You can certainly set it for Windows Authentication only -- which actually is the default on SQL 2000 and 2005.
ASKER
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
I'll try the back door, thanks Daniel and everyone.else
ASKER
I really wish they would give us 30 seconds to edit posts so I can go back and correct spelling grammers errors. How frusterating.
"Is that possible?"
Hahahahaha! Can you tell I'm not a DBA?
Hahahahaha! Can you tell I'm not a DBA?
ASKER
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?
>>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!
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!