Mark Iwaszko's technical blog

Problems deleting a Sharepoint 2010 list

2012-02-13T12:24:00.001Z

You can use the Powershell command below to delete a list, however if you get an error in the form of "This list cannot be deleted." then go to Step B and try Step A again. Step A - try to delete a list $w = Get-SPWeb "http://myweb" $w.Lists.Delete([System.Guid]$w.Lists["My List Name"].ID) Step B - toggle list cannot be deleted error $w = Get-SPWeb "http://myweb" $list = $w.Lists["My

Where is the "Local Drafts Folder"

2012-02-06T12:37:00.001Z

Checking out Sharepoint documents to work on offline prompts you to use the Local Drafts folder - but where is it? Try "My Documents\SharePoint Drafts"

Opening a Sharepoint 2010 site using claims authentication and the object model

2012-01-31T13:16:00.003Z

ClientContext ctx = new ClientContext(someSiteUrl); ctx.AuthenticationMode = ClientAuthenticationMode.FormsAuthentication; ctx.FormsAuthenticationLoginInfo = new FormsAuthenticationLoginInfo(myUserName, myUserPwd); //get the web Web w = ctx.Web; //execute the query ctx.ExecuteQuery(); http://blogs.technet.com/b/speschka/archive/2010/06/03/

Office 365 - Powershell connection

2012-01-03T13:02:00.003Z

To connection to Office 365 use the following set of commands. Firstly let Powershell have permission to run remotely signed scripts. Then set the credentails to logon with, create a Powershell session to Office365. Import the commands you can use in that session and then off you go.... Set-ExecutionPolicy RemoteSigned $LiveCred = Get-Credential $Session = New-PSSession -

Office 365 - hiding an external contact from the GAL

2012-01-02T15:18:00.002Z

1. Connect to Exchange Online by using PowerShell. For more information about how to do this, see the following article: http://help.outlook.com/en-us/beta/cc952755.aspx?sl=1 2. Run the following cmdlet to hide an external mail contact: Set-MailContact -Identity -HiddenFromAddressListsEnabled $true By doing so, the external mail contact will be hidden from global address list (

How to turn on email archiving in Office 365

2012-01-02T15:15:00.004Z

It took me a while to see if this was even available in Office 365 P1 Plan, but it is and you can enable it as follows: · Login to your web login.microsoftonline.com portal · Admin · Users · Select user and Edit · More from the menu under the user name · Change Mailbox Settings · Expand mailbox features · Select Archive and

Displaying other Outlook accounts when migrating to Office 365

2012-01-01T13:08:00.001Z

In migrating Email accounts in Outlook 2010 to Office 365, Ive been copying email from the users existing exchange account to the new Office 365 folders (after adding the new Office 365 account as an additional Exchange account in Outlook) I then needed to add additional mailboxes from the new Office 365 users onto the secretaries Outlook, however the normal functionality wouldnt work.

Office 365: one or more users need an assigned license

2011-12-31T17:36:00.000Z

I recently setup a five user P1 Email system on Office 365. Iniitally I setup the default xxx.onmicrosoft.com domain and added the users. Then I added the "Vantiy domain" ie mycompany.com (why Microsoft call this a vanity domain is beyond me, Id call it an essential to do business domain, but....) I then changed the logon primary account for each user from @xxx.onmicrosoft.com to @

An interesting article on MS CRM Reasons to use SharePoint 2010

2011-10-13T15:33:00.000Z

An interesting article on MS CRM Reasons to use SharePoint 2010 http://www.powerobjects.com/blog/2011/03/15/crm-reasons-to-use-sharepoint-2010/

Viewing Sharepoint sites on the Sharepoint server (disabling server loopback checks)

2011-10-07T19:10:00.000Z

Its been a problem since Win2003 SP1 that you couldn’t browse to a web site hosted on Sharepoint on that server.Ive now found this is security restriction called loopback check, where the server stops any access back to itself unless you use the server’s name in the URL. There are two alternatives to stop this behaviour. Option 1 - is to disable the loopback check for all sites – which should

After adding a new Exchange 2010 DB - BES users no longer work once moved to it

2011-08-31T13:02:00.000Z

By default it would appear that BES doesnt have permission to access a new Exchange Database. In this Blackberry knowledge base article recommend using powershell to update the permissions on all mailboxes on a server. For Microsoft Exchange 2010 Click Start > Programs > Microsoft Exchange Server 2010 > Exchange Management Shell. Open the command prompt as administrator, type the

Some usefull Exchange 2010 powershell scripts for space management

2011-06-01T13:21:00.004Z

Force remove disconnected database after a move or delete Remove-StoreMailbox -Database "" -Identity "" -MailboxState SoftDelete Exchange 2010 Find Database White Space Get-MailboxDatabase -Status | Select-Object Server,Name,AvailableNewMailboxSpace Retrieve List of Disconnected Mailboxes Get-MailboxDatabase | Get-MailboxStatistics | where {$_.DisconnectReason -eq “SoftDeleted”} | Select

Sharepoint FBA user administration (Forms Based Authentication)

2011-05-10T13:02:00.000Z

We had a strange error where a user couldnt log on using FBA. It turned out that the account was locked out, however it started a voyage of discovery into the murkey world of FBA in Sharepoint. To add an FBA user we use the + _layouts/vCreateUser.aspx which works out fine, however with FBA it was not obvious how to either Reset a users password by the administrator or Delete a user. Using II7

How to: Set Default Column Values on a folder programmatically | Corey Roth

2011-03-27T21:21:00.000Z

How to: Set Default Column Values on a folder programmatically Corey Roth

SharePoint: Displaying A Folder's MetaData Above a List | Wed 7 Jul 2010 | Blog | CodeStore

2011-03-27T15:37:00.000Z

SharePoint: Displaying A Folder's MetaData Above a List Wed 7 Jul 2010 Blog CodeStore

AD Sync: The source server is currently rejecting replication requests

2011-03-02T18:28:00.000Z

After a few power outages one of our DC's decided not to co-operate in Syncing data. The Directory Service App Log gave lots of errors talking about "The Knowledge Consistency Checker (KCC) being unable to form complete spanning tree network topologies" but nothing really useful to work with. I first used repadmin /replsummary to try to see what was wrong, but it only confirmed that there were

Windows 2008 INCORRECT FUNCTION error, sharing folders or file shares

2011-02-28T15:24:00.000Z

If you get the error "Incorrect Function" on a Windows Server 2008 or 2008R2 when trying to share a folder or create a file share then you will find the error message "INCORRECT FUNCTION" is extreemly useless. It occurs because you don't have the Firewall Rules for Inbound and Outbound "File and Printer Sharing" included in your rule sets. But I have firewall disabled I hear you cry! For

Animoto - The End of Slideshows

2011-02-22T10:14:00.000Z

A very smart video and picture compilation piece of softwareAnimoto - The End of Slideshows

Running a Virtual Router & Firewall inside VMware ESX with Vyatta

2011-02-22T09:46:00.000Z

I needed to run an router inside and ESX server to route between a couple of virtual networks and came across Vyatta. I'm sure loads of people know about this but I'm a newbie to network routers so was quaite taken by its functionality.Although this video is old it gives a very good understanding of what Vyatta is and how to install it on ESXiRunning a Virtual Router & Firewall inside VMware ESX

32bit ODBC on a Win7 64 bit machine

2011-01-06T15:26:00.000Z

We had a requirement to run Access 2003 on a Windows 7 64 bit server and couldnt find the 32bit ODBC settings anywhere. They are not shown in the control panel app, however you can find them at C:\Windows\SysWOW64\odbcad32.exe

Exchange 2010 ActiveSync not function for Domain Admins user

2011-01-03T22:13:00.000Z

I built a new domain with my own account as Domain Admin, and then after installing Exchange 2010 couldnt work out why every other user except me could access ActiveSync.The issues turns out to be that AD membership of certain Admin "Protected Groups" turns off the inherited permissions on your AD account in the OU that you reside. To check if Inheritance is disabled on your user account, Open

SQL server has been renamed but the operation is incomplete

2010-12-23T23:24:00.000Z

I recently moved a number of SQL servers to a new domain and renamed the servers. In the past this has worked fine with SQL 2008, however I was having trouble with an application on SQL 2005. According to this blog post "The most common cause of this is if the SQL Server has been renamed after SQL Server was installed. The reason is that, at installation time, SQL Server stores the computer

MyTechEd 2010 Wednesday Sessions

2010-11-10T11:39:00.002Z

OFS308 - Deploying Microsoft SharePoint Server 2010 with Claims Authentication WSV205 - Remote Desktop Services: Virtual and Session-Based Desktops and Applications Architecture with Partners OFS223 - Office Web Apps Architecture & Deployment Office web apps WSV301-LNC - BranchCache in Action WCL313 - Troubleshooting Group Policy VIR306 - Desktop Virtualization: You Have a Choice 6 MGT204 -

MyTechEd 2010 Tuesday sessions

2010-11-10T11:36:00.004Z

COS201 - Office 365: What’s Coming Soon SIA320 - Impact of Cloning and Virtualization on Active Directory Domain Services WSV201-IS - Working with BranchCache – Beginning to End UNC308 - Archiving, Retention and Discovery with Microsoft Exchange Server 2010 SP1 WSV202 - Windows Server 2008 R2: File Services Overview Slides will be available here

Microsoft TechEd 2010 in Berlin

2010-11-10T11:18:00.003Z

Microsoft TechEd 2010 in Berlin. The first day was somewhat dissapointing with teh pre-conf sessions seeming to concentrate on level 100 and 200 content, particularly with Lynq which seemed to lack substance, so instead I hit the labs with DPM and SCOM.vNext which were both very good Keynote wasn't bad, with good stuff on Office 365 and Intune, however there is so much marketing on Winphone

Rename a domain controller using Netdom: Active Directory

2010-09-12T07:11:00.001Z

Note: newname for computer must be full DNS - ie newname.yourcompany.co.uk Create an additional new name for the servernetdom computername oldname /add:newnameMake the new name the primary computer name for that servernetdom computername oldname /makeprimary:newname Reboot Remove the old computer name netdom computername /remove:oldname Rename a domain controller using Netdom: Active Directory

Windows Server, IIS/SharePoint, and NULL SID ‘Audit Failure’ Security Errors

2010-07-20T15:27:00.000Z

Whilst I understand why Microsoft might keep tightening up their servers to stop malware attacks, it would be very helpful if they could put some indication of when they are stopping these attacks into a sensible message in the event log. I have spent 2 days trying to sort out an error on a development machine with the only pointer being NULL SID - brilliant and thank you Microsoft.Windows Server

Viewing SharePoint 2010 sites on Windows Server 2008 R2

2010-06-10T09:42:00.002Z

Running SharePoint 2010 server on a Windows 2008 R2 server seems to be a sensible thing to do. Well at least I thought that until I tried to locally access SharePoint sites on that server via IE. You will find that on Windows Server 2008 R2, you will be prompted for authentication three times and the page will fail to load. This is because R2 uses the new SPNEGO2 implementation: (You may ask

SharePoint Technology Conference | October 20-22, 2010 | Boston

2010-06-09T12:15:00.000Z

An interesting Sharepoint Conference to consider for OctoberSharePoint Technology Conference October 20-22, 2010 Boston

Access Web Services : form filtering and sorting

2010-06-09T12:06:00.000Z

If you setup a form based on a table source and then add in the forms properties to sort and filter, when you add this form to a Navigation page it completely disregards what you have entered in the forms properties and just uses the default sort for the table with all values - Brilliant Microsoft! Filter and Order By Properties get ignored. So to get around this for sorting you need to

Access Web Services : filtered field lookup lists

2010-06-04T15:21:00.002Z

One of the key advantages I thought of for using Access Web Services in SharePoint is for populating fields with lookups. Whilst you can do this in SharePoint using the whole list as a lookup there is no way to filter that list. So if you want to filter out all assignments which are marked with a status of complete then you are stuffed! But with Access Web Services I thought you could use

SharePoint 2010 : State Service issues & problems

2010-06-01T23:36:00.005Z

I built two SharePoint Enterprise servers in separate farms from scratch using different farms and SQL servers. The first is a development machine to try things out on and the second is the production box. As with all the best MVP advice you should not use the configuration wizard but manually create each service and for the most part Ive done this successfully, however when we started trying

Access 2010 Web database conversion

2010-05-31T14:29:00.001Z

Native SharePoint 2010 is dissapointing in terms of not being able to have relational data lists or lookups with filtering and for reporting I used Access reporting based on SharePoint lists. With Access Services in SP2010 I thought I'd just convert these reports and data sources over, but as ever its not that simple. You need to create a new Access Web database and then import tables into Web

IE Automation & Tabs - Tony Schreiner's Blog - Site Home - MSDN Blogs

2010-05-28T15:58:00.000Z

I wanted to launch IE and open several additional tabs. - thanks to Tony Schreiner's blogIE7 does not support specifying multiple URLs on the command line, but another way to do this is to use IE Automation to launch IE as an out-of-proc COM server and then call methods such as IWebBrowser2::Navigate2.While you can do this using C++ or any language that supports COM, the easiest is to use Windows

Firebox x10 user count exceeded error

2010-05-27T17:26:00.001Z

On adding a couple of new devices behind my firebox firewall I recieved the most unhelpfull message "user count exceeded". I double checked everything and after many weeks of fighting with the issue I finally found the solution. What the error message means is that there is a licensed limit (based on the key you've purchased) for the number of IP addresses on the local network that can use the

How to remove the “title” column from a SharePoint list | EndUserSharePoint.com

2010-05-23T21:32:00.000Z

With custom Sharepoint lists or those imported from Excel the default Title field (which is inherited from the content type Item) is always included. This link gives a neat trick to hide this field from the edit screen if you dont want it. How to remove the “title” column from a SharePoint list EndUserSharePoint.com:

How To: Create, Configure, Consume SharePoint 2010 Secure Store in Business Connectivity Services

2010-05-21T10:21:00.000Z

How To: Create, Configure, Consume SharePoint 2010 Secure Store in Business Connectivity Services

Configuring Business Data Connectivity Services

2010-05-21T08:20:00.002Z

Setup BDC with its own user, database and App pool Start the service You should have a pages host to contain the external content type definitions so you need to Configure /add an External Content Type Profile Page Host. Create a new site collection (I use the same web application as the metadata hub created earlier) Use the Publishing Pages Portal Template Once published goto Central Admin ->

Multiple Authentication Methods in SharePoint 2010

2010-05-21T07:42:00.003Z

There are new and exiting authentication methods such as Claims-based authentication in SharePoint 2010 which leads Microsofts product line in being the first Server to offer it. This article introduces them while (alive) { writeCode(); } : Multiple Authentication Methods in SharePoint 2010:

Setup Managed Meta Data Hub for the Sharepoint 2010 farm

2010-05-20T21:57:00.006Z

My personal notes to: Setup a Managed Meta Data Hub for the SP2010 farm Create a new web applicationCreate a new user for this (and make sure its in the Managed accounts list with the correct permissions) Create a new web application & make sure the "Document Sets metadata synchronization" web app. feature is activated (you can find this by managing the web application and choosing "manage

SharePoint 2010 Connection Filter Logic

2010-05-20T20:40:00.005Z

For SharePoint 2007 our MOSS profile sync uses the an LDAP query that filters which OU Users we dont't require - ie User filter: (&(objectClass=user)(!Status:=System)(!UserAccountControl:1.2.840.113556.1.4.803:=2)) This assumes we want everyone except those with and AD attribute of Status=System (the UserAccountConrol setting excludes accounts disabled) For SharePoint 2010 once you have setup

The importance of SharePoint 2010 Managed Service Application install order

2010-05-20T16:40:00.003Z

SharePoint 2010 is very unforgiving when it comes to the configuration of its Managed Service Applications. Not only do all the security settings need to be just so, but the order of install needs to be just right. Because of this sensitivity, after installing the binaries and getting the administration site running I concentrated on getting the most tricky Service Apps running first, ie the

Visual Studio error 'Cannot find the certificate and private key for decryption'

2010-05-17T12:08:00.001Z

I have a perfectly good (and expensive) Thwate Code Signing Certificate - but when I try to import it into Visual Studio to sign an assembly I get a daft error of the form of the title above. I thought MS might have fixed this in VS2010 but no.The problem appears to be that the certificate holds too much information for VS to comprehend, so you need to import the Certificate onto your machine and

Sharepoint 2010 BCS connection getting started and authentication issues

2010-05-11T11:09:00.007Z

There is a very good "get you started" article here, walking you through creating a SharePoint List to an external SQL table. Whilst all the steps were clear it did not deal with security and authentication to the SQL server. Several methods are available to connect through to back end data providers, however "Connect with User's Identity" (or Pass Through) will only work with Kerberos enabled,

SharePoint 2010 and Project 2010 Server demo and Eval VM (RTM edition)

2010-05-09T20:08:00.005Z

Having spent a week fighting with SharePoint 2010RTM to setup demo scenarios, it is refreshing to see that Microsoft have released RTM VM machines for both SharePoint and Project server. Downloading now and will see what goodies they hold...Chris Johnson : SharePoint 2010 Demo and Eval VM (RTM edition): "SharePoint 2010 Demo and Eval VM (RTM edition)"

Running VMware vSphere Client on Windows 7

2010-03-26T12:06:00.002Z

The problems running vSphere clients on Windows 7 have brought a lot of pain and the proposed workarounds were complex and invariably didnt work.BUT here is a very good simple arcticle which works ! - we like this a lot...

Sharepoint 2007 wildcard searching

2010-03-24T15:41:00.002Z

To use a wildcard search or part of the name, you must specify the field name you are looking for.eg. FileName:whiz* will find all documents with a FileName starting with "whiz"I havent found a way to search on field's with spaces in yet (ie where there is a space in the file name replacing it with _x0020_)There is a good article herehttp://www.novolocus.com/2009/05/27/

dotNet Dictionary - ContainsKey

2010-02-25T17:03:00.002Z

I think Dictionary objects are brilliant data structures. The way they can contain objects and nested dictionaries within them seleves makes them a fantasic store, However I was using a Dictionary obect to store Key Value Pairs and I couldnt be sure that I knew if all the key's were present. The first way I found to check was to try to get the key within a Try Catch block and if they key wasnt

A couple of Excel VBA usefull notes

2010-02-25T16:28:00.003Z

UserName = Environ("Username")Domain = Environ("UserDomain")Combined= Environ("UserDomain") & "\" & Environ("Username")CurrentDate = DateCurrentTime = TimeSome file and folder VBA commandsCurrent folder name: CurDirChange the active folder: ChDir "C:\My Documents"File exists test: If Dir("F:\My Documents\My Workbook.xls") <> "" Then ....Delete a file : Kill "F:\My Documents\My

February 2010 Windows Media Center Cumulative Update for Windows 7

2010-02-25T16:12:00.002Z

Although Windows 7 Media Centre is much better than previous releases - its support of media extenders such as Xbox 360 and Linksys are woefully behind. Here is the latest patch for Windows 7 and I do hope that this is supported by the extenders being updated as well.

Sharepoint list item - custom drop down menu

2010-02-25T10:25:00.004Z

To be able to customise Sharepoint Context menus easily using Javascript in a a Content Editor Web Part is extreemly powerfull and remarkably simple to get working. - see this article for guidance Customizing SharePoint Context Menus.(Suplimental: The obove article is ok as far as it goes however to try to get the client side menu to carry out actions is not simple. You need to be skilled in

BUG: SSIS 2008 derived columns from User variables data type

2010-01-27T15:13:00.002Z

I wanted to create a derived column from a user:variable in SSIS so that I could combine the input of a CSV into a SQL table along with a column name saying where the CSV came from.Usually you initialise the user:variable before the package starts with a non relevant string, such as "1234" then updated it to the correct value once the process starts.The problem is that when you use the Derived

Another Microsoft SQL exam passed

2010-01-26T16:32:00.002Z

I'm sure it gets harder to study and pass exams as each year goes by, however just managed to achieve 98% in Microsoft SQL Server 2008, Implimentation and Maintenance so off for a beer to celebrate.

Summing Excel Range Intersects

2010-01-26T16:06:00.003Z

Ever wanted to add up the value of the Intersecting Sets or Ranges.I had a couple of Ranges as rowns, eg Dept1 = Rows A1:N4 , Dept2 = Rows (A5:N6, A12:N16) etcand then Columns Ranges for Jan, Feb eg Jan = Column B1:B12, Feb = C1:C12 etc.I wanted to get the sum of the Intersection between Ranges Dept1 for Jan. To do this use a Space as an operator. eg =Sum(Dept1 Jan)Whilist everyone knows

Using Windows 7 for "Server-like" loads

2010-01-19T00:04:00.002Z

I'm studying for a SQL 2008 exam and found that you can mirror up to 3 backups to different devices, so when a client had some new Windows 7 machines delivered with loads of spare hard drive, I thought this would be an excellent location to backup an additioanal copy of SQL to overnight.However after about a 15Gb backup from SQL 2005 server onto a Windows 7 share, the Windows 7 workstation seemed

ICO (Windows Icon) file format plugin for Photoshop

2010-01-12T15:27:00.000Z

A very usefull Adobe photoshop CS plugin that works really well.ICO (Windows Icon) file format plugin for Photoshop

Configuring User Profiles in Sharepoint 2010 beta 2 in the enterprise

2009-12-15T16:11:00.001Z

This gives an interesting walkthrough for configuring user profiles. (Despite 5 installs of a Sharepoint 2010 its still not quite right).Ive found this is a very tricky and time consuming process fraught with problems and Kathy's notes are very helpful.in reference to: Kathy Hughes, MVP (view on Google Sidewiki)

Running SSIS packages from a web page

2009-10-14T11:26:00.003Z

I need to run a simple aspx page on a SQL server to run an SSIS package so that users could kick off the process without having access to the SQL admin tools.The following C# class in an asp.net page runs brilliantly on the SQL 2008 serverstatic void CallSSIS() { string pkgLocation = @"E:\VS Projects\\Sandbox.dtsx"; Application ssisApp = new Application(); Package

Symantec System Center - Cant unlock server group

2009-10-12T16:54:00.000Z

I was asked to look at unlocking a Windows 2003 Server Symantec System centre whos documented name and password didnt work.If you a) update the "user-admin-p" registry entry - HKEY_LOCAL_MACHINE\SOFTWARE\Intel\LANDesk\VirusProtect6\CurrentVersion\Accounts (more details here)and then b) run the iforgot.exe program in the Program Files\Symantec\Symantec System Center\Tools folderthen you can

Setting wss 3.0 site anonymous access

2009-08-16T22:42:00.005Z

A couple of years ago I setup a secure WSS 3 web application which I now wanted to publish so that everyone (anonymous) could see it, however I couldnt find out how to do it.Following the Microsoft guidance article it suggests Site Actions -> Users and Permissions -> Advanced Permisions -> Settings and then click on Anonymous access, however the option just wasnt there !Further investigation

Updating Windows 2008 Domain Account Policies

2009-08-10T16:30:00.004Z

Whilst passwords meeting complexity requirements is all well and good in a production environment it is a pain in a development one. I have a Windows 2008 standard AD Domain Controller and and I needed a number of system accounts which I really didnt want to have to bother of recording complex passwords. To change these settings is not intuative, however this is what I found: To turn password

C#3 anonymous types, parameters and LINQ for XML

2009-07-28T08:22:00.005Z

Crash learning to work with LINQ XML (see sample code below to get a distinct list from an XML file written by a reporting services report) re-introduced me to a really usefull feature of C#3 called anonymous types where you can create an object on the fly. You can then use that object in the same method, however if you wish to pass it to another method then things start getting complicated. This

Integrating External Document Repositories with SharePoint Server 2007

2009-07-13T09:49:00.001Z

Whilist loading documents into Sharepoint from existing file shares is a good option it is often time consuming and here is an interesting article showing how you can link existing exteral document libraries with sharepoint Integrating External Document Repositories with SharePoint Server 2007:

Saving Reports to SharePoint using WebDav from Windows 2008

2009-07-13T09:18:00.001Z

I was having difficulty getting Enterprise Reporting Services to run a data subscription (running on Windows 2008) to save reports into a Sharepoint Document library using a URL.I found that Windows 2008 does not install the required WebDav Client (Not to be confused with the additional IIS7 WebDav Server addon) .You can install this client by Adding the "Desktop Experience Feature" on Windows

Chaks' Corner | WCF and Sharepoint - System.IO.FileNotFound Exception

2009-04-10T17:10:00.001Z

Writing a WCF Sharepoint handler I had a great deal of trouble wondering why SPSite host = new SPSite(http://localhost..../) was giving a Web application could not be found error. The URL opened fine in a browser.The answer appears to be security related where the WCF service doesnt seem to have enough permission to get to the local sharepoint server. One workaround which seems to work is to set

How to fix issue with Symantec Endpoint client not installing due to a required reboot. | Shnake's Tech Tips

2009-03-02T17:01:00.000Z

I needed to remove my old Symantec AV and install Symantex Endpoint Protection, however the installer kept saying there it would not install due to pending reboot actions - even after four reboots !My thanks to the following link who shows the relevant registry to sort this problem out.How to fix issue with Symantec Endpoint client not installing due to a required reboot. Shnake's Tech Tips:

SharePoint Documents in "Checked Out" limbo mode after upload from explorer with mandatory fields not completed

2009-02-26T17:14:00.001Z

We have been uploading documents into SharePoint from the file system by dragging and droping them from Explorer, and we could'nt work out why they were being shown as "Checked Out" even though the Version Control settings were set to not use "Check-in/Out".The reason turns out to be related to mandatory fields being by passed by the Explorer upload method. If you load a document via the filing

Binding Excel 2007 values using (DIP) Server Document Properties to Sharepoint- Not Simple or Intuitive

2009-02-26T12:37:00.004Z

We had a requirement to link values entered in Excel 2007 cells so that when they were saved to a Sharepoint Document library those values were seemlessly displayed Document library as fields.This functionality is handled much more easily by Word 2007 - see these excellent articles (DIP Metadata and Word 2007 Custom Doc Properties) - but Excel 2007 doesnt seem to share this functionality out of

Sharepoint Permission levels and permissions

2009-02-04T23:10:00.001Z

Ive been working on setting Sharepoint permissions programmatically at a document level and found an interesting article below:One of the things we noticed last week was that if you set the permissions on a single folder or document for someone who is not already in the document library, sharepoint adds them to the document library permissions root with [Limited Access].The full article is here

Referencing Sharepoint Assemblies on x64bit Installs causes build errors for ASP.NET apps (in VS.NET 2008)

2009-02-04T23:03:00.000Z

Debugging a WCF application on a 64 bit server using VS2008 gave me odd errors where sharepoint.security.dll could not be loaded - it turned out that you have to use the 32bit version of the microsoft.sharepoint.xxx.dll libraries - see the following article. robgruen's WebLog : Referencing Sharepoint Assemblies on x64bit Installs causes build errors for ASP.NET apps (in VS.NET 2008):

Oulook 2007 and Sharepoint document libraries sync.

2008-06-24T11:54:00.005Z

This subject is poorly documented and a bit of a "black art", however Ive found a Microsoft quick ref card here.Note Outlook behaves differently if the library is greater than 500Mb. If less then it sync everything, otherwise it syncs only headers and you have to manually sync documents. I cant find any way to alter this functionality.I also find some interesting training slides from TechNev on

64 bit pdf and onenote printing problems

2008-05-10T06:08:00.002Z

Whilst MS is pushing 64 bit for everything, using 64bit Vista on my HP laptop continues to be a frustrating experience.I had deadline and needed to print from MS Project to PDF. Even though I have a professional version of Acrobat 8, I cannot seem to print to PDF and the machine even locks and crashes Project. As a workaround I tried printing to OneNote, but again you cant seem to do this on a 64

64bit Print PDF troubles

2008-05-10T05:58:00.000Z

Free PDF Creator - Convert to PDF from Any File You Can Print - PrimoPDF

Excel -- Comments -- Programming

2008-03-28T12:08:00.000Z

I needed to extract addresses from a comments field in an Excel spreadsheet. The following had some really helpful code to manipulate the comments:Excel -- Comments -- Programming

No more /console switch in RDC 6.1

2008-03-06T11:39:00.000Z

Remote Desktop Console "/console" connection switch has been disabled in Vista SP1 and Windows 2008. It has been replaced by "/admin". This is a huge problem for server administration if you didnt know about it!It looks like it will be implimented in XP sp3 as well.The following article shows more detail Ask the Performance Team : MSTSC.EXE - no more /console switch in RDC 6.1

TimeSnapper - make timesheets a snap

2008-03-06T10:33:00.000Z

An interesting screen shot utility for use when you need to remeber what it was you did !TimeSnapper - make timesheets a snap

SharePoint 2007 Post SP1 hotfix woes

2008-03-06T09:06:00.002Z

We have a 6 server SharePoint 2007 Enterprise Farm which we were having a number of memory errors and timer errors on. We had hoped that SP1 would address these issues, however the timer errors and other problems are still arrising.A MOSS Post SP1 HotFix was made available on Feb 25th and we tried to install it today, but as with most things it didnt go according to plan.There are no

Crawling SharePoint sites using the SPS3 protocol handler

2008-02-27T21:33:00.000Z

When setting up MOSS Index crawls I noticed an odd prefix of SPS3:// and the following article explains why it should be used for index crawling to improve performance, especially over the WAN: Jose Barreto's Blog : Crawling SharePoint sites using the SPS3 protocol handler

Microsoft SharePoint Products and Technologies Team Blog : SharePoint SDK Downloads Now Live with SP1 Updates

2008-02-27T21:14:00.000Z

After wetting our appetite with MOSS SP1 at last 1.3 MOSS is here. (Note the new intellisense xml file)Microsoft SharePoint Products and Technologies Team Blog : SharePoint SDK Downloads Now Live with SP1 Updates

Indexing PDF content in MOSS Sharepoint 2007

2008-02-27T11:23:00.000Z

Out of the box, MOSS only indexes the meta data of a PDF and not the Text inside it if it is available. To index the full content you need an iFilter which is explained well here Steven Van de Craen's Blog.We have used Foxit's ifilter as it has an x64 version which our MOSS servers are running on.After getting this installed I was still having trouble with some files not indexing and found that

VS2008 includes shiny new images to use in our apps

2008-02-21T21:27:00.001Z

I was looking for some button images in VS2008 and found this usefull blog:DevLife - .NET General - VS2008 includes shiny new images to use in our apps

SharePoint Surveys - Finding the Results in the Database « Jack of all that is Microsoft, Master of None

2008-01-18T22:03:00.000Z

Creating a sharepoint survey is easy, however getting sensible data from it to analyse the results is not. This article shows how you can get to the database behind the scenes.SharePoint Surveys - Finding the Results in the Database « Jack of all that is Microsoft, Master of None

VMWare ESX 3.5 crash introduction - in at the deep end!

2008-01-13T19:48:00.000Z

As a developer and for systems testing I have used VMWare workstation and VMWare Server for some time, however Ive felt that I needed to get to grips with ESX server to really take advantage of virtualisation. It should be pretty similar to VMWare Server shouldn't it - errm well no...Firstly you can download a 60 day eval of ESX 3.5 server and other components from VMWare. This gives you a chance

Vista shortcut to Network Connections

2008-01-12T20:02:00.000Z

After a few months I'm warming to Windows Vista, however I use VPN network connections quite a lot as well as updating network settings. This is one area where Vista has made things much more complex than XP. However thanks to TweakVista you can create a shortcut to the old XP interface in Vista - Hurrah!Create a shortcut containing "explorer.exe ::{7007ACC7-3202-11D1-AAD2-00805FC1270E}"Full

Microsoft SharePoint Server2007 , Security Explorer, ScriptLogic

2007-12-11T21:05:00.000Z

Managing security for a large and complex MOSS installation with over 1000 users can be a large manual job. We are looking at ways of automating this process to assign individuals from AD rather than groups. This will mean that we can use the permissions to see which users have access to what, however the overhead of maintaining this is large. This is an internesting program which may be of

Exposing Excel contents to make reporting easy in SharePoint

2007-12-10T17:19:00.000Z

Some time adding Excel forms to a Sharepoint document library makes more sense than a complexly designed infopath form. This is especially the case when the form has a lot of financial computations. The problem is how to get the values in the Excel documents back to sharepoint so that they can be used in the document list views. This article gives an example of how to do it Exposing Excel

Microsoft Outlook Utilities and Add-ons - TechHit.com

2007-12-10T08:25:00.000Z

I was looking for a utility to store some reference email folders into the file system (or ultimatly Sharepoint) and I came across this interesting site.Microsoft Outlook Utilities and Add-ons - TechHit.com

MOSS Mysite blog multiple categories

2007-11-16T12:14:00.001Z

The default Blog template for a mysite will create a category field that only allows one category to be created. If you want to allow multiple categories you must alter this fields properties as per the imgage.

Rouge TCPIP gateway settings - Netsh commands for Interface IP

2007-11-13T08:51:00.000Z

I have a problem with the TCPIP settings on a windows 2003 workstation running windows terminal services.It is showing 2 gateways on network details or under ipconfig, however only one gateway is defined in the networking setup. Ive used Netsh to try to remove the additional gateway and although this is a powerful command it didnt see it.So I deliberately added the rouge gateway address with a

Sharepoint Navigation Editing Problem - The page has been modified by another author - MSDN Forums

2007-11-12T17:18:00.000Z

Navigation Editing Problem - The page has been modified by another author - MSDN Forums: "Navigation Editing Problem - The page has been modified by another author "This is a really frustrating problem where you try to edit a navigation structure and MOSS just errors. The attached link has a work around and hopefully it will be fixed in MOSS SP1

The Green Button - DVD Library Manager for Vista Media Center v0.1

2007-11-10T16:59:00.000Z

The Green Button - DVD Library Manager for Vista Media Center v0.1

MDX: Why it will matter to application developers | Reg Developer

2007-10-22T14:05:00.000Z

MDX: Why it will matter to application developers Reg Developer

TopStyle for Windows - HTML, xHTML, CSS editing in a single program

2007-10-03T18:08:00.000Z

Recommended CSS editorTopStyle for Windows - HTML, xHTML, CSS editing in a single program

You experience installation errors and compatibility problems when you install Windows Server 2003 management tools on a Windows Vista-based computer

2007-09-28T14:12:00.000Z

You experience installation errors and compatibility problems when you install Windows Server 2003 management tools on a Windows Vista-based computer:

An update is available that improves the performance and reliability of Windows Vista

2007-09-28T12:05:00.000Z

An update is available that improves the performance and reliability of Windows Vista

Tim Sneath : Windows Vista Secret #10: Open an Elevated Command Prompt in Six Keystrokes

2007-09-27T08:01:00.000Z

A very usefull tip for running elevated command prompts in VistaTim Sneath : Windows Vista Secret #10: Open an Elevated Command Prompt in Six Keystrokes: "Windows Vista Secret #10: Open an Elevated Command Prompt in Six Keystrokes User Account Control is, as I mentioned in secret #4, an important part of the security protection that Windows Vista offers. For any user with administrative

Forms Base Authentication Tools and Utils for SharePoint 2007 - Home

2007-09-24T13:38:00.000Z

Forms Base Authentication Tools and Utils for SharePoint 2007 - Home: "Forms Base Authentication Tools and Utils for SharePoint 2007 "

ISA VPN connection issues with packet size overflow fix

2007-09-24T10:39:00.000Z

How to force Kerberos to use TCP instead of UDP in Windows Server 2003, in Windows XP, and in Windows 2000: "How to force Kerberos to use TCP instead of UDP in Windows Server 2003, in Windows XP, and in Windows 2000"

ISA woes with Windows 2003 SP2

2007-09-21T21:36:00.000Z

Ive been having intermittent network connectivity server issues in a number of locations since Windows 2003 SP2 was installed. Specifically on ISA2004 and ISA2006 servers. It took me some time to realise that the issue was caused by Win2K3SP2, however I seem to be in good company as this service pack has caused huge problems.Specifically the problems I'd seeing are intermittent VPN Client error

VistaBootPRO - Go PRO with Microsoft Windows Vista Boot Manager

2007-09-19T14:43:00.000Z

VistaBootPRO - Go PRO with Microsoft Windows Vista Boot Manager: "Chances are you're here because you're running Windows Vista and want to do one of two things. Install a second OS or manage your boot configuration without directly editing the BCDEdit file. As you likely now realize, Windows Vista has made this task somewhat complicated for most users. VistaBootPRO was developed to make changes