How can I login to the SQL Server with Sysadmin privileges?

Question

I checked this question asked before

How to add Sysadmin login to SQL Server?

I tried all the solutions mentioned but I don't have the same options this is the output for the first solution

the output for the first solution

and this is the menu I got for the second solution I don't have "properties" in it.

the output for the second solution

So, does anyone know how to login as a Sysadmin ?!

start->programs->sql server->right click run as admin – vhadalgi Nov 07 '13 at 12:34 — vhadalgi, Nov 07 '13 at 12:34

score 1 · Accepted Answer · answered Nov 07 '13 at 12:42

1

-> Open Security -> Logins then right click to add a new Login

or

right click on an existing Login -> Properties -> Server Roles

and give him Sysadmin rights

of course you should have enough rights yourself be allowed to do this

answered Nov 07 '13 at 12:42

MrKenny78

50
2
8

score 0 · Answer 2 · answered Nov 07 '13 at 12:46

0

if you have no SQL Server Login Mode right-click on the Server -> Server Properties -> Security and change the Server authentication method to "SQL Server and Windows Authentication mode"

answered Nov 07 '13 at 12:46

MrKenny78

50
2
8

score 0 · Answer 3 · answered Nov 07 '13 at 12:49

Are you read carefully thread that you mention?

1) you must enable login of user 'sa' in window named Object explorer -> your DB name -> Security -> Logins -> sa right click and check properties (last tab)

2) you must switch authentication method in window named Object explorer -> your DB name (!not Server objects in your DB!) right click and choose properties

How can I login to the SQL Server with Sysadmin privileges?

3 Answers3