![]() This will put the SQL into Single User Mode, and SQL Server will only accept one connection.Ĭonnect with SQL Server Management Studio (start Management Studio with “Run as administrator”) and add login with sysadmin privilege, Or from CMD with ‘Run as administrator’ input: On the Startup Parameters tab, add -m parameter (do not add a space between the -m and the rest of the command line). In the right pane, right-click SQL Server (), and then click Properties. ![]() In SQL Server Configuration Manager, click SQL Server Services. Start the SQL service with the -m parameter. ![]() Stop all SQL Server related services (some SQL services such as SQL Agent will use up your only connection in single-user mode).Ģ. If you removed Builtin\administrator from SQL Server which is the best security practice, and you forgot SA password, or SA account is disabled and there is no other Windows or SQL Server account on SQL Server with sysadmin privilege, starting SQL Server in single-user mode enables any member of the computer’s local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.ġ.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |