Cannot add SMSadmin to SQL Server + Add Sysadmin role

[Drekko]

Hey guys

I created another post on why my SMSadmin and SMSread accounts were missing

I solved that now searching more on this forum, so thanks for that

 

Now another issue

 

I cannot add the SMSadmin account to the SQL Server (under Management Studio)

 

And when I try to add server role "sysadmin" to the domain administrator account called "Pat" I cannot do that either

I do not have permissions for both tasks

 

Can someone please point me in the right direction to solve this. This may be a basic question but I am new to SCCM and trying to learn it via home lab

I am using Server 2012 R2, SCCM 2012 R2 SP1 - 1511

See attached files for error messages

[YPCC]

Looks like PAT doesn't have enough access to allow you to make changes to accounts (especially make them sysadmin)

 

A lot of people get caught out here, often people forget the password to their management studio and resort to rebuilding. Before doing a rebuild, try this:

 

1 - Downloaded http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx and extract psexec.exe

2 - Copy psexec.exe to c:\

3 - Open a administrative CMD window and run: c:\psexec -i -s "C:\Program Files (x86)\Microsoft SQL Server\.................Ssms.exe"

 

Obviously replace the location in the above command, you need to locate where the exe file for Management Studio is located. It should be called ssms.exe and somewhere in Program Files (x64/x86).

 

This will launch Management Studio using "NT AUTHORITY\SYSTEM" and you can then add a account (or modify PAT) to make it sysadmin.

[Drekko]

Looks like PAT doesn't have enough access to allow you to make changes to accounts (especially make them sysadmin)

 

A lot of people get caught out here, often people forget the password to their management studio and resort to rebuilding. Before doing a rebuild, try this:

 

1 - Downloaded http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx and extract psexec.exe

2 - Copy psexec.exe to c:\

3 - Open a administrative CMD window and run: c:\psexec -i -s "C:\Program Files (x86)\Microsoft SQL Server\.................Ssms.exe"

 

Obviously replace the location in the above command, you need to locate where the exe file for Management Studio is located. It should be called ssms.exe and somewhere in Program Files (x64/x86).

 

This will launch Management Studio using "NT AUTHORITY\SYSTEM" and you can then add a account (or modify PAT) to make it sysadmin.

 

Awesome that tool worked !