Patrick’s Bytes

Techie for the past 30 years…

TFS 2008 – Project deleted but SharePoint side failed to be deleted

Posted January 11th, 2010 . 1 Comment . Uncategorized Tags: , ,

I tried to use TFSDeleteProject command to remove the project from the TFS server,

tfsdeleteproject /server:myserver myprojectname

but at the end of the process there is this error message

Deleting from Build …
Done
Deleting from Work Item Tracking …
Done
Deleting from Version Control …
Done
Deleting Report Server files …
Done
Deleting SharePoint site …
Could not connect to ‘http://TFS08:17012/_vti_adm/admin.asmx’
The request failed with the error message:
–
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://tfs08:17012/_layouts/1033/error.aspx?ErrorTe
xt=Request%20timed%20out%2E">here</a>.</h2>
</body></html>

Then I tried to repeat the command again with the /force option (tfsdeleteproject /force /server:myserver myprojectname), I still get the error

Deleting from Build …
Done
Deleting from Work Item Tracking …
Done
Deleting from Version Control …
  Not found
Deleting Report Server files …
  Not found
Deleting SharePoint site …
Exception of type ‘Microsoft.SharePoint.SoapServer.SoapServerException’ was thro
wn.
Deleting from Team Foundation Core …
Done

But actually what happened is everything within TFS have been safely removed except the SharePoint, so you need to go into SQL Server Management Studio and connect to WSS_Config database

Select Id From Sitemap Where Path = ‘/Sites/myprojectname’

Grab the Id and execute this SQL

exec dbo.proc_dropSiteMap @Id=%Id%

After that you still need to clean up your WSS_Content database by executing this

exec proc_DeleteSite %Id%

But do note you might have nothing to delete in the WSS_Content

Presenting @Microsoft Malaysia’s the new Efficiency Launch

Posted November 24th, 2009 . 2 Comments . Uncategorized Tags: , ,

TNE_308x164

It was fun and happy to see so many people turned out for the business launch of Windows 7, Windows Server 2008 R2 and Exchange Server 2010. I presenting 2 session at the developer break out track session.

  1. Lights up Windows 7 (with Windows 7 API Code Pack) – Me and Walter Wong demoed features like the enhances taskbar, jump list, Multi Touch as well as Sensor API capabilities.
  2. Lap around ASP.NET 4.0 and Silverlight 3 – I ended the last session of the day with a preview on Silverlight 4.0 showing cool stuff like right click context menu, file drag and drop as well as the webcam capabilities.

It was the best audience I never had so far. Many thanks to you guys for making it so much fun!

As per promised you can download my slides here.

iw_header[1]

By the way, if you are a SharePoint developer or IT Pro, check out the coming SharePoint User Group’s Information Work Community Day for IT pro and dev here

Setting up SharePoint 2010 Beta 2 screenshots (Part 1)

Posted November 21st, 2009 . No Comments . Sharepoint Tags: ,

I managed to setup SharePoint 2010 Beta 2 on a Windows Server 2008 SP2 VM with SQL Server 2008 R2 Nov 09 CTP. SP2010 requires 64bit version of Windows Server and SQL Server . For the host I have an Intel C2Q machine on 4GB RAM running Windows Server 2008 R2 with Hyper-V installed.

For the VM environment, I have:

  1. AD Domain Controller on Windows Server 2008 SP2 Server Core
  2. Another VM running Windows Server 2008 SP2 enrolled in the AD domain. I have PowerShell feature (for SQL Server), IIS Web Server role and Application Server role (both for SharePoint) setup after I enrolled the VM in AD.

For part 1 of this, I will show how I setup SQL Server 2008 R2. Even though it’s in CTP, setting the database server is no brainer.

Below are my screenshots of the whole process. For detailed explanations, you can follow Microsoft UK MCS’s blog here.

image

This is the system properties of the VM. Note that I allocated 2.5Gb RAM for this VM.

image

Put in the SQL Server 2008 R2 DVD and it asked me to setup prerequisites i.e. .NET Framework 3.5 SP1 and an update to Windows Installer.

image

Prerequisites installer starting up

image

Accept the EULA for .NET Framework 3.5 SP1

image

.NET Framework installer running

image

.NET Framework 3.5 SP1 setup successfully.

image

SQL Server 2008 R2 installer will starts automatically.

image

Click on the Installation tab on the left. Then choose ‘New installation or add feature to an existing installation.’

image

Installer to inspect system and determine all setup rules passed.Click OK here

image

The SQL Server 2008 R2 setup files starting up. Following experience will be very similar to setting up SQL Server 2008. Hope it doesn’t change in the final release

image

Select that I want the Enterprise Edition

image

Accept the EULA

image

Setup files copying themselves

image

Setup support rules are scanned again. I ignore the warning on opening up the SQL Server port at the firewall.

image

This is new for R2, being not 100% sure, I choose the first logical option

image

Then select the SQL Server features I want. I chose:

  • Database engine with Full text search
  • Reporting Services
  • BI Development Studio (optional)
  • Management Tools – Complete

image

Installation rules are scanned to make sure all requirements fulfilled

image

Determined my SQL instance (in case you have more than 1 already installed)

image

Determine I have enough hard disk space

image

Now is the choose the user account(s) to be used for the services. I create a sqlservices account in my domain and I want all services to use the same account. So I clicked on ‘use the same account for all SQL Server services’

image

Keying in the account credential

image

Next screen I have to decide on the authentication mode and add myself as a SQL Server administrator.

image

I am doing nothing for Reporting services so it’s option 3 (Install, but do not configure the reporting server) for me.

image

I don’t want to send error reports back to Microsoft.

image

Final check on configuration rules

image

Review your installation options

image

Installation started

image

Success!

image

Starting up the SQL Server Management Studio, similar to SQL Server 2008

image

Still using VS2008 for BI Development Studio. Hope they will upgrade to VS2010 later as SP2010 will also be using VS2010

Next port I will show the installation process of SharePoint Server 2010

Flying to Kuching tomorrow, catch me at Dev In Town!

Posted June 25th, 2009 . No Comments . Uncategorized Tags:

image

If you are from Kuching (City of cats in Malay) or happen to be there, come and see me presenting SharePoint and SharePoint Designer 101 at Kuching Park Hotel. Event details are here.

SharePoint not your cup of tea? My fellow MVP Walter, Ming Man and Jabez will be there also presenting topics like LINQ, WPF and Windows 7.

Map to the venue (Jalan Padungan)

 

IIS Search Engine Optimization Toolkit

Posted June 4th, 2009 . No Comments . Uncategorized Tags: , ,

Microsoft announced the IIS Search Engine Optimization (SEO) Toolkit Beta – a brand new free toolkit that helps Web developers, hosting providers, and server administrators improve their sites’ relevance in search results by recommending how to make them more search engine-friendly. The SEO Toolkit Beta is available for installation via the Microsoft Web Platform Installer 2.0 Beta at  http://www.microsoft.com/web/downloads/platform.aspx

Let’s try it out and see whether it will work with SharePoint. By the way Scott Guthrie has post of details of the toolkit here.

« Newer Posts — Older Posts »

about me

Hi there! My name is Patrick and I code on .NET and build a few products on SharePoint and Windows Azure. I am currently CTO of IPS Infonomics Pte Ltd and co-founder of Tech Insights Conference.

where i'm online

I'm part of a number of social networks and other websites, including Twitter, Linked In, and Facebook.

categories

MVP (SharePoint Server)

Archives

Tags

Blog