“Terminal server has exceeded the max number of allowed connections” How to bypass this when /consol

mstsc /v: 0.0.0.0 /f /admin
substitute the 0.0.0.0 for your server ip or name.

WARNING! Once you are in.
right click task bar
choose task manager
choose users
choose the user that you want to boot.
click the username and click logoff
once you have removed one or all users (except administrator) disconnect, then connect as normal, without the flags.

Excel and Windows Vista Tip: Opening Excel in Multiple Windows (Especially Useful for Dual Monitors)

Because of the way Excel interfaces with other applications, it is limited to opening all of its workbooks in one window. It does however provide a separate tab for every workbook that is open, and on a single monitor it does appear to be separate windows as you minimize and maximize each workbook individually, but you are still unable to have two workbooks open at the same time on the screen. On a dual monitor (or more) you will find that your workbooks are constrained in a single monitor and you are unable to separate two different workbooks to separate monitors.

There are drawbacks of separating your workbooks into separate windows. For one, copying and pasting formulas from the cells will not work; one way around this is to copy and paste the formula from the formula bar. Another drawback is each “separate” workbook in its own window is a separate instance of Excel and depending on the complexity of the workbooks; this can consume a lot of system resources. It is recommended to only open up 2 or 3 instances of Excel at any one given time.

Option 1: Create a “Open With” right click option

1. Open a Explorer Window and navigate to” C:Program FilesMicrosoft OfficeOffice12 ” (alternativly you can press/hold the windows button and press the “r” button to bring up the run command and copy and paste C:Program FilesMicrosoft OfficeOffice12 and press “OK”)

2. Right click a blank area of folder and select “New > Text Document”. You will be prompted to name the file with “New Text Document” highlighted, go ahead and highlight everything “New Text Document.txt” and name it DualExcel.bat and press enter. You will imeadiatly be prompted with as dialog box asking “Are you sure you want to change it?” along with a warning about changing the file name extension, press “Yes”. (If you happen to click off of the new text document before naming it, you can right click “New Text Document.txt” in the Office12 folder and select “Rename”).

3. Right click DualExcel.bat and select “Edit”, the file will open with Notepad.

4. Either copy and paste, or type in:

@echo off

@start /d “C:Program FilesMicrosoft OfficeOffice12″ EXCEL.EXE /e %1

@exit

5. Choose “File” > “Save” in Notepad’s toolbar, then exit out of Notepad.

6. Now to add DualExcel.bat to your “Open With” menu. Find a Excel file, Right Click and choose “Open With” > “Choose Default Program…”, a “Open With” Dialog box will appear. The first thing you want to do is uncheck the box that states “Always use the selected program to open this kind of file”, and then choose “Browse” located to the right of that check box. In the new dialog box, by default it should open the “Program Files” folder, double click into “Microsoft Office” folder, and then Double Click into the “Office12″ folder. Now highlight the “DualExcel.bat” file and press the “Open” button. You will be brought back to the “Open With” dialog box, make sure the DualExcel.bat option is highlighted and press the “OK” button.

7. Now the “DualExcel.bat” option will always be availible when you Right Click on a Excel file and choose “Open With”. By using the “Open With” option, for this to work, you will have to Open With the DualExcel.bat on two or more Excel Files.

Option 2: Always have Files open with the DualExcel.bat feature.

Follow all the same steps as Option 1, with the exception of unchecking the box “Always use the selected program to open this kind of file”, make sure that this check box has a check mark in it. You will also want to make sure that both Excel file formats ( xls and and xlsx ) by going through this procedure with both file formats.

These options only work for double clicking on a file. If you open Excel through the Start menu, it will open Excel normally. If you want a shortcut to open Excel with these features without opening a file. Right click a blank area on your desktop and choose “New” > “Shortcut”. Hit the “Browse” button, and press the arrow next to “Computer” > “Local Disk (C:)” > “Program Files” > “Microsoft Office” > “Office12″, highlight “DualExcel.bat” and press “OK”. Then when prompted for the name of the shortcut, call it “Dual Excel” and press the “Finish” button.

Outlook 2003: Copying Internet Headers

1. Open Outlook 2003.

2. Locate the message you would like to copy the internet headers from and using your mouse, right-click the message.

3. Next, left-click on Message Options… from the menu as shown below.

4. This should open a window called: Message Options. You should notice the mouse pointer located around the area labeled: Internet headers, close to the bottom left corner.

5. Move your mouse pointer to the box of text to the right of the Internet headers label. This will cause the mouse pointer to shift into an icon that resembles an upper case I, as shown below.

6. Next right-click in the box to open a menu that will allow you to select all of the text.

7. Left-click the Select All option at the bottom of the menu, to select all the text in the Internet headers:.

A. This should cause all the text under the Internet header box to be highlighted similar to the method shown in this example.

8. Right-click in the area to open another menu box.

9. Select copy from the menu, by left-clicking the option.

A. The process above, allowed the Internet header to be copied for transfer to another application. There are many different applications this data could be pasted too. For example: an email in Outlook, office document, notepad, wordpad, etc…

10. For this example I am going to paste the data to another email. In order to do this, the Message Options window will need to be closed.

11. Next open a new message to paste the Internet header information to, by left-clicking the new message option as shown below.

12. Right-click in the new message as shown in the example.

13. Left-click the Paste option to paste the data into the new message.

A. This should paste the text into the new message.

14. Now that that data has been pasted into the new message, it could be sent to an IT department for review by filling in the To… field as shown below.

The copy / paste method could also be used to transfer the data into Word, Excel, NotePad, WordPad, and similar applications.

Outlook 2007: Copying Internet Headers

1. Open Outlook 2007.

2. Locate the message you would like to copy the internet headers from and using your mouse, right-click the message.

3. Next, left-click on Message Options… from the menu as shown below.

4. This should open a window called: Message Options. You should notice the mouse pointer located around the area labeled: Internet headers, close to the bottom left corner.

5. Move your mouse pointer to the box of text to the right of the Internet headers label. This will cause the mouse pointer to shift into an icon that resembles an upper case I, as shown below.

6. Next right-click in the box to open a menu that will allow you to select all of the text.

7. Left-click the Select All option at the bottom of the menu, to select all the text in the Internet headers:.

A. This should cause all the text under the Internet header box to be highlighted similar to the method shown in this example.

8. Right-click in the area to open another menu box.

9. Select copy from the menu, by left-clicking the option.

A. The process above, allowed the Internet header to be copied for transfer to another application. There are many different applications this data could be pasted too. For example: an email in Outlook, office document, notepad, wordpad, etc…

10. For this example I am going to paste the data to another email. In order to do this, the Message Options window will need to be closed.

11. Next open a new message to paste the Internet header information to, by left-clicking the new message option as shown below.

12. Right-click in the new message as shown in the example.

13. Left-click the Paste option to paste the data into the new message.

A. This should paste the text into the new message.

14. Now that that data has been pasted into the new message, it could be sent to an IT department for review by filling in the To… field as shown below.

The copy / paste method could also be used to transfer the data into Word, Excel, NotePad, WordPad, and similar applications.

How to recognize phishing scams and fraudulent e-mails

What is Phishing?

Phishing is the fraudulent process in which a criminal attempts to acquire sensitive information such as user names, passwords, banking and credit card details by pretending to be a legitimate business through the form of emails or instant messages. In most cases, a phishing attempt will direct a user to a fake website that mirrors the look and feel of a legitimate website.

Spear Phishing is a more refined/targeted process to gain sensitive information. A good example of Spear Phishing is a fake email sent to your email address, that contains a certain amount of your personal information to make the email look and feel genuine. For example, it may contain your name in the subject and body of the email.

Tips – Avoid Phishing Schemes

1. Do not trust email headers, they are easily forged.

2. Just as the header is easily forged, the “reply to” and the “from” email address’s can not be trusted.

3. Pay close attention to the links contained within the email. Links are just shortcuts, the actual link and what appears as text may be different. Hoover over the link and make sure that it is a website that you want to visit (Email clients will show the actual link under your cursor, and web based email will show the link on the bottom bar of your web browser). Also note that phishing scam artist’s will make the link look as close as possible to the real thing.

4. The emails quite often have official looking or duplicated logo’s from real organizations and other identifying information taken directly from legitimate websites.

5. Try to avoid filling in any forms that are contained within emails, the forms are not secure and you should never enter in any personal information.

6. Avoid phrases that are like: “Verify your account.”, “If you don’t respond within 48 hours, your account will be closed.”, “Dear Valued Customer.”, “Click the link below to gain access to your account.”.

How to change your network password during a RDP session

Normally you would press “Ctrl – Alt – Delete” to pull up the Windows Security Prompt and choose “Change Password”. But in a RDP Session (Remote Desktop Connection) the “Ctrl – Alt – Delete” only works on the local machine and not the Remote Desktop, so instead you will have to use one of the options listed below to bring up the same Windows Security Prompt.

Option 1

In almost all cases, a “Ctrl – Alt – End” will send a “Ctrl – Alt – Delete” to the remote host, bringing up the Windows Security Prompt, and from there you would press the “Change Password” button.

Option 2

If the “Ctrl – Alt – End” does not work, or is not available, you can alternatively go to Start > Windows Security. On the Windows Security box, press the “Change Password” button.

* In order for either one of these options to work, you need to be connected to a RDP Session (Remote Desktop Connection)