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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
what does PSExec utility should be there mean?
ASKER
its saying psexec is not recognized as an internal or external command
ASKER
quick question... the first procedure used..... can I run this from a domain account that is in the local administrators group
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
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
Is that worked.... or still you are in trouble.
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)