I had to install a copy of SQL Server 2005 on a Windows Server 2003 R2 SP2 x64. During installation I got a strange error saying that SQLncli_x64.msi file is missing. I was pretty sure that I have the same ISO file as I did while installing SQL so many times before and without any … Continue reading Install SQL Server on a 64 bit Windows Server–missing SQLncli_x64.msi
Prerequisites configured before starting the installation: Windows Server 2008 R2 updated Active Directory Domain Services Installing Central Administration Site (CAS): Installing Primary Site:
If you need to create a ConfigMgr software package with Adobe Flash Player and want to use it’s .msi file, you can find this file at the following address: http://www.adobe.com/products/flashplayer/fp_distribution3.html Please note that in order to distribute Adobe Flash Player you need to have a valid Adobe Flash Player Distribution License Agreement in place. For … Continue reading Distribute Adobe Flash Player
SELECT TOP (100) PERCENT Manufacturer0 AS Manufacturer, Model0 AS Model, COUNT(Model0) AS Total FROM dbo.v_GS_COMPUTER_SYSTEM GROUP BY Model0, Manufacturer0 ORDER BY Total DESC, Manufacturer, Model
select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Client = 0 and SMS_G_System_OPERATING_SYSTEM.Caption not like "%Server%" or SMS_R_System.Client is null and SMS_G_System_OPERATING_SYSTEM.Caption not like "%Server%"
As Microsoft recently released Service Pack 2 for Office 2007 suite, it is a good idea to add the update files to the package so it can be installed during the installation. So, first of all we have to download the SP2 executable file from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en (see Visio and Project information at the end … Continue reading Deploy Office 2007 SP2 with ConfigMgr 2007
select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%HP ProBook 4710s%"
Yesterday I was trying to install a network printer on Windows Server 2008 system. After typing printer’s IP address, I received an “Access denied” error. The problem was that I tried to install the printer while I was logged on with a user that had domain admin privileges, but not the default domain Administrator account. … Continue reading Add TCP/IP printer – Access Denied
In case you need to find the computer model and manufacturer of a remote computer, just use the following command in a command prompt window: %windir%\System32\wbem\WMIC.exe /node:"ComputerNameORIpAddress" ComputerSystem Get Model, Manufacturer If you need to specify user credentials, use the following command: %windir%\System32\wbem\WMIC.exe /node:"ComputerNameORIpAddress" /user:"domain\username" /password:"password" ComputerSystem Get Model, Manufacturer
Recently I reinstalled ConfigMgr server in my company and was looking for an easy method to upgrade all Configuration Manager clients to 4.00.6487.2000 version. Put some notes on the table and finally made the following plan: Create a report that counts all client versions. (This is optional, just for informational purposes). Report query is:SELECT TOP … Continue reading Upgrade Configuration Manager client