Change the port on which Microsoft Sql Server Express Edition

When I was trying database connectivity with java..
In the connection string I used the default port number 1433 since i had not changed anty default settings while installing the server.But that gave me theexception:

Exception:"DataSource Not found"

So i tried to find out on which port server was running but since i donno why on earth ,netstat was not showing sqlserver.exe as an active process even when it was visible in task manager.

Therefore the need to change the port arised....

Steps to change the port:

1.First make sure that TCP is enabled for the server(read my earlier post)
2.Open programs>SQLServer 2005>SQLServerConfigurationManager.
3.On the left pane click network configurations>protocols
4.on the right pane ,right click on Tcp
5.Select properties
6.Select IpAddress tab.
7.In IPAll pane enter any port no in the textbox next to TCP Port.

Java Home not found | javac not found

This exception should not occur if JAVA_HOME environment variable is properly set,
But If even then ,it is coming ,Here is the work-around to get your code working:

Copy the the file"Tools.jar" present in C:\Program Files\Java\jdk1.5.0_04\lib folder to
C:\Program Files\Apache Software Foundation\Tomcat 5.0\server\lib folder.

This should make your code work!!!!

Enable Sql Server(2005 Express Edition) to listen on TCP port

MS-Sql Server 2005 Express Edition disables some of the features of SQL Server to minimize memory consumption.One of them is stopping the server to listern on TCP Port.
To enable the feature,follow the steps below:
1.Open Programs>SQL Server 2005>Configuration Tools>Sql Server Surface Area Configuration
2.Click on Surface area configuration for services and connections
3.Double click on SQLExpress>Database Engine>Remote Connections
4.Click on radio button allow remote connections using TCP.

View whether some service is running on a particular port

I wanted to find out MS-SqlServer is running on which port.Although in Control panel>services ,it was showing as running but netstat dint show any trace of sqlserver

so I needed to make sure whether its running on default port 1433

to do that type (at dos prompt)
telnet localhost 1433

it will start a telnet session if some service is running on that port.

Action Servlet not found | Struts | java

Status :Error :404 Action Servlet not found

Java may not be able to find ActionServlet even if struts.jar have been included in build path.
This happens when the tomcat version used is not compatible with jar files included.

Thhe same error occured in my application when i used tomcat instance2.3.When i change the instance to version 2.4,the error disappeared.

Re-create the Show Desktop icon on the Quick Launch toolbar

The Show Desktop icon is not an ordinary program shortcut. If the icon is deleted, the procedure for re-creating the icon is not obvious. To manually re-create the Show Desktop icon, follow these steps:

1.	Click Start , click Run, type notepad, and then click OK.
2.	In Notepad, type the following text on individual lines: [Shell] Command=2 IconFile=explorer.exe,3 [Taskbar] Command=ToggleDesktop
3.	On the File menu, click Save As, and then save the file to your desktop as Show Desktop.scf. he file must now be moved to the correct folder in the user profile to appear in the Quick Launch toolbar. To manually do this, use one of the following methods. Method 1 1. Use the mouse to drag the Show Desktop.scf icon to the Quick Launch toolbar or another location where you want the shortcut to appear. 2. Click Move Here. Method 2 1. Use Windows Explorer to locate the following folders: Microsoft Windows 95 and Microsoft Windows 98 Windows\Application Data\Microsoft\Internet Explorer\Quick Launch Microsoft Windows NT, Microsoft Windows 2000, and Microsoft Windows XP C:\Documents and Settings\Username\Application Data\Microsoft\Internet Explorer\Quick Launch Note Username refers to the account name where you want to put the icon. 2. Use the mouse to drag the Show Desktop.scf file to the Quick Launch folder. 3. Click Move Here. LinkReference:http://support.microsoft.com/?kbid=190355

Password Protect Microsoft Word and Excel Documents

1. left-click on the "Tools" menu
2. select "Options" from the drop down menu
3. On the "Options" screen that appears you must left-click on the 'Security' tab
4.Once you have clicked on the 'Security Tab' you must enter a password in the 'Password to Open:' box.

Dos commands

netstat \b :for displaying all services running on different port

press tab to autocmplete file names

process -k "Process ID"

No command corresponding to Unix ps (view different active processes)
use tasjk manager for dat

Jusched.exe

This process is the Java Update scheduler
To stop it from running
1.open up Control Panel,
2.n XP you can click on the Java icon, or in Vista you can click on Additional Options, and then click on Java
3.Once you have the Java Control Panel open, select the Update tab, and then uncheck the box for "Check for Updates Automatically"

Note:
You'll receive a warning message stating that if somebody finds a security hole in Java that it will take up to a month before you are protected from it

Schedule Java Update Check (Optional)

Just type in Task Scheduler into the start menu search box to open the task scheduler, and then click on Create Basic Task.

Follow the wizard along to pick a month and date, and then when you get to the "Start a Program" screen, use this as the path, adjusting if you are running a different version of Java. The key thing is that you run the jucheck.exe in your Java directory.

"C:\Program Files\Java\jre1.6.0_01\bin\jucheck.exe"

Let outlook find a meeting time when all attendees are available!

Does it get difficult for you to look for a time slot in which everyone is free for the meeting? If yes, don’t worry let outlook find a time when all attendees are available.

Just follow the three steps mentioned below the next time you want to setup a meeting:

Step 1: Click on the Scheduling tab

Step 2: Type the names of the attendees in the All Attendees list

Step 3: Then click on AutoPick Next.

Once you click on the “AutoPick Next” it gives you the next available date and time for all the listed attendees.

_________________________________________________________________________________________________________________________________________________________________________________

Email help

Please ensure that the appropriate next steps are completed(instead of do the needful)

Automatically adding your signature in outlook

Step 1: In the Tools menu, click the Options sub menu

Step 2: Click the Mail Format tab and click the Signatures button

Step 3: Click the New button

Step 4: Type your name in the Enter the name for your signature text field and click Next

Step 5: In the text field, type the details of your signature such as your name, telephone number, designation, and team

Step 6: Click the Finish button

Step 7: Click the Ok button.

Step 8: Click the Ok button.

Now, your signature will automatically appear when you compose a new mail message.

Window Shortcuts

Use the following key combinations to perform routine tasks using the keyboard:

· CTRL+ESC: Open Start menu

· ALT+F4: Quit program

· SHIFT+DELETE: Delete item permanently

· ALT + SPACE: Displays the main window's System menu (restore, move, resize, minimize, maximize, or close the window)

· ALT + SPACE + R: Close the window

· ALT + SPACE + M: Move the window

· ALT + SPACE + S: Resize the window

· ALT + SPACE + N: Minimize the window

· ALT + SPACE + X: Maximize the window

· ALT + SPACE + C: Close the window

· ALT+TAB: Switch between open programs

· Start Menu Key + M: Minimizes all open windows

Start Menu Key + D: Minimizes all open windows