- Go to "SQL Server Configuration Manager"\ SQL Server Services.
- Then right click the service of the SQL Server instance that is not accessible, and choose properties.
- open the "Startup Parameters" tab.
- There, insert "-m" in the "Specify a startup parameter", then click the Add button
- Click OK
- Restart the service.... after restarting, the SQL Server instance will enter in a single mode.
- Now login to that SQL Server instance using a system admin.
- change the password of the sa user or add any user you want with whatever permissions you want.
- After you are done, go back to SQL Server service properties window, and again to the Startup Parameters tab, then remove the "-m".
- Click OK, restart the service, and that's it.
Saturday, February 7, 2015
Login failed with sa user or system administrator
To fix this:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment