Wednesday, December 9, 2009

Cannot connect to the configuration database. Event ID: 33002

The description for Event ID ( 33002 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: module, dbo.proc_getObjectsByClass.


Start, point to All Programs, point to Administrative Tools, and then click SharePoint Products and Technologies Configuration Wizard.

Important Because of a problem with the hotfix installation, you must not run the SharePoint Products and Technologies Configuration Wizard to complete the installation if you are running a Windows SharePoint Services stand-alone installation that uses the Windows Internal Database Engine. Instead, you must use the Psconfig.exe command-line utility. To do this, follow these steps:

1.Click Start, click Run, type cmd in the Open box, and then click OK.
2.Change to the following directory:
system drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin
3.Run the following command:
psconfig -cmd upgrade -inplace b2b
If you ran the SharePoint Products and Technologies Configuration Wizard, you may experience a long delay, and the wizard may not be completed successfully.

Alternatively, the configuration process may be unsuccessful, and you may receive the following error messages:

Configuration Failed
An exception of type System.Data.SQLClient.SQLException was thrown. Additional exception information access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid.

Additionally, the following event may be logged in the Application log:

Event ID: 5586
Source: Windows SharePoint Services 3
Unknown SQL Exception 33002 occured.
Additional error information from SQL Server is included below.
Access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid.

If you experience these issues, use the Psconfig.exe command to manually complete the installation of the hotfix.

If this doesn't help try this:

Superb, worked great. Found that the search service was disabled so it failed, but I had to run the command line again with -force on the end after setting the service to automatic.

Thanks very much for your help.

- Kurt

Tuesday, October 20, 2009

BizTalk Error: Project Creation Failed

Post from:


The error message appears on the status bar when you try to add a BizTalk 2009 project in Visual Studio 2008.
Error Details: “Create BizTalk Project …. Project Creation Failed”

This problem may occur after you applied SP1 for VS.


Browse to the installation folder of BizTalk 2009, run setup.exe, and choose “Repair” button, after that, you will work out the issue.

Wednesday, October 14, 2009

Error when using Upload File or New Data Source option in Report Manager

Post from:

I have just installed SQL Server 2008 and am having problems using Report Manager. Initially, I had problems accessing Report Manager so I removed the SSL identifies on both the web service and report manager website using the configuration manager.

This solved the problem of accessing Report Manager. However, if I now click on either the "Upload File" or "New Data Source" buttons in Report Manager I get the following error:

"Internet explorer cannot display the webpage".


Go to: C:\Program Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer
Open: rsreportserver.config
Set value of "SecureConnectionLevel" to 0 (zero);
Restart your Report Server.

Saturday, October 10, 2009

Rebuild master DB SQL Server 2008

1. From a command prompt window change to the following directory:

"C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release"

2. Next paste the following into the command prompt window and press “Enter”:

Setup.Exe /Action=RebuildDatabase /InstanceName=MSSQLSERVER /SqlSysAdminAccounts=Admin /Quiet

If you have SQL configured for Mixed Authentication Mode use the same syntax except you must also provide the /SAPWD parameter to specify the SA password. If you don't, you will get an error.

Thursday, October 1, 2009

JavaScript in C#

Page.ClientScript.RegisterStartupScript(GetType(), "hideWatermark", "<script type="\">function hideWatermark(element){ if (element.value == 'Fill to change display name') { element.value = ''; } = 'black'; }</script>");

control.Attributes.Add("onfocus", "javascript:hideWatermark(this)");

Wednesday, September 23, 2009

The path specified cannot be used at this time. (Exception from HRESULT: 0x80070094)

Post from:!5E66707AED54DB49!414.entry

During the process of trying to upgrade to SP1 on our MOSS and Project Server 2007 environment I hit the following problem when finally running configuration wizard which stopped it dead in its tracks...

An exception of type System.Runtime.InteropServices.COMException was thrown.

Additional exception information: The path specified cannot be used at this time. (Exception from HRESULT: 0x80070094)

After searching around I could find nothing in TechNet, MSDN or the wider Internet that applied to this error message. I did find an interesting but what seemed unrelated blog entry about SSP and Index Services becoming unstable but this had nothing to do with with running the SharePoint Configuration Wizard! Interestingly the final line in the blog entry indicated that the author had received a "The path specified cannot be used at this time" error when trying to start IIS Manager" so I decided to try and open IIS Manager as well. IIS Manager started up without the error but show no connected IIS server. Next I tried to attach to the server (Actions --> Connect) and now I received the same "The path specified cannot be used at this time" error!

I found the easiest way to fix this was to do and IISRESET and restart IIS Manager. After this IIS Manager started up fine with the expected server connection and the SharePoint Configuration Wizard ran through to completion without errors.

The resource object with key was not found

  1. On your SharePoint Web-Front-End Server navigate to 'C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\CONFIG\Resources'
  2. Copy needed resource files (.resx).
  3. Navigate to the IIS Virtual Directory of your SharePoint web site
  4. Copy resource files into the Virtual Directory's App_GlobalResources folder
  5. Perform an IISRESET
  6. Refresh your page.

Tuesday, September 22, 2009

32 Bit ODBC Drivers in Vista 64

Post from:

This post isn't really PostgreSQL specific. It also happens with MySQL and Ingres (and any other 32 bit driver).

I am running Vista 64 on one of my machines. I installed Postgres 8.3 and the ODBC drivers. When I tried to setup an ODBC connection, the windows ODBC administrator program ODBCAD32.exe did not list Postgres. I noticed that it also did not list MySQL or Ingres even though I knew I had installed drivers for those databases also.

After a bit of research, I tracked down the issue. My ODBC drivers did in fact install. Microsoft, in all their wisdom, has 2 versions of odbcad32. A 32 bit and a 64 bit. They are both named odbcad32.exe.

It gets better. They put the 32 bit odbcad32.exe in the syswow64 directory. They put the 64 bit odbcad32.exe in the system32 directory. 32 bit apps will pick up the 32 bit registry setting and 64 bit will pick up the 64 bit registry setting. system32 comes before syswow64 in the system path so the 64bit software runs before the 32 bit software.

So, when I manually ran odbcad32.exe in the syswow64 directory, I was able to configure my connections and everything worked hunky dory. I know have a shortcut to syswow64\odbcad32.exe on my desktop for working with 32 bit databases.

I wonder how stable the system would be if syswow64 was in the path before system32? I don't plan to find out.


Tuesday, September 1, 2009

Using App.Config Settings in BizTalk 2004

This is an example of how to use app.config settings in a BizTalk 2004 Orchestration.
First, you must setup the configuration section that you want to use. This is an example of what this looks like:

<!--This is an example of setting up your configuration section-->
<section name='MyConfigSection' type='System.Configuration.NameValueSectionHandler' />

<add key='MyKey' value='MyValue' />

Then, create an orchestration variable of type System.Collections.Specialized.NameValueCollection (I'll call it varConfigHandler)

This is an example of using the varConfigHandler in an expression shape:

// varConfigHandler has to be instantiated and bound to the config section we are interested in
// Notice that the result of the GetConfig function call is being cast into a NameValueCollection
varConfigHandler = new System.Collections.Specialized.NameValueCollection((

// Now, we can access keys in the config section

For deployment, copy the configSections/section and MyConfigSection into the config file for the BizTalk Service which is located at:

C:\Program Files\Microsoft BizTalk Server 2004\BTSNTSvc.exe.config

Tuesday, July 21, 2009

Error 5009.Registration of BAM performance counters failed. Return code -1.

Post from:

In one of my project I was remote installing BizTalk server on the dev machine and I encountered a strange error. "Error 5009. Registration of BAM performance counters failed. Return code -1." I searched and digged in for a solution and found that the performance counter registry may be damaged and the counters need to rebuilt. One of the forum thread suggested the use of lodctr exe with /r option for rebuilding counters. I tried however din't work for me. Let me tell you that my dev machine was running Windows 2003 server and I was not sure whether /r option was supported in that version of lodctr as the help text(use /?) did not show the option however though it showed the option /R: which restores performance registry strings from the specified filename. I also tried to restore PerfStrinBackup.ini file, din't work either. Then I tried the lodctr exe in Vista OS. This version supported the required option. I copied this version of exe to the dev machine and tried executing "lodctr /R". bingo! It worked!!. However please note I don't say that this is the right solution because there may be licencing issues associated in using Vista components in Windows 2003.

Wednesday, June 10, 2009

Wednesday, June 3, 2009

Beyond Compare Synchronization Sheduling

Create "Folder Compare" session
Add from and to folders (if sharepoint library unc path not working read this)
Add filter if needed
Save Session

Create text file: (script.txt)

log verbose append:"c:\autosync_log.txt"
load session_name
sync update:lt->rt

Create bat file:

BCompare.exe @"script.txt"

Add bat file to sheduled tasks.

Access document library trough UNC path \\servername\doclib

Start the Web Client Service under services and set it to startmode automatic.

Friday, May 29, 2009

Disable MySite and MyLinks in Sharepoint (MOSS) 2007

Post from:

In order to turn off or disable the MySite or MyLinks functionality you need to be an Sharepoint administrator.

Go to the Central Administration Web Page
Click on the link for Shared Services Administration
--If you have more than one SSP, select the one that is running the MySites functionality
Under "User Profiles and My Sites" click Personalization Services Permissions

Select the group you want to limit the functionality for. More than likely you will just have NTAuthority\Authenticated Users.

In the next screen you will see a list of checkboxes,
--To disable MySites uncheck "Create Personal Site"
--To disable MyLinks uncheck "Use Personal Features"

Thursday, May 28, 2009

Launching VPN at startup

Post from:

If you need to connect to a Virtual Private Network at windows startup, and you don't want to have the user push connect or enter the password do the following:

1) On the VPN Connect screen, check "Save this user name and password for the following users"
2) Select the "Anyone who uses this computer" radio button
3) Click "Properties" on the VPN Connect screen
4) On the "Options" tab, uncheck: -"Display progress while connecting" -"Prompt for name and password, certificate,etc."
5) In Windows Explorer, browse to C:\Documents and Settings\All Users\Start Menu\Programs\Startup
6) Open a new Windows Explorer and browse to Control Panel\Network Connections
7) Drag the icon of your VPN connection to the Startup folder. This will create a shortcut

Now at Windows startup, the VPN will launch and connect silently.

Monday, May 25, 2009

Check For Outlook Subject

Post from

1. Open your outlook

2. Press Alt+F11. This opens the Visual Basic editor

3. On the Left Pane, one can see “Microsoft Outlook Objects” or “Project1″, expand this. Now one can see the “ThisOutLookSession”.

4. Double click on “ThisOutLookSession”. It will open up a code pane.

5. Copy and Paste the following code in the right pane.(Code Pane)


Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)

Dim strSubject As String

strSubject = Item.Subject

If Len(Trim(strSubject)) = 0 Then

Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"

If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then

Cancel = True

End If

End If

End Sub

Wednesday, May 13, 2009

The file is checked out or locked for editing by

using (SPSite site = new SPSite("siteAddress"))


using (SPWeb web = site.OpenWeb("webAddress"))


SPListItem listItem = web.Lists["Project Documents"].GetItemById(_id);



listItem.File.CheckIn("Checked in by force");



catch (Exception ex)







Monday, May 11, 2009

Add WSS templates in MOSS

stsadm –o addtemplate –filename MyCustomSite.stp –title “Custom Site Template” –description “Use this template to create a new team site"

Friday, May 8, 2009

When using inline code in master page

Add an extra PageParserPath:

<pageparserpath allowserversidescript="true" compilationmode="Always" includesubfolders="true" virtualpath="/sitedirectory/marketing/_catalog/masterpage/*">

Your license for Microsoft Search Server has expired

The fix is to run one more time the SharePoint Products and Technologies Configuration Wizard

Your search cannot be completed because this site is not assigned to an indexer

1. Central Adminnistration

2. Application Management

3. SharePoint Web Application Management Content databases

4. Ensure your web application is the one selected

5. Select your content database name

6. Under Search Server - select your server

Thursday, May 7, 2009

Code snippets do not appear in Visual Studio

1. In Visual Studio, on the Tools menu, click Code Snippets Manager.
2. Change the language to XML.
3. Add [System]:\Program Files\Microsoft Visual Studio 8\Xml\1033\Snippets\Windows SharePoint Services Workflow to your snippets.

Wednesday, May 6, 2009

Could not access the Search service. SharePoint Configuration Wizard Step 5

1. On the Start menu, click Run. In the Open box, type regedit and thenclick OK.

2. In the Registry Editor, navigate to the following subkey, and then deleteit:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web ServerExtensions\12.0\WSS\Services\Microsoft.SharePoint. Search.Administration.SPSearchService

3. Run the SharePoint Products and Technologies Configuration Wizard again.

Tuesday, April 28, 2009

View GAC Content

Create a new DWORD key under HKLM\Software\Microsoft\Fusion\ with the nane DisableCacheViewer and set it’s [DWORD] value to 1.

Monday, April 20, 2009

ManagementObjectSearcher Access Is Denied

  1. Open the Computer Management Microsoft Management Console
    (MMC) snap-in.
  2. Expand Services and Applications, and then select WMI Control.
  3. Right-click WMI Control, and then click Properties.
  4. In the WMI Control Properties dialog box, click the Security tab.
  5. Expand Root, select CIMV2, and then click Security.
  6. In the Security dialog box, click Advanced.
  7. In the Access Control Settings dialog box, click Add. Select localMachineName\ASPNET, and then click OK.
  8. In the Permission Entry dialog box, make sure that Apply Onto is set to This namespace and subnamespaces.
  9. Make sure that the Allow 'Enable Account' and Allow 'Remote Enable' check boxes are selected.
  10. Click OK in each dialog box until you return to the WMI Control Properties dialog box.
  11. Repeat steps 5 through 10 for other WMI namespaces that
    your application will access.
  12. Restart IIS. To do this, run
    IISRESET from the command line.

Tuesday, February 17, 2009

A solution to "An unexpected error has occurred" in WSS v3

Debugging SharePoint can be problematic at times, it does like to hide debugging information from you. The bain of my life recently has been “An unexpected error has occurred” with nothing written to log files, trace or the event log.

Normally I can debug the problem with a little commenting & narrowing down of the problem, but today I have managed to get rid of that error screen completely.

The solution is to change a single entry in web.config, by modifying the line…

<SafeMode MaxControls=“200“ CallStack=“false“…


<SafeMode MaxControls=“200“ CallStack=“true“…

You will also need to set custom errors to 'Off' .

<customErrors mode=“Off“/>

You will no longer see the “An unexpected error has occurred” error page and instead you get a lovely ’standard ASP.Net error page’ with the stack trace and everything…development has got that little bit easier!!

Monday, February 9, 2009

Event 10016: The application-specific permission settings do not grant Local Launch permission for the COM Server application

  1. Go to Start - Run, and type regedit, and press enter

  2. Locate and then click the following registry subkey:


    Note In this subkey, “CLSID value” is a placeholder for the CLSID information that appears in the event error. I.e. in case of Sharepoint, the CLSID would be {61738644-F196-11D0-9953-00C04FD919C1},

  3. Double-click on AppID in the right pane, .

    A dialog box appears. Leave this box open

  4. Go to Start - Run, and type dcomcnfg, and press enter

  5. In the Component Services window, go to Component Services, go to Computers, go to My Computer, and then click DCOM Config.

  6. In the details pane, locate the program by using the friendly name, then choose Properties by right clicking on it

  7. At the Security tab, in the Launch and Activation Permissions area, click Customize, and then click the Edit button.

  8. Add the Local Service or Network Service account by clicking the Add button, typing the user’s account name (Local Service or Network Service, this depends on whats in your event error), and then clicking OK.

  9. Select the account name you just added, click to select the Allow check boxes for the following items:

    • Local Launch

    • Remote Launch

    • Local Activation

    • Remote Activation

  10. Click OK two times and quit the registry editor

Wednesday, February 4, 2009

Save and retrive the value in ViewState object before the PostBack

//Save the value in ViewState object before the PostBack
ViewState["SomeVar"] = txtFirstName.text;

//Retrieve the value from ViewState object after the PostBack
String strFirstName = ViewState["SomeVar"].ToString();

Tuesday, January 27, 2009

Unable to connect to SQL Server session database. The connection string (server='', database='SharedServices1_DB') was returned by an...

1. On SQL Server 2005 Management Studio, below Security - Logins
locate the user that represents your web server, DOMAIN\MACHINE$.
2. Right-click the DOMAIN\MACHINE$, choose User Mapping.
3. Map the SharedServices1_DB. check the roles db_owner and public.
4. Click OK and you're set!

MASHINE - your mashine name

Wednesday, January 14, 2009

Import user profiles from Active Directory to MOSS 2007

Scenario-1 - All users are in the current domain.

1. Go to User Profile and Properties under Shared Services Administration.

2. Click on configure profile import link. Select current domain as the profile datasource.

3. Make sure default access account is specified and is valid.

4. Run full import or incremental report.

Scenario-2 - Users are scattered into multiple domains or other data sources.

1. Go to User Profile and Properties under shared services administration.

2. Click on Import New Connection. Add a new connection for each of the data sources where you users are located. Delete any unwanted connections that might already be there.

3. Configure the import as mentioned above and make sure that Custom source is selected.

4. Run the full import or incremental import.

Permissions settings for sharepoint backup folder

Administrators Full Control
Authenticated Users Full Control
CREATOR OWNER Special Permissions
SYSTEM Full Control
Users Read & Execute; List Folder Contents; Read; Special Permissions