![]() ![]() Right click on the server node (the very first / topmost node) and choose properties.Login with the usual windows account as before.This time when SSMS starts it will start in Single user mode which gives you full access.Stage 2: Part 1: - Enabling SQL Server and Windows Authentication mode If you get any problems with the service not starting, verify step 5.be careful to not add any white spaces as the parser is very picky."-m " at the beginning or " -m" at the end (note the semi-colons but without quotes).Find "Startup Parameters" and add the following.Right click on SQL Server (MSSQLSERVER) and click properties.Open Sql server configuration manager (SSCM).Stage 1: - Get SSMS working in single user mode My solution is documented below, only apply the parts you need: ![]() So all the normal suggestions kept giving me permission denied errors (because I didn't have permissions to alter what other posts were telling me I should alter). Essentially my problem was that the SA account was disabled, also the system was set to only allow login by windows authentication, and finally the administrator account in windows also was not a member of the sysadmin role. Tried googling it and all the standard solutions didn't work so I had to get creative. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |