Changing Windows Remote Desktop listening port

andy18    Windows-related    

By default, Windows Remote Desktop(RDP) is listening on the port 3389. You may change the listening port by modifying the registry key as follow:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TerminalServer\WinStations\RDP-Tcp\PortNumber

Change the PortNumber to something else you wish to apply. Make sure the port you are changing is not being used by other services on the server.

To connect to the RDP from your local RDP client application, enter “ServerName:Port” or “IP:Port”

Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)

andy18    SQL-related    

I was trying to setup a SQL backup maintenance on a SQL 2005 today notice the it does not allow me to do so. At the SQL Management Studio, it shows that the “Agent XPs disabled” at the SQL Server Agent. It looks like this has been miss out to enable during the initial installation. In order to enable this, you will need to run the following T-SQL

use master
go
sp_configure ’show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
go
RECONFIGURE
GO

Alright, everything is set and the message went away. However, it still does not allow me to start the SQL Agent services. The event log captured the following during the service startup:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17750
Date: 10/12/2007
Time: 1:37:19 AM
User: NT AUTHORITY\SYSTEM
Computer: IDOCM
Description:
Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I try lookup on the SQL installation directory binn folder and to my surprise the xplog70.dll is not there. I copied the dll from another SQL installation server and voila, the SQL Agent services has been started!