How to change password and login as root

Question

How to change password and login as root

yourjobismine

Old Hand

Points: 338
More actions
November 14, 2022 at 3:17 pm

#4112749
So i am learning how to add new user's that can create and edit db's. This is a screenshot of my personal SSMS but it is failing to change password and defaults to some password shown above.
Tried:
1. Changing password, the most obvious.
2. Changing "Permission" to connect to database engine and "Login" enabled
3. Changed to SQL server authentication instead of Windows
4. For database, Server authentication set to "SQL server and windows authentication mode".
For workstation's SQL server:
How would another user login (such as root) when my workstation has only two logins "BUILTIN users" and "sa"? These came preinstalled. Can he use his windows authentication at start of SSMS to login as root or user with admin privileges?
Note that IT technical support guy doesn't know jack about SQL server or SSMS login.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ratbak Ten Centuries Points: 1358 More actions · Answer 1

Seems related to your other question: https://www.sqlservercentral.com/forums/topic/assigned-as-guest-when-installed-sql-server-on-workstation.

If his windows login has sysadmin permissions, then yes. If not, then somebody (e.g., IT) has to login as sa to create users & grant permissions.

yourjobismine Old Hand Points: 338 More actions · Answer 2

Im trying to do this on my own station first.

i am learning how to add new user'

Ken McKelvey SSCoach Points: 18842 More actions · Answer 3

If your Windows Login is a member of the local administrator group, you can start SQL Server in Single User Mode and add your Windows user to the sysadmin server role etc. This means when you start SQL Server in multi-user mode again you will have sysadmin rights. eg

https://www.sqlshack.com/recover-lost-sa-password/

yourjobismine Old Hand Points: 338 More actions · Answer 4

Will starting SSMS as administrator enable one to have permissions to add other users?

yourjobismine Old Hand Points: 338 More actions · Answer 5

Ken McKelvey wrote:

If your Windows Login is a member of the local administrator group, you can start SQL Server in Single User Mode and add your Windows user to the sysadmin server role etc. This means when you start SQL Server in multi-user mode again you will have sysadmin rights. eg
https://www.sqlshack.com/recover-lost-sa-password/

Will starting SSMS as administrator enable one to have permissions to add other users?