Buchatech.com

I will be attending two FREE webinars one on SharePoint 2010 and one on the basics of CRM.
They are both on the same day February 11th.

• Back to the Basics of CRM (Salesforce.com and Microsoft CRM) - 1:15 - 2:30 pm EST
• SharePoint 2010: World Premiere - 3:30 - 5:00 pm EST

Sign up here

I needed to backup a couple of MySQL databaes automatically. Here is what I did to accomplish this.

I created a folder called mysqlbackup. I then created a script called ”mysqldbbackup.sh” and put this script file in the mysqlbackup folder.

It contains “rm /mysqlbackup/DBNAME_backup.sql
mysqldump -u USERNAME -pPASSWORD DBNAME > /mysqlbackup/DBNAME_backup.sql”

I used the “rm” command to remove the last database backup before the new backup runs. For one of my old blogs on mysqldump command click here.

You have to make the script executable. To do this use the following command

“chmod +x  /mysqlbackup/mysqldbbackup.sh”

Now test your script to make sure it works. CD to the mysqlbackup directory and run the script using by typing “mysqldbbackup.sh”

Ok after it works you need to now schedule it. Use cron to schedule it. I set it to run ever Tuseday at 3am. Use this command to set it via cron  “0 3 * * 2 /mysqlbackup/mysqldbbackup.sh”

For more on cron visit ABOUT CRONJOBS . For more about Linux Shell scripst visit LINUX BASH SHELL SCRIPT

Do you need to track equipment, software, and IP addresses in your IT department? These are a given. The issue is many IT budgets have been cut. Well I have had the same issue. There is a solution. If you have SharePoint 2007 you can use it to manage and track all of these things. If your company has not or does not plan to purchase SharePoint 07 dont worry. You can get Windows SharePoint Services 3.0 for free and you can manage track all of the above with it.

Download Windows SharePoint Services 3.0

I have made som custom lists that I use everyday in SharePoint to help out in my IT department. I am attaching them to this post to share with others admins out there. You can off course modify these once you have them added to your own SharePoint. These lists are:

• Equipment Tracker: Use this list template for tracking equipment in an IT department.
• Software Tracker: Use this list template for tracking software in an IT department.
• IP Tracker: Use this list template for tracking IP addresses in an IT department.

Click to download my SharePoint IT Kit

These list templates are provided “As Is”. I assume no responsibility with use of them. If you find these lists helpful please sign up and leave a comment letting us know how they have helped you.

I was working on a 2003 server and needed to give remote access to users that are not administrators on the server. This was not a terminal server. I added them to the Remote Desktop Users group but they could not logon. When trying to log on as one of the users It gave a message saying the user did not have permission for remote access. To get around this I created a security group called RDPUSERS in AD and gave that group terminal services access to the server in group policy. Here are the steps:

• Go to Aactive Directory and create a security group. Call it whatever you want
• Add all of the non-administrative users you want to have remote access to this group
• Go to start run and tpye gpedit.msc
• On the left pane of the window, expand Computer Configuration>> expand Windows settings>>expand Security Settings>>expan Local policies>>click on User Rights Assignment
• On the right-pane of the window, right click on “Allow log on through terminal services” and choose properties now click add user or group and add the group you created before

Now the non administrative users should be able to log onto the server.

So you have your 2008 servers systemstate backed up by DPM 2007. Your server crashes and you need to recover. DPM 2007 does not give an option to recover to the server only to tape or a network share.

What do you from here? The answer is you have to actually restore the system state using Microsoft’s built in windows backup utility. There is another catch it has to be done via command line using WBADMIN. Here are the steps to recover a server using Windows 2008 Backup from the command line: Read the rest of this entry »

I had a Windows Small Business Server 2008 with WSS 3.0 running on it.  I needed to get to the content databases. I tried to connect to the SQL instance using the default server name (SERVER)\MICROSOFT##SSEE in SQL Management Studio. I was unable to connect no matter what account I used. I discovered it is installed on a windows internal database. Even though the server had SQL Express edition installed I still could not connect via the default server name. I found out that you have to connect using the named pipe. Here is what should be used to connect through SQL Management studio:

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

 I recently had to renew my Exchange certificate as it expired. The original admin that set up this Exchange bought the previous certificate from Digi. I decided to go with Startcom (Free SSL) as I have used them once before in an OCS deployment and they worked out well. Exchange is a little different in that you must use Exchange management shell (PowerShell) during the process of installing a certificate for Outlook Web Access (OWA). I am going to cover 5 steps to installing a certificate Exchange for OWA.

 To Open Exchange Management Shell: Go to START >>Programs>>Microsoft Exchange Server 2007 >> Exchange Management Shell

This is the management shell

Read the rest of this entry »

I ran across a tool Microsoft has for testing remote Exchange connectivity such as: Outlook Anywhere, ActiveSync, Autodiscover and more. Here is the URL: https://www.testexchangeconnectivity.com

Recently I had a virtual machine that would not obtain an IP from DHCP. I noticed the DHCP client service was disabled in windows services. I would enable it, start it and it would start just fine. I would then reboot the VM. The DHCP client service would be disabled again. I had a feeling there was a GPO that was disabling that service. I wanted to check this without going through the domain policy, the local policy and any other group policies that could be causing this. I used a tool in windows called Group Policy Results Tool. You can use this tool to find out how Group Policy settings are affecting both the the computer and the logged-on user.

To track down the GPO setting faster this is what I did:

• Open a command prompt on the client machine
• Type: cd\ (to go to the root of C:)
• Type: gpresult /v >gposettings.txt (This gave me a verbose report of all group polocies applied on the client machine)
• Go to the C: drive and open gposettings.txt in notepad
• I did a search for DHCP in this text file

This brought me to any GPO settings that had anything to do with DHCP. This helped me identify which group policy was pushing down the setting that was disabling the DHCP client service. It was in the Default Domain Policy. This is the path to system services:  Computer configuration\Windows settings\Security settings\System services

If you have a similar issue you can use the above method and Group Policy Results Tool to track down the cause of it.

More information on using the Group Policy Results Tool:

• http://www.microsoft.com/windowsxp/using/setup/expert/gpresults.mspx
• http://support.microsoft.com/kb/321709

Have you ever had devices that where stuck on your system and you needed to remove them. For example someone removed a physical network card from the system without uninstalling it first from the OS. This can be a problem if that network card had a static IP assigned to it. Once you add a new network card using the same static IP that was assigned to the previous network card it will give you an error.

If this were to happen normally you would go to device manager and simply uninstall the device. Well what if they don’t display? That means they are hidden. It is a good thing there is a way to un-hide them so you can uninstall them.

I have created a batch file that contains this:

Read the rest of this entry »