Though this process looks easy but havent had a chance to use this.Recently ,i have upgraded my SQL server 2005 to SQL server 2008.There are different ways that you can do this like taking backup of SQL server 2005 ,uninstall 2005 later install 2008 and restore backed up database.I just simply ran the upgrade advisor to see if it has any DTS jobs and other stuff.So started installing SQL 2008(passed pre requisists) and it prompt me to select the instance name.So tried using the default instance name but failed bcz it used by SQL 2005 .I selected named instance(computername\SQLserver2008).For installing the…
Author: Eswar Koneti
Issue: Client PC's would not communicate to WSUS 3.0 SP1 Solution: 1. Delete the PC from the WSUS console (Client PC's - The PC will likely have a red X) 2. At the client PC - Select Start - Run - type CMD 3. At the command prompt type net stop wuauserv 4. Navigate to the Windows Directory 5. Delete the 'Software Distribution' Folder 6. Run Microsoft Update from the Start menu (This will ensure the update software is up to date) 7. Restart the PC 8. Select Start - Run - type in the run box http://WSUSServerName/iuident.cab (wsus…
If clients are having trouble downloading and installing updates from your SUS or WSUS server, should check a familiar place—the registry. Go to the problematic client PC and follow these steps: 1. Select Run on the Start menu. 2. In the Run dialog box, type regedit, then click OK. 3. In the registry, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\WUServer subkey. Make sure the WUServer subkey points to your SUS or WSUS server and not Microsoft Windows Update. 4. Navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update subkey. Find the AUState entry and note its value. The AUState value can help you determine the problem. Here are the…
You might get a request to find out all the computers in organisation connected to which printers.There might be differetn printers in organisation and connection to the computers will vary.I just thought to post this qeury on the which will be useful for some one. SELECT A.Name0, A.UserName0, B.Name0, B.DriverName0, B.Location0, B.PortName0, B.ShareName0 FROM v_GS_COMPUTER_SYSTEM A, v_GS_PRINTER_DEVICE B WHERE A.ResourceID = B.ResourceID AND B.Name0 != 'Microsoft Office Document Image Writer' AND B.Name0 != 'Adobe PDF' AND B.Name0 != 'Microsoft XPS Document Writer' AND B.Name0 != 'PDF-XChange 3.0' AND B.DriverName0 != 'Microsoft Shared Fax Driver' AND B.DriverName0 != 'pdfFactory 2' AND…
There are many tools like SMS /SCCM or scripting to get list of applications installed on computers(you dont use SMS/SCCM only for this kind of information 🙂 ) but what if the clients are not reported back to site server for some other reason and there could lot of applications installed on computers then you will start troubleshooting the clients why it doesnt report. Use the below simple VB script to get list of applications installed on target computers with its installed date and product ID as well. Collect list of computers that you are looking for and pipe all the computer names into…
Is the client getting the advertisement policy? 1. Check the ccmexec.log for the advertisementID. 2. If the advertisementID is not in the ccmexec.log, check the ccmexec.log for errors communicating with the Management Point. 3. If the ccmexec.log shows errors communicating with the MP, follow basic connectivity tests such as pinging the MP by IP address, pinging the MP by hostname and telnetting to port 80 on the MP. 4. If the ccmexec.log indicates the client can communicate with the MP, check the Management Point to see if the policy exists using SMS Client Centre tool. 5. If the policy is…
Both MySQL and SQL Server do a good job of supporting all major protocols for accessing their respective databases. A standard protocol is the “programming language” used for a program to communicate to a SQL database. The most common protocol is called tSQL, or Transact SQL. Transact SQL is a series of statements that a program can use to access data and create new tables in a SQL database. The statements can INSERT new records, DELETE old records and UPDATE existing records, along with a myriad of other functions. The international standard for this programming language is referred to as…
It is difficult to troubleshoot the machines where the Task sequence(Os deployment) failed remotely.If there are one or two computers which are in front of you,you can check press F8 and see what happens by looking at smsts.log but take a case if you deploy to multiple systems and a person who is not know how to get smsts.log .Steve posted a Great blog on how to capture smsts.log on to share for further troubleshooting. Below is the Task sequence which displays for deploying Operating System with different tasks .Here i have two main groups i.e Error catching Top with…