Thursday, October 22, 2009
Turn 3 dimensional (pivot) table to junction table
Tuesday, October 13, 2009
Macro to paste unformatted text in word
- Copy a bit of text
- Choose the Developer tab
- Record macro (save in the norma.dotm template)
- Choose a smart keyboard combination, for example ctrl + shift + v
- Paste the text somewhere in the document
- Stop the macro
- Edit the macro and replace the one line with
- Selection.PasteSpecial Link:=False, DataType:=wdPasteText
Monday, October 12, 2009
Create domain trust
Wednesday, October 7, 2009
Useful tools for Active Directory
Tool for restoring deleted files
NIST firewall policy
Enable anonymous access in Sharepoint.
Enabling anonymous access to a sharepoint site requires to separate activities.
1. Enable in Central Administration: Application management --> authentication providers --> Default --> Enable anonymous access
Note: DO NOT CHANGE ANYTHING IN IIS
Navigate to the site where you want to enable anonymous access: Site actions --> Site settings --> Advanced permissions --> Settings --> Here you should see an option for Anonymous access.
Cool tool for recording streamed multimedia
Translate business security needs to the configuration and management of security devices.
Reliable process for security policy development
“We focus in this paper on the problem of configuring and managing network security devices, such as Firewalls, Virtual Private Network (VPN) tunnels, and Intrusion Detection Systems (IDSs). Our proposal is the following. First, we formally specify the security requirements of a given system by using an expressive access control model. As a result, we obtain an abstract security policy, which is free of ambiguities, redundancies or unnecessary details. Second, we deploy such an abstract policy through a set of automatic compilations into the security devices of the system. This proposed deployment process not only simplifies the security administrator's job, but also guarantees a resulting configuration free of anomalies and/or inconsistencies.”
Schedule backup with synctoy
Schedule SyncToy Sync Task in Windows Vista
- Click on the Start menu, then select All Programs - Accessories - System Tools - Task Scheduler.
- Click on Create Basic Task in the “Actions” pane on the right.
- In the “Create Basic Task Wizard”, type in a Name and Description. For example, SyncToy Synchronization.
- Click on Next button.
- Choose the frequency of when do you want the task to start. If you always make changes to the files, Daily is a good choice.
- Click on Next button.
- Choose date and times (if applicable) to trigger and run the task.
- Click on Next button.
- In the “Action” step, select Start a Program as the option for the task to perform.
- Click on Next button.
- Under “Program/Script”, click on Browse button and locate the SyncToyCmd.exe. Normally it’s located in “C:\Program Files\SyncToy 2.0 Beta\SyncToyCmd.exe” for SyncToy 2.0 Beta.
- In the “Add Arguments” textbox, type -R. –R will run all folder pairs that are active for run all. If you want to run just a single folder pair, add –R”folder pair name” to the end of the command line.
Note: there is a space before the hyphen but not one after the R. If the folder pair name contains a space, surround it with quotation marks, as the example above shows. For another example, assume that SyncToy is in the folder named C:\Program Files\SyncToy 2.0\ and that you want to run a folder pair named “My folder pair.” Enter the command line as follows, including the quotation marks: “C:\Program Files\SyncToy 2.0\SyncToyCmd.exe” -R”My folder pair.” Note that there are two sets of quotation marks in this case: one is around the path to the SyncToy program file and the other surrounds the folder pair name.
Schedule a SyncToy Task in Windows XP
- Go to the Start menu, select All Programs - Accessories - System Tools - Scheduled Tasks.
- Select Add scheduled task to start the Scheduled Task Wizard. You will see a list of possible programs to run.
- SyncToy may appear as an option in the list. If SyncToy does not appear in the list, click Browse and locate the SyncToy executable. Normally it’s installed in Program Files directory.
- The wizard will next prompt you to enter how often you want to run the scheduled SyncToy (for example, daily, weekly, et cetera). Select a frequency.
- The next page asks when to start the task. Select a start time.
- The next page asks for the user name and password to run the program under. Enter your user name and password. However, in SynToy 2.0, it’s not necessary for the defined user to log in to the computer. Different user or no one logged on is possible to have the task running too.
- The final page contains an option to open the properties dialog when the wizard ends. Select this checkbox.
- Modify the Run textbox to include the –R command line option. –R all by itself will run all folder pairs that are active for run all. If you want to run just a single folder pair, add –R“My Pair” to the end of the command line.
Note: there is a space before the hyphen but not one after the R. If the folder pair name contains a space, surround it with quotation marks, as the example above shows. For another example, assume that SyncToy is in the folder named C:\My Folder and that you want to run a folder pair named “My folder pair.” Enter the command line as follows, including the quotation marks: “C:\Program Files\SyncToy 2.0\SyncToyCmd.exe” -R”My folder pair.” Note that there are two sets of quotation marks in this case: one is around the path to the SyncToy program file and the other surrounds the folder pair name.
Install EventSentry on a 64 bit Sharepoint server
Scenario: You want to install Eventsentry on a 64 bit server hosting sharepoint. The problem is that the web reports in Eventsentry, in the case of 64 bit, require IIS to run in 32 bit mode, which is not an option an an 64 bit SP install. The approach was to put the web reports on a different server.
- Make sure to have an ES config export file as well as an export only including filter packages and an export file for the custom web reports.
- Install MySQL as outlined in the ES documentation
- Install ODBC driver (wait to configure)
- Install ES without DB support and web reports
- Run modify wizard and add MySQL support.
- From the Management interface, add an db action to test the database.
- Configure ODBC System DSN with the eventsentry_svc user. Test if it works
- Import the config XML file. Restart the GUI.
- Check if everything seems properly done.
- In particular, reconfigure the DB action if needed.
- Copy the Eventsentry folder under Program Files to the server used for the web reports (use the same place). Set permissions on the folder to only allow admininstrator access (and the System account).
- Make sure that Active Server Pages is added in Windows Componenents (Application Server --> Details, Internet Informations Service --> Details, World Wide Web Service --> Details, Check Active Server Pages
- On the web server, create a new web site, point it to the copied Eventsentry folder (eventsentry/web).
- Add “index.asp” as “document” in the properties for the web site (in IIS).
- Check Windows integrated authentication in IIS Manager.
- The first time you access the web reports, choose to disable authentication (trust the NTFS permissions).
- You propably need to reconfigure the database setting on the Default Profile.
Move Sharepoint to 64 bit server
Scenario: A Sharepoint stand-alone (Basic Install with SQL Express) environment needs to be moved from a 32 bit server to a 64 bit server. The orignal installation is done from a Swedish installer while the new installation is done from a english installation.
This is what worked for me:
- Install Win Server 2003 64 bit. I had to use a Dell CD to manage to install on the RAID setup.
- Install MOSS 2007 English from CD (Install from a downloaded copy did not work, the config wzard hung)
- Choose basic installation
- Run the config wizard
- Download language pack (.img opens with WinRAR)
- Install language pack (make sure it is the right one, swedish, 64 bit, moss 2007 etc.)
- Run the config wizard again
- Run Microsoft Update. Make sure to get the latest SP updates. At least newer than the environmnet your moving from.
- Delete the site collection via Central Adminstration and create a new one with the right language pack. Use the same template as the site you want to move.
- You can check what template was used by creating a aspx site. Google “determine site template”
- In my case the site template used was now deprecated. My solution was to create a custom site template, upload it to the created site and create is as an subsite. However, I got “File not found”-error on the new site.
- At this point, i used STSADM to make a backup of the original site
- Restored the backup to the faulting subsite using STSADM
- Voila, an exact copy was now up and running on the new server!
- It did bring up a login dialog when browsing on the local server, but not browsing from a arbitrary client (or other server).
- Added a hostname “temp” and created a DNS A record “firstname.lastname@example.org” pointing to the IP adress of the new server.