Category Archives: Computers

Redirected to KB2497281 when attemping to access Windows Update

I kept getting redirected to http://support.microsoft.com/kb/2497281 when attempting to get to www.windowsupdates.com on a PC which has just has SP3 installed. I needed to update the Windows Update Agent to get access http://support.microsoft.com/kb/949104 https://support.microsoft.com/en-us/kb/943144 x86-based versions of Windows: Download WindowsUpdateAgent30-x86.exe (http://go.microsoft.com/fwlink/?LinkID=100334). x64-based versions of Windows: Download WindowsUpdateAgent30-x64.exe (http://go.microsoft.com/fwlink/?LinkID=100335). Itanium-based versions of Windows: Download WindowsUpdateAgent30-ia64.exe (http://go.microsoft.com/fwlink/?LinkID=100336).… Read More »

M$ SQL DatePart

Syntax DatePart(interval, date [, firstdayofweek] [, firstweekofyear] ) The DatePart function syntax has these arguments: Argument Description interval Required. String expression that is the interval of time you want to return. date Required. Variant (Date) value that you want to evaluate. firstdayofweek Optional. A constant that specifies the first day of the week. If not… Read More »

Install and Enable Remote Desktop in Windows XP Home Edition

As yet, untested! Windows XP Home Edition (HE) does not come with or support Remote Desktop, or Terminal Services feature. There is Remote Desktop Connection (RDC) client which allows user to connect to remote host, but now accepting any remote desktop connection to the Windows XP Home PC. However, there is way to install and… Read More »

Pinging oy with 32 bytes of data” (PC’s built-in speaker beep once)

Problem U:\>ping 10.0.0.1 Pinging oy with 32 bytes of data: Reply from 10.0.0.1: bytes=32 time=66ms TTL=46 Reply from 10.0.0.1: bytes=32 time=66ms TTL=46 Reply from 10.0.0.1: bytes=32 time=66ms TTL=46 Reply from 10.0.0.1: bytes=32 time=66ms TTL=46 Ping statistics for 10.0.0.1: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in… Read More »

How to install SQL Server 2005 on Windows Server 2008

Today at work, I had the chance to configure a brand new HP ProLiant ML350 G5 server. The machine came with Microsoft’s latest flavor of server operating systems, Windows Server 2008. Windows Server 2008 installation was really fast and easy, reminding of Windows Vista setup. When time came to install SQL Server 2005 the first… Read More »

Making HTTP requests via telnet

$ telnet www.spectrumcs.net 80 Trying 208.97.136.171… Connected to www.spectrumcs.net. Escape character is ‘^]’. GET / HTTP/1.1 Host: www.spectrumcs.net HTTP/1.1 200 OK Date: Thu, 12 Jul 2007 16:10:02 GMT Server: Apache/1.3.37 (Unix) mod_throttle/3.1.2 DAV/1.0.3 mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a PHP/4.4.7 mod_ssl/2.8.22 OpenSSL/0.9.7e MS-Author-Via: DAV Last-Modified: Wed, 11 Jul 2007 14:10:28 GMT ETag: “19cf7aa-68d-4694e4d4” Accept-Ranges: bytes Content-Length: 1677 Content-Type: text/html… Read More »

Using OpenSSL to create a certificate for Exchange 2010

14-July-2011 – This post needs polishing! 14-Dec-2011 – Improved by repeating exercise at PCA. 01-Aug-2012 – I have created a script to create directory structure and openssl.cfg available at http://files.spectrumcs.net/public/Exchange-OpenSSL/ 28-Aug-2012 – Look at http://www.sslshopper.com/csr-decoder.html and consider creating a web portal which will create the CA and Certs in one go. Before diving in, remember to do the… Read More »

Delivery has failed to these recipients or groups: distribution-group@domain.com Your message can’t be delivered because delivery to this address is restricted.

If you receive a bounce message with the following message when sending an email to a distribution list. Delivery has failed to these recipients or groups: distribution-group@domain.com Your message can’t be delivered because delivery to this address is restricted. Within Exchange Management Console navigate to Microsoft Exchange -> Microsoft Exchange on-Premises -> Recipient Configuration ->… Read More »

Grant Full Access to All Mailboxes in Exchange 2010

Here’s a little time-saving tip for working with mailboxes in Exchange 2010.  Normally if you need full access to another user’s mailbox in Exchange 2007/2010 you would highlight their mailbox in the Exchange Management Console and the choose “Manage Full Access…” from the action pane.  You would have to do this individually for each mailbox… Read More »

ADSL connection analysis. SNR, Loop Attenuation etc

SNR is Signal to Noise Ratio (aka Noise Margin or Signal to Noise Margin) Relative strength of the DSL signal to Noise ratio. 6dB is the lowest dB manufactures specify for modem to be able to synch. In some instances interleaving can help raise the noise margin to an acceptable level. The higher the number… Read More »

Exchange 2010 Installation in 3 STEPS!

Open a command prompt and run “ServerManagerCmd -i RSAT-ADDS” on any DC (any Exchange server if not a DC) and restart them. Goto Services.msc and make sure “Net.Tcp Port Sharing Service” service is set to automatically run. Open a command prompt, change directory to the scripts directory within your Exchange 2010 media and then run… Read More »

Windows 7 – Classic Logon Screen

Summary of webpage…Computer Configuration -> Windows Settings -> Security Settings -> Local Policies -> Security Options… ‘Interactive Login: Do not display last user name’ = Enable’Interactive Login: Do not require Ctrl+Atl+Del’ = Disable Computer Configuration -> Administrative Templates -> System -> Logon… ‘Hide entery points for Fast User Switching’ – Enable (I didn’t have this… Read More »

Disable User Account Control(UAC) For Administrators Only

To configure this setting on Windows 7 / Vista Business and Ultimate, you can use the Local Security Policy configuration. Just type in secpol.msc into the Start menu search box and hit enter. Now browse down to Local Policies \ Security Options Find the following in the list: “User Account Control: Behavior of the elevation… Read More »