Skip to content

Cannot add SMSadmin to SQL Server + Add Sysadmin role

Featured Replies

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

post-32642-0-24523800-1451303612.png

post-32642-0-98572100-1451303614.png

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.

  • Author

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 !

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.