- 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 - What's New in Operations Manager Since R2
Tech. reference and notes discovered whilst thrashing Microsoft SharePoint, SQL, BI, KM, Security and Windows Servers
Wednesday, November 10, 2010
MyTechEd 2010 Wednesday Sessions
MyTechEd 2010 Tuesday sessions
- 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
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 7 that it skews the rest.
http://www.msteched.com/2010/Europe
Sunday, September 12, 2010
Rename a domain controller using Netdom: Active Directory
Create an additional new name for the server
Tuesday, July 20, 2010
Windows Server, IIS/SharePoint, and NULL SID ‘Audit Failure’ Security Errors
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.
Windows Server, IIS/SharePoint, and NULL SID ‘Audit Failure’ Security Errors
Thursday, June 10, 2010
Viewing SharePoint 2010 sites on Windows Server 2008 R2
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:
a) a SPN for each Web Application URL
This consists of using the http url of the Web Application and adding it to the Service Principle Name (SPN) of the AD account that the Web application pool runs as. eg. with a Web Application called http://home.company.com which runs in an IIS AppPool called MySPSites that runs under the security account of mydomain\SPServices.
SETSPN.exe -S HTTP/home.company.com mydomain\SPServices
- (make sure you use an administrative CMD window)
- (this may take a little while on a large AD as it first checks for any duplicate SPNs and if it doesnt find one then adds it to the account).
You can do this either on intially setting up the Web Application with Kerberos,or if you need to use different IIS Authentication types for your Default Zone Web App then, after you have created it, extend it using either a different URL or port number. You can choose a different security Zone when you extend the Web App, or, unlike SharePoint 2007, you can change the IIS Authentication Settings at any time from the Sharepoint Admin console via -> Central Administration->Security->Specify Authentication Provider.
Wednesday, June 09, 2010
SharePoint Technology Conference | October 20-22, 2010 | Boston
SharePoint Technology Conference October 20-22, 2010 Boston
Access Web Services : form filtering and sorting
Friday, June 04, 2010
Access Web Services : filtered field lookup lists
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 a query for the lookup so this would solve the problem. BUT NO you cant use queries for table field lookups using Access Web Services ! As with most Microsoft technologies its two steps forward one back - why do they do this!?! However I have found a workaround which uses forms to filter the lookup and the detail is at the end of this article.
Firstly
if you create a new field and follow the diagrams below you see that lookups from queries are greyed out (why Microsoft !?!). Worse than that, for a new table , you will not see any of the existing tables either. To see the existing tables first save your new table and then fully Sync it to SharePoint. Only then will you get a full list of the tables you can use for lookups.
Lookup query workaround
Firstly create a form which includes the lookup field you have defined. As expected you will see that it returns all values from the table. Then make sure your in "Layout View" and highlight the field and bring up the property sheet. In the properties you will see a value for row source and its SQL !! If you update this by either carefully updating the text or using the query editor (much safer) you can put your "where clauses" into this query. And bingo it works on both the local access and on SharePoint. Hurrrah!
Tuesday, June 01, 2010
SharePoint 2010 : State Service issues & problems
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 to use Infopath or Reports in Access Web Services we started getting some odd errors such as:
The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service.
And
This report failed to load because session state is not turned on.
This was happening on both the production and development servers which was most odd.
Looking in SharePoint service applications there was no reference to the "State Service" on one of the servers and one line item for "State Service" on the other. Also most odd as both servers had been setup in the same way.
There is no way to create the State service from the new service application menu as it should have been setup from the SharePoint install, so you either have to use the Configuration wizard or PowerShell.
In the case of there not being any reference to a State Service I ran a powershell command to create a state service database and then ran the Configuration Wizard with everything possible unchecked apart from the State Service. The powershell command to create the database is "
New-SPStateServiceDatabase" See TechNet for more details
After an IISReset the errors seemed to clear and all was well with one of the servers.
For the other server the same process wasn't an option as the Configuration Wizard already had the State Service Checked. So using Powershell I manually created a State Service Application and State Service Proxy and enabled it all using the commands
New-SPStateServiceApplication
New-SPStateServiceDatabase
New-SPStateServiceApplicationProxy
and
Enable-SPSessionStateService
(See http://technet.microsoft.com/en-us/library/ee890113.aspx)
However after doing all of this successfully and being able to see the State Application and Proxy in the SharePoint Central administration list of service applications the error s still persisted. So using the SharePoint service application screen I deleted the first State Service and the new State Service Proxy and State Service which I had created. This allowed me to run the configuration wizard with only the State Service tick box checked and after another iisreset voila !
Others have also seen this issue - see
Misconfiguration of the MOSS State Service
Pasted from <http://social.msdn.microsoft.com/Forums/en/sharepointworkflow/thread/521db715-0d76-49ce-be36-7c37cfb8026f>
Monday, May 31, 2010
Access 2010 Web database conversion
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 Compliant tables. It would appear that linked tables to sharepoint are not compatible. As ever with Microsoft so near and year so far from a complete solution....
Here is a very good article about converting your access databse "Converting Access Databases to Access Web Databases (25th May 2010)"
Friday, May 28, 2010
IE Automation & Tabs - Tony Schreiner's Blog - Site Home - MSDN Blogs
IE7 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 Scripting Host.
First, create a 'lanuchie.js' file using your favorite text editor, add the following, and save:
var navOpenInBackgroundTab = 0x1000;
var oIE = new ActiveXObject('InternetExplorer.Application');
oIE.Navigate2('http://blogs.msdn.com');
oIE.Navigate2('http://blogs.msdn.com/tonyschr', navOpenInBackgroundTab);
oIE.Navigate2('http://blogs.msdn.com/oldnewthing', navOpenInBackgroundTab);
oIE.Navigate2('http://blogs.msdn.com/ericlippert', navOpenInBackgroundTab);
oIE.Visible = true;
Now from the command line you can do:
wscript.exe launchie.js
to open IE, navigate the first tab, and then open three background tabs.
One caveat: due to some IE features such as Protected Mode you will sometimes observe that the links are opened in an existing IE window."
Thursday, May 27, 2010
Firebox x10 user count exceeded error
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 firewall to access the external interface. The error message most un-helpfully calls these IP Addresses "users".
So where you have upgraded a number of machines, changed the IP addresses, and the odd printer has chatted to the internet all these old IP addresses are stored on the Firebox. These then block any new ones for new devices and have to be manually removed.
To do this open the Firebox System Manager ->Authentication Tab->IP Address button
This will give all the addresses that the Firebox has remembered for you as having access to the external interface.
Either clear them all to start a new list or remove the ones you don't want!
This link eventually told me what I needed to know.
Sunday, May 23, 2010
How to remove the “title” column from a SharePoint list | EndUserSharePoint.com
How to remove the “title” column from a SharePoint list EndUserSharePoint.com:
Friday, May 21, 2010
Configuring Business Data Connectivity Services
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 ->Manage service applications –> Choose the BDC /BCS Service -> Click manage from the toolbar->Configure->Type in the URL of the site collection you created above. ie http://metadata.company.com/sites/ExternalContentTypesFinally assign administrators of the BDC Metadata Store by clicking on the Set MetaData Store Permissions.
To create external connections see this article
Multiple Authentication Methods in SharePoint 2010
while (alive) { writeCode(); } : Multiple Authentication Methods in SharePoint 2010:
Thursday, May 20, 2010
Setup Managed Meta Data Hub for the Sharepoint 2010 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 features" from the tool bar.always use NTLM to start with to test work and can switch after
Create a new site collection with a template of "Publishing ->publishing Portal"
Create the service application
Create a new "Service Application" from Central Admin->Application Managment->Service Applications->Manage Service applications
Click on the new button on the toolbar and choose "Managed Metadata Service"
Enter the name, SQL server and DB name.
You can either use the IIS Web application pool you created when you setup the web application and site above or create a new one with yet another new user account which has been added to the managed users
For the Content Type Hub use the URL of the site collection you setup above and then click ok.Note: this will not start the Managed Metadata service, and you may see errors in the event log saying that this service is not running on any of the servers in your farm. You need to start the serice seperatly.
You start the service by Central Admin->System Settings->Servers->Manage services on server
Click start next to Managed Metadata Web Service
-------------
To check it is working and to manage the content goto Central Admin->Application Management-> Service Applications->manage Service Applications
You will see two entries for the Service, the first is the actual service and the second indented line is a proxy stub.
Click on the first line and choose Manage from the toolbar. This will bring you up the Term Store Mangement Tool where you can manually input Terms or import them using a CSV
Note: you may find errors if you do this straight away as certain timer services need to run to fully impliment this service. Gernerally I would always do an IISReset as well (well it cant hurt!)
Article for next steps setting up content types
SharePoint 2010 Connection Filter Logic
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 your Sychronization Connection to include one or more OUs from AD, you can then add exclusion rules by clicking to the right of the Syncronization Connection and choosing Edit Connection Filters from the menu.
I didn't read the screen properly and just applied the same filter logic as SharePoint 2007 but after 4 hours of pain not getting the results I wanted, so I read what it said on the screen.
It says "Exclusion Filter for Users" - as such YOU MUST REVERSE YOUR LOGIC from SP2007!!
Thus to achieve the same result above you need:
ie User filter: (Status:=System)(UserAccountControl:Bit On:=2))
I'll read the screen next time - duh!
The importance of SharePoint 2010 Managed Service Application install order
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 User Profile and User Sync Service Application. However after a good install with few errors, on editing a user's profile some of the fields had really odd errors saying that "There was a problem retrieving data for this field"
There was nothing obvious; however it turns out that if you don't install the Managed Meta Data Service then you will have this problem. It doesn't matter if you install the MMD before are after the UPA but it just needs to be there.
The order I attempted to install Services after the binary and install of the administration site is as follows:
- Register some pre-configured AD accounts into SharePoints' Managed Accounts (having setup the right AD permissions first). These will be used for the IIS Application Pools so you know what is running what. SharePoint very unhelpfully gives these GUIDS as names.
- Create a New Web Application for the MySite Profiles with its own application pool and use one of the Managed Users we setup above
Create New Site collection in that Web Application – using a template of Enterprise –> My Site Host(Don't try to load site at this time)
Create a new User Profile Service Application with its own app pool- Start the UPA service – (very easy to miss this)
- After service has started do an IIS Reset – or even reboot to make sure
- Start the User Profile Sync service – prompts for details – wait 10 minutes until started
- Reboot again – very important.
- Add a Synchronization Connection to AD (You can add LDAP Filters to the connection after it is setup)
- Start profile Synchronisation (full)
- Once complete (and it will take a while…..) Manage User Profiles and you will see on some of the fields the errors I mentioned above.
- Now install the Managed MetaData Service
- IISReset or reboot again – and these field errors disappear!!
Glad it's so intuitive……..!
References :
Spencer Harbar's Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization
SharePoint 2010 – Provisioning User Profile Synchronization
MSDN: Edit Profile Synchronization connection filters
http://blogs.msdn.com/brporter/archive/2010/02/20/excluding-disabled-user-accounts-in-sharepoint-2010.aspx
http://www.wictorwilen.se/Post/SharePoint-2010-user-profile-properties-temporarily-disabled.aspx
Monday, May 17, 2010
Visual Studio error 'Cannot find the certificate and private key for decryption'
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 export it without all this extra "stuff".
The solution is to run CertMgr.msc - import your certificate - (usually into Personal->Certificates) and then:
export it by right clicking on the certificate you just imported ->All Tasks ->Export->Yes Export Private Key->
(Do not include any Personal Information Exchange check boxes)
Type a password and export it to a folder (preferably in your VS Project)
Now, in Visual Studio->Signing->Strong Name Key File-> try and browse to your new key and it should load after you enter the password.
Tuesday, May 11, 2010
Sharepoint 2010 BCS connection getting started and authentication issues
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, and if it is not you will get a Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' error.
With SP2010 it is much better to use either the Impersonate Windows (or Custom) Identity - which makes use of the SharePoint 2010 Secure Store Service.
If however you dont want to use these or havnt set them up then you can use RevertToSelf which uses the BCS's application pool credentials.
Microsoft warn against this method as a potential security risk and if you try to select it as a connection property it will give you an error saying that revert has to be enabled for the application pool. (See this link)
This is done by setting RevertToSelfAllowed for the BCS model's authentication mode wont work without using powershell to set the Sharepoint Server setting for this to True.
$apps = Get-SPServiceApplication
$bcs = Get-SPServiceApplication where {$_ -match "
## If you’re doing this by hand, just type $apps and look #for the Business Data one, then index into it like $apps[i].#If you’re doing it for automation, filter by #$_.GetType.FullName (not $_.TypeName, which is localized).
$bcs.RevertToSelfAllowed = $true
Remember that if you do use this method then the BCS's application pool credentials must have the appropriate rights to the SQL Server Table.
References:
Authenticating to Your External System - BCS Team blog
BCS and External List Learning – Part1
BCS and External List Learning – Part2
Getting started with Business Connectivity Services (BCS) in SharePoint 2010
Sunday, May 09, 2010
SharePoint 2010 and Project 2010 Server demo and Eval VM (RTM edition)
Chris Johnson : SharePoint 2010 Demo and Eval VM (RTM edition): "SharePoint 2010 Demo and Eval VM (RTM edition)"
Friday, March 26, 2010
Running VMware vSphere Client on Windows 7
BUT here is a very good simple arcticle which works ! - we like this a lot...
Wednesday, March 24, 2010
Sharepoint 2007 wildcard searching
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 here
http://www.novolocus.com/2009/05/27/sharepoint-can-have-wildcard-searching/
Thursday, February 25, 2010
dotNet Dictionary - ContainsKey
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 found the Catch block would return a default value.
This was both stressfull to me and the performance of the app, so I was very pleased when I found a method to test if a key existed: Dictionary<(Of <(TKey, TValue>)>)..::.ContainsKey Method
BUT I was even happier when I found the Dictionary<(Of <(TKey, TValue>)>)..::.TryGetValue Method
TryGetValue means you dont need to wrap your code in Try Catch blocks to handle exceptions and you can pass back a default value if the key is not found. Brilliant !
A couple of Excel VBA usefull notes
Domain = Environ("UserDomain")
Combined= Environ("UserDomain") & "\" & Environ("Username")
CurrentDate = Date
CurrentTime = Time
Some file and folder VBA commands
Current folder name: CurDir
Change 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 Workbook.xls"
Creates a new folder: MkDir "F:\My Documents\NewPrivateFolder"
Delete a folder: RmDir
Copy a file (the file must be closed): FileCopy "OrgWorkBook.xls", "CopyWorkBook.xls"
How to move a file (the file must be closed):
OldFilePath = "C:\OldFolder\Filename.xls" ' original file location
NewFilePath = "C:\NewFolder\Filename.xls" ' new file location
Name OldFilePath As NewFilePath ' move the file
My thanks to this reference - allbeit a little hard to read beacause of the ad's
February 2010 Windows Media Center Cumulative Update for Windows 7
Sharepoint list item - custom drop down menu
(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 Javascript and have a knowledge of the internal variable names Sharepoint 2007 users. [at least Sharepoint 2010 will have a client side dll!).
Other references I found usefull were :
- MSDN - Sharepoint Client side API - OpenDocuments Control
- Changing the context menu of a document library in Microsoft SharePoint Portal Server 2003 or Windows SharePoint Services
- “Send Document Link By Mail” menu item to document libraries
- How to open SharePoint documents in Edit mode with Internet Explorer 6 and Windows XP (without regfix
Wednesday, January 27, 2010
BUG: SSIS 2008 derived columns from User variables data type
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 Coulmn Transformation Editor and add a Derived Column as
So if you update the user:variable string to a length of 5 characters SSIS fails!
My work around is to make sure that you initialise the user:variable string with a value which has a length of the maximum possible string which you are likely to encouter.
Hopefully this will be resolved in future releases.
Tuesday, January 26, 2010
Another Microsoft SQL exam passed
Summing Excel Range Intersects
I had a couple of Ranges as rowns,
eg Dept1 = Rows A1:N4 , Dept2 = Rows (A5:N6, A12:N16) etc
and 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 about the comma as a Union operator not many people have heard of space as an Intersect operator - see "Reference operators" in Excel help for more info
Tuesday, January 19, 2010
Using Windows 7 for "Server-like" loads
However after about a 15Gb backup from SQL 2005 server onto a Windows 7 share, the Windows 7 workstation seemed to loose its visibility from any of the Windows 2003 servers. (The other Windows 7 machines could still see the share).
A reboot solved the issue, until I tried to backup again!
Looking in the event log, I found memory errors showing as Non-Paged pool problems.
After a lot of searching, I came across the article below - it would appear that from the old SysInternals Site there used to be an article called "Tunining Workstations for Server-Like Loads". Microsoft seem to have "tidied up" these old articles and I couldnt find any links to the references shown on Technet, however if you make the registry changes to a Windows 7 machine, it seems a lot happier pretending to be a backup file server overnight.
Set the following registry to key to 1
HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache
and set the following registry key to ‘3′:
HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\Size
References:
http://alan.lamielle.net/2009/09/03/windows-7-nonpaged-pool-srv-error-2017
Event ID 2017 and 2021 - microsoft.public.windows.vista.networking_sharing Google Groups
Tuesday, January 12, 2010
ICO (Windows Icon) file format plugin for Photoshop
ICO (Windows Icon) file format plugin for Photoshop
Tuesday, December 15, 2009
Configuring User Profiles in Sharepoint 2010 beta 2 in the enterprise
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.
Wednesday, October 14, 2009
Running SSIS packages from a web page
The following C# class in an asp.net page runs brilliantly on the SQL 2008 server
static void CallSSIS()
{
string pkgLocation = @"E:\VS Projects\\Sandbox.dtsx";
Application ssisApp = new Application();
Package ssisPackage = ssisApp.LoadPackage(pkgLocation, null);
DTSExecResult ssisPackageResults = ssisPackage.Execute();
}
The only major problem I had was publishing the web to a virgin Windows 2008 with IIS7 machine. When I browsed to the page it gave the following error "This configuration section cannot be used at this path".
After hours of head scratching and missleading web articles, it turned out that the ASP.NET is not installed as a ROLE in by default.
Server Manager -> Roles -> (scroll to Web Server (IIS)) -> Add Role Services -> ASP.NET
Volia!
Monday, October 12, 2009
Symantec System Center - Cant unlock server group
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 folder
then you can reset the user account's password.
Sunday, August 16, 2009
Setting wss 3.0 site anonymous access
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 reminded me I needed to make sure that my "authentication providers" needs to be set to support anonymous as otherwise its not an option to choose in menu above. To set this up go to Web Application Management -> Application Security -> Authentication Provider, choose the Zone you wish to edit and then make sure "enable anonymous access" is checked and save this setting.
Now go back to the first stage on the Advanced Permissions -> Settings drop down and voila, you can set anonymous for site, list level or none as you require.
Monday, August 10, 2009
Updating Windows 2008 Domain Account Policies
To change these settings is not intuative, however this is what I found:
To turn password complexity off in Windows 2008 Server or change other grayed out security options, follow these steps:(1) Run gpmc.msc (Group Policy Management)
(2) Expand your Domain
(3) Go to Group and select Default
(4) Right click on Default Domain Policy or Default Domain Controllers Policy and choose Edit
(5) In the new window which opens expand computer Configuration->policies->windows settings->security settings->account policies->password policies
(6) Make your edits to the keys below:
There must be an easier way, which I am problaby missing !
Tuesday, July 28, 2009
C#3 anonymous types, parameters and LINQ for XML
(He also mentions a very good book on C#3 (by Bill Wagner) to hone your skills)
Note: as a learning LINQ is a lot of trial and error you can test your LINQ code in a very helpful utility called:http://www.linqpad.net/
Sample LINQ code
XDocument xDoc = XDocument.Load(@"c:\temp\RSD.xml");
var q = (from e1 in xDoc.Descendants("{SchemaName}Detail").Distinct()
let div = e1.Attribute("Division").Value
let cc = e1.Attribute("CostCode").Value
select new { div, cc }).Distinct();
q.Dump(); //this shows you the contents of q
Monday, July 13, 2009
Integrating External Document Repositories with SharePoint Server 2007
Saving Reports to SharePoint using WebDav from Windows 2008
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 2008, however this also installs lots of other things that you probably dont want and Ive not found a way to only install WebDav Client support.
After a server re-boot it works well and talks to Sharepoint Document Libraries, My thanks to the following article for assistance. Browsing SharePoint using WebDav from Windows 2008 « In The Mix
Friday, April 10, 2009
Chaks' Corner | WCF and Sharepoint - System.IO.FileNotFound Exception
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 the WCF Application Pool permissions to the same as the Sharepoint Application Pools. Im not sure its elegant but until I find a better way this seems to work. Thanks to the following blog: Chaks' Corner WCF and Sharepoint - System.IO.FileNotFound Exception
Monday, March 02, 2009
How to fix issue with Symantec Endpoint client not installing due to a required reboot. | Shnake's Tech Tips
My thanks to the following link who shows the relevant registry to sort this problem out.
Thursday, February 26, 2009
SharePoint Documents in "Checked Out" limbo mode after upload from explorer with mandatory fields not completed
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 system and a mandatory field is not completed then Sharepoint leaves the document in a “Checked Out” state. However you cannot “Discard the Checked Out” state because no document has been “Checked In” in the first place !
So you have the situation where a document is in limbo – not checked in or checked out but only visible for the user who loaded the document to complete the mandatory fields.
BUT even if you do complete these fields – it would seem that Sharepoint keeps the document in the limbo state and won’t allow you to do anything with them unless you fully check them in.
AND the problem is that SharePoint doesn’t have a “bulk check-in” function!
Reference: Automatically checkin files after uploading « SharePoint, ASP.NET and more
Binding Excel 2007 values using (DIP) Server Document Properties to Sharepoint- Not Simple or Intuitive
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 the box.
It turns out that there are 3 types of Metadata Properties in Excel 2007 (where WB is the ThisWorkbook object in this example):
- WB.BuiltinDocumentProperties
- WB.CustomDocumentProperties
- WB.ContentTypeProperties
To access this Mata data visually use the Excel "Office button" -> Prepaire -> Properties menu. Choosing "advanced properties" gives you access to both add new custom properties and the built in properties. You can assign fixed text values to them or link them to named ranges within the sheet, however you cannot get to the Server Document Properties from this dialog.
ie the XL-> Custom Properties GUI only gives you access to the following Property sets (and of course these aren't what you need for Sharepoint)
- WB.BuiltinDocumentPropertiesSet
- WB.CustomDocumentPropertiesSet
To update the data which will feed back to Sharepoint fields you need to use code to get to the WB.ContentTypeProperties object which has a type of "MetaProperties".
The WB.ContentTypeProperties object is a collection which can be iterated through and each field has an ID and Name and a Value. The ID is an internal value and seems to Map to the same internal name as that of the Sharepoint field it is connected to.
{Note: the internal field names can lead to some confusion such as where a field with a Name of "col1" seems to create an internal ID name of "_x0063_ol1" and a field with a Name of "Project Lead Finance" has an internal ID name of "Project_x0020_Lead_x0020_Finance". This is normal Sharepoint practice!}
Using macro code to set the values of a MetaProperty in this way seems to trigger an event in the Server Document Properties DIP (Document information Panel) to update the field value to the new value you've set. {Note: The DIP is an InfoPath based piece of XML which displays fields in Office 2007 applications. It may be possible to code against it to achieve a more automated link to native Excel custom properties but I haven't had a chance to look at that yet}
Below is a very simple piece of code to set a Server Document Property to the value of cell A1:
Sub SetServerProperties()
Dim WB As Workbook
Set WB = ThisWorkbook
For Each Prop In WB.ContentTypeProperties
If Prop.Name = "Project Lead Finance" Then
Prop.Value = Range("A1").Value
End If
Next Prop
End Sub
Using macro code has the disadvantage of Excel documents having to be saved as XLSM documents and I am sure there must be a way to trap an update event of an standard Excel Custom property using something like VSTO, however that is for another post.
{Note: for Excel 2003 just updating the fields in WB.CustomDocumentPropertiesSet before a save does seem to pass them back to Sharepoint ok}
My thanks to an article published by Sadalit Van Buren who pointed me in the right direction with this article A Matter Of Degree: XML Mapping of Document Properties with Excel and SharePoint - Not Simple or Intuitive
Wednesday, February 04, 2009
Sharepoint Permission levels and permissions
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 http://office.microsoft.com/en-us/sharepointtechnology/HA101001491033.aspx. , but in summary:
Limited Access
The Limited Access permission level is designed to be combined with fine-grained permissions to give users access to a specific list, document library, item, or document, without giving them access to the entire site. However, to access a list or library, for example, a user must have permission to open the parent Web site and read shared data such as the theme and navigation bars of the Web site. The Limited Access permission level cannot be customized or deleted.
Note You cannot assign this permission level to users or SharePoint groups. Instead, Windows SharePoint Services 3.0 automatically assigns this permission level to users and SharePoint groups when you grant them access to an object on your site that requires that they have access to a higher level object on which they do not have permissions. For example, if you grant users access to an item in a list and they do not have access to the list itself, Windows SharePoint Services 3.0 automatically grants them Limited Access on the list, and also the site, if needed.
Referencing Sharepoint Assemblies on x64bit Installs causes build errors for ASP.NET apps (in VS.NET 2008)
robgruen's WebLog : Referencing Sharepoint Assemblies on x64bit Installs causes build errors for ASP.NET apps (in VS.NET 2008):
Tuesday, June 24, 2008
Oulook 2007 and Sharepoint document libraries sync.
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 the subject.
Microsoft's office page for this subject is here
Saturday, May 10, 2008
64 bit pdf and onenote printing problems
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 bit machine. In the end I had to screenshot what I needed in OneNote and then creating the PDFs from that which is very annoying. These sort of issues along with my being unable to use Groove shared folders on 64bit workstation makes me feel that we are still a good way off from being able to adopt 64bit workstations for mainstream.
A few days after the deadline I found this product which seems to work well Free PDF Creator - Convert to PDF from Any File You Can Print - PrimoPDF
Friday, March 28, 2008
Excel -- Comments -- Programming
Excel -- Comments -- Programming
Thursday, March 06, 2008
No more /console switch in RDC 6.1
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
TimeSnapper - make timesheets a snap
SharePoint 2007 Post SP1 hotfix woes
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 pre-install instructions, however based on the SP1, you need to install the binaries on the Administration server first, then run the Sharepoint Products and Technologies Config Wizard, BUT only to the point it warns you to install the patch binaries on the other servers in the farm. Once you have installed the patch on all the other servers go back to the Administration server and click ok to continue with the Sharepoint Products and Technologies Config Wizard.
All was going well until step 8 which gives an upgrade error and refers you to a log file. There are no helpful messages and the only possible information is the following:
Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException
Has anyone else seen this issue ? and what is the resolution ?
Wednesday, February 27, 2008
Crawling SharePoint sites using the SPS3 protocol handler
Microsoft SharePoint Products and Technologies Team Blog : SharePoint SDK Downloads Now Live with SP1 Updates
Microsoft SharePoint Products and Technologies Team Blog : SharePoint SDK Downloads Now Live with SP1 Updates
Indexing PDF content in MOSS Sharepoint 2007
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 out of the box MOSS will only index 16Mb files. You can up this using a registry setting on the server - documented here. This works fine except you should be mindful of possible server index time out errors. Mindsharp say that you can increase the timeout value here, but I havnt managed to find this setting in MOSS enterprise yet.
(There is an interesting article on custom Sharepoint Searches here)
Thursday, February 21, 2008
VS2008 includes shiny new images to use in our apps
DevLife - .NET General - VS2008 includes shiny new images to use in our apps
Friday, January 18, 2008
SharePoint Surveys - Finding the Results in the Database « Jack of all that is Microsoft, Master of None
SharePoint Surveys - Finding the Results in the Database « Jack of all that is Microsoft, Master of None
Sunday, January 13, 2008
VMWare ESX 3.5 crash introduction - in at the deep end!
Firstly you can download a 60 day eval of ESX 3.5 server and other components from VMWare. This gives you a chance to learn but I didn't realise the curve would be quite so steep.
I created a boot disk, booted onto an 8Gb server taking most of the default options and I was impressed how fast it loaded. It asked me to enter a base IP address and gateway which I put it a standard 192.168.x.x address (I thought it would be easy to change after) and rebooted.
ESX booted fine, but just gave me a Linux prompt - no GUI, no friendly interface, just a command line. I haven't worked on Unix since University over 20 years ago so this was a shock.
The first thing you need to do is a connect a browser from another machine on the network and download the "VMWare Infrastructure Client". From here you can carry out quite a lot of admin.
BUT here was my first problem, I had made a mistake on the initial IP address configuration and couldn't find any way to change it to DHCP or anything else !
It turns out that to change an IP address on the ESX server is quite complex, needing to use the system console to deleting a configuration file, re-create it and then update the gateway using the vi text editor somewhere else! My thanks to Damian Murdoch for his article on how to do this. But although I followed this I couldn't find how to switch it to DHCP, so I bit the bullet and installed ESX server from scratch for a second time, this time choosing the DHCP option.
Now I could talk to the ESX server from the "VMWare Infrastructure Client", so I created a new "Resource Pool" and created a new "Virtual Machine" so I could build a Windows 2003 server.
I had a Windows 2003 ISO on my machine with the Infrastructure client but I could find any way of linking the new "Virtual Machines" CD drive to this ISO - except by using the "Connect to CD/DVD" button. This button only works once you start your new VM - so you have to be quick to click on it and connect it to your ISO whilst your VM is booting. Trouble is that the VM boots so fast that it ignores the CD boot and just tries a DHCP network boot and gives up.
Transferring files and ISO's to the ESX Server
I could have burnt a CD from the ISO and put it in the ESX physical server, but I was working remotely and so thought I'd just copy the ISO on the the ESX store and link the new Virtual machines CD to it.
Again a problem. If you are only running ESX Server you seem to need to access the ESX using a form FTP Server. I found a Free Utility called Veeam FastSCP 2.0 which seemed to answer my problem really well, so I loaded it up and tried to log in. As a rookie I tried to login as root but got an access denied error. Searching support forums told me that FastSCP would not login as root except if you check the elevate to root check box and enter the root password. Well this doesn't seem to work on ESX3.5 so I had to create a new user using the Infrastructure client. (You select the ESX Server Icon on the LHS and there is a Users and Groups tab).
Using this new user login, I could access the ESX file system and create Folders, however whenever I tried to copy and paste a file I received a timeout error. I tracked this down to a tightening of the ESX 3.5 firewall. FastSCP uses ports 2500, 2501... but these are now locked down in ESX 3.5. The option is to open the ports which FastSCP uses by using the ESX console command "esxcfg-firewall -o 2500,tcp,in,FastSCP", however you need to do this for 2501, 2502... etc An alternative is to open the firewall whilst copying the files using "esxcfg-firewall --allowIncoming" and then closing it aftewards using "esxcfg-firewall --blockIncoming" - source discussion on "Transfer timeouts" here.
This worked well and I could transfer my ISO file to the ESX store. One forum suggested transferring ISO's to the /vmimages folder, however this seems to be mounted under /dev/sda2 which only had 5Gb of space. If you right click on the properties of the connected server in FastSCP then it will list the devices with space. I ended up using /vmfs/volumes/xxxx.
Now having the Win2k3 iso on the ESX file store, I could edit the new Virtual Machine settings to point its CD to the ISO on the ESX store. (Remember to check the enable the CD device tick box as well as connecting it to the ISO).
Thus this is the story so far. I have a Windows server running on ESX after a weekend of head scratching and searching blogs and forums!
I know that the ESX platform is a very very powerful suite, but for beginners with simple requirement it seems rather tricky to get started!
Saturday, January 12, 2008
Vista shortcut to Network Connections
Create a shortcut containing "explorer.exe ::{7007ACC7-3202-11D1-AAD2-00805FC1270E}"
Full article source here : TweakVista.com - Create a direct shortcut to Network Connections
Tuesday, December 11, 2007
Microsoft SharePoint Server2007 , Security Explorer, ScriptLogic
Monday, December 10, 2007
Exposing Excel contents to make reporting easy in SharePoint
Microsoft Outlook Utilities and Add-ons - TechHit.com
Microsoft Outlook Utilities and Add-ons - TechHit.com
Friday, November 16, 2007
MOSS Mysite blog multiple categories
Tuesday, November 13, 2007
Rouge TCPIP gateway settings - Netsh commands for Interface IP
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 high network metric using netsh. This command worked but the metric was being ignored, (tested using tracert). Using netsh again I removed the gateway address I’d just added and it seemed to remove itself from the TCPIP configuration successfully. Using tracert to test the routing again it showed all was well. Has anyone else seen something like this ?
Microsoft Windows XP - Netsh commands for Interface IP
Monday, November 12, 2007
Sharepoint Navigation Editing Problem - The page has been modified by another author - MSDN Forums
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







