I am administrator in my machine windows 8, But I cannot login to SQL using my administrator user.
Problem I installed SQL using other user and I didn't remember its password to solve this problem I followed the following steps:
- Open the command prompt (Right-Click on and select "Run As Administrator")
- From the command prompt type net stop MSSQLSERVER
- Next type net start MSSQLSERVER /m
- Open SQL Server Management Studio. Do not login, cancel the login dialog.
- From the file Menu select New->Database engine query, and login (Make sure you use the host name and not localhost).
- Execute the query ALTER LOGIN sa WITH PASSWORD = ''; to reset the password (if the sa is not enabled then type ALTER LOGIN sa ENABLE to do so)
- Login with the sa user and add the Administrator user.
No comments:
Post a Comment