can't login to sql management studio

I do not know the sa password.
I am logged in to the server as the local admin and smss is still not letting me in.
i thought you could always login to the smss with the local administrator account and then change the sa password.
how do i go about this...

1) i do not know sa password
2) i am logged into the server as the local adminstrator but it is not letting me login to smss with windows authentication

Please help!
jamesmetcalf74Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
You dont have SA password and you can not login by local admin credential. Now you have two option

first start sql server in single user mode and reset the SA password or Add your login in SQL server. This method require sql service restart.

steps:
1. Open SQL server configuration manager.
2. select sql server service on left hand.
3. Right click on SQL Server (instance name) -- for default instance it will be (MSSQLSERVER)
4. go to property > advance and check the startup parameter add ;-m at the very end of the startup parameter

close and restart the service

but before restart stop the SQL Server Agent service.

Now this sql instance will start in single user mode and you can connect it with local admin.


Second: Reset password by using PSEXEC utility add your login or reset SA password. (does not require SQL restart)
Deepak ChauhanSQL Server DBACommented:
Second method.

Run this command on windoes command prompt but PSExec utility should be there.

PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SSMS.exe"

Now you will be able to connect SSMS throung NT Authority\SYSTEM.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jamesmetcalf74Author Commented:
what does PSExec utility should be there mean?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

jamesmetcalf74Author Commented:
its saying psexec is not recognized as an internal or external command
jamesmetcalf74Author Commented:
quick question... the first procedure used..... can I run this from a domain account that is in the local administrators group
Deepak ChauhanSQL Server DBACommented:
Psexec utility is part of SYSInternal bundel, you can download it from here.

https://technet.microsoft.com/en-in/sysinternals/bb897553.aspx


@its saying psexec is not recognized as an internal or external command

because PSexec not installed there.

quick question... the first procedure used..... can I run this from a domain account that is in the local administrators group
 Yes you can run it
Deepak ChauhanSQL Server DBACommented:
Is that worked.... or still you are in trouble.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.