[All Windows 7 Systems Query not working]

Hey guys

 

I have created 3 queries:

 

Discover All Systems with Windows 10 installed

Discover All Systems with Windows 8 installed

Discover All systems with Windows 7 installed

 

The first query I made from scratch was the Windows 10 query and I imported that query for Windows 8 and 7 and just changed the Criterion Properites Value to %Windows 7%

 

The Windows 10 and 8 queries are working fine, so I dont understand why the windows 7 query will not pick up any Windows 7 machines

 

This is a home lab for learning and I definitely have a Windows 7 machine running my config manager even pushed out the client to that machine without issues

 

Is there anything wrong with my query even though it works for Windows 10 and 8 machines?

 

Check attachment for my query

[Cannot add SMSadmin to SQL Server + Add Sysadmin role]

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 !

[Missing SMSadmin account.. Fresh install]

I assume they've created that account to perform the installation with. The installation only creates the local group of SMS Admins.

Well my installs didnt even do that

I created SMSadmin, SMSread and the SMSadmin group myself in AD

 

Do I need those in SQL or can I start using config manager with my domain account?

[Cannot add SMSadmin to SQL Server + Add Sysadmin role]

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

[Missing SMSadmin account.. Fresh install]

Hi guys

I have installed SCCM 2012 R2 with 1511 upgrade in a home lab enviroment to learn this and to eventually become a pro with it.. lol

 

I have completed installing everything and upgrading it to 1511 with MDT update 2 and Windows 10 ADK.

Looking at some cbt nuggets videos after this, I noticed I do not have an SMSadmin account at all in AD

I am able to open the config manager console thought through a domain administrator account i created myself to use

Added this account to be a member of domain admins, enterprise admins, schema admins, and local administrator groups

 

Did I miss something?

 

Remember this is a fresh install and all I have done is installed the pre-reqs and upgraded config manager to 1511

 

This is what my logins look like in SQL Server Managment studio (attached), and the Pat\pat account is the domain admin account i mentioned above

Should I just add the "pat" account to sysadmin?