Things I Need To Remember

BizTalk: Failed to update binding information

2012-02-06T02:10:00.000-08:00

Post from: http://felixmondelo.blogspot.com/2008/05/deploy-orchestrations-failed-to-update.html

Receive Location '' has no Transport type specified.

BizTalk stores info about the last deployments in:

C:\Documents and Settings\[user name]\Application Data\Microsoft\BizTalk Server\Deployment\BindingFiles

Windows 7

C:\Users\[user name]\AppData\Roaming\Microsoft\BizTalk Server\Deployment\BindingFiles

When you do a redeployment, BizTalk uses this information. If this information is with errors, we get this error "Failed to update binding information".

Solution is to remove the info binding file.

An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'

2011-11-16T07:10:00.000-08:00

Msg 15600, Level 15, State 1, Procedure sp_change_users_login, Line 214

An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.

I ran this script:

EXECUTE sp_change_users_login @action = 'auto_fix', @UserNamePattern = 'login'

Fix:

I added @Password parameter:

EXECUTE sp_change_users_login @action = 'auto_fix', @UserNamePattern = 'login', @Password = 'password'

SharePoint disable loopback check

2011-11-05T06:04:00.000-07:00

Post from: http://www.jeremytaylor.net/2010/05/24/sharepoint-disable-loopback-check-disableloopbackcheck-dword-in-registry/

I was constantly prompted for the username and password. In SharePoint 2010, it can really annoy you by not accepting your username password credentials in the popup window.

Its a ‘feature’ on the server that you need to disable as a workaround.
Caution: Microsoft Best practices is out of scope in this article. Do your own research on this topic.

You would need to create a DWORD registry key in the registry called DisableLoopbackCheck and set it to 1.
Follow these steps:

Click Start, click Run

Type regedit, and then click OK
In Registry Editor, locate the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
Right-click Lsa, point to New, and then click DWORD Value. (In Win 2008, its DWORD 32bit)
Type DisableLoopbackCheck, and then press ENTER.
Right-click DisableLoopbackCheck, and then click Modify.
In the Value data box, type 1 and then click OK.
Quit Registry Editor.
You may need to restart your server.

For more information about this, click the following article number to view the article in the Microsoft Knowledge Base: 281308 (http://support.microsoft.com/kb/281308/ ) Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name.

The type was not expected. Use the XmlInclude or SoapInclude attribute to specify types that are not known statically.

2011-10-02T23:19:00.000-07:00

Post from: http://www.johnsoer.com/blog/?p=125&cpage=1#comment-5494

public class Test
{
private string _Field = "";
public string Field
{
get { return _Field; }
set { _Field = value; }
}
}
public class TestInherited : Test
{
}
public class Container
{
private Test ivField;
public Test Field
{
get { return _Field; }
set { _Field = value; }
}
}
Container _Test = new Container();
_Test.Field = new TestInherited();

Solution:

new XmlSerializer(typeof(Container), new Type[] { typeof(TestInherited) });

This solution was not working for me because:

There was a namspace on my XmlRoot element [XmlRoot("Container", Namespace = "http://namespace", IsNullable = false)]

When i removed namespase, the problem was gone.

Hope this helps someone.

Setup WRT54G (or similar) running DD-WRT as Access Point

2011-09-20T05:48:00.000-07:00

Blog from: http://www.maximumpc.com/forums/viewtopic.php?t=59541

Setup > Basic Setup > WAN Connection Type: Connection type: Automatic Configuration - DHCP

Enter a good (outside of your DHCP range) IP address (and, of course, match your current subnet);

Setup > Basic Setup > Network Address Server Settings (DHCP): DHCP Server: Disable
Setup > Advanced Routing > Operating Mode: Operating Mode: Router

Setup > Advanced Routing > Dynamic Routing: Interface: Both

Setup > Advanced Routing > Static Routing: Interface: LAN & WLAN

SSRS 2008 R2 and UAC problem

2011-02-16T07:53:00.000-08:00

Post from: http://calebs71.blogspot.com/2010/09/ssrs-2008-domain-user-issue.html

Scenario: I have a new SQL Server Reporting Services 2008 R2 x64 instance that works if you are the local administrator. Once I switch to another user who is an implied administrator via an AD group I get the following error when attempting to access SSRS in a browser:

"User 'TESTDOM\user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."

The user is a member of the domain admins group which is obviously a member of the local admins. Also if I right click on IE8 and say "Run As Administrator" it works. The quick fix is to disable the UAC. If you don't want to do that then just do the below:

1. Launch IE8 using "Run As Administrator" and in SSRS (http://servername/Reports) click on Site Settings. In Site Settings navigate to "Security" and add your user "TESTDOM\user" as a System Administrator.

2. Click on "Home" and then "Folder Settings". Now add your account again this time assigning yourself all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder).

3. Close Administrative IE session and open a normal IE8 window and your SSRS should work.

Fix SharePoint 2010 alert url's

2011-01-12T01:14:00.000-08:00

http://technet.microsoft.com/en-us/library/cc508847.aspx

Login failed for user .

2011-01-03T01:59:00.000-08:00

Server Name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Error Number: 18456

Severity: 14

State: 1

Run SSMS as Administrator.

Could not create SSOSQL. Error Code: 0x80131700

2010-07-09T02:22:00.000-07:00

This is for x64 OS:

"C:\Windows\Microsoft.NET\Framework\v2.0.50727\regasm.exe" "C:\Program Files\Common Files\Enterprise Single Sign-On\win32\ssosql.dll"

"C:\Windows\Microsoft.NET\Framework64\v2.0.50727\regasm.exe" "C:\Program Files\Common Files\Enterprise Single Sign-On\win32\ssosql.dll"

"C:\Windows\Microsoft.NET\Framework\v2.0.50727\regasm.exe" "C:\Program Files\Common Files\Enterprise Single Sign-On\ssosql.dll"

"C:\Windows\Microsoft.NET\Framework64\v2.0.50727\regasm.exe" "C:\Program Files\Common Files\Enterprise Single Sign-On\ssosql.dll"

Restoring SQL Server 2005 Suspect Database

2010-04-16T03:39:00.000-07:00

Post from: http://mshehadeh.blogspot.com/2007/09/restoring-sql-server-2005-suspect.html

EXEC sp_resetstatus 'DBname'

ALTER DATABASE "DBname" SET EMERGENCY

DBCC checkdb('DBname')

ALTER DATABASE "DBname" SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('DBname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE "DBname" SET MULTI_USER

The SSO service failed to start. After installing VS 2010

2010-02-10T05:12:00.000-08:00

Post from: http://blogs.msdn.com/ashishme/archive/2009/08/14/fixing-biztalk-entsso-failure-on-windows-7-vista-or-server-2008-after-vs-2010-beta-installation.aspx\

I've been running BizTalk 2009 on my Windows 7 machine, and after installing VS 2010 beta 2, the Enterprise Single Sign-On Service stopped working.

It failed with the following error:

Could not create SSOSQL. To fix the problem, reinstall SSO or try 'regasm SSOSQL.dll' from a Visual Studio command prompt.
Error Code: 0x80131700

The file is located at C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll

Run Visual Studio Commmand prompt as Administrator and run 'regasm "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"'.

On 64 bit machines (windows 7, Vista, W2008 etc) you need to call regasm.exe utility explicitly from this folder:

C:\Windows\Microsoft.NET\Framework64\v2.0.50727\regasm.exe

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered error with 64bit OS

2010-02-04T01:29:00.000-08:00

Post from: http://weblogs.asp.net/cazzu/archive/2007/11/16/the-microsoft-ace-oledb-12-0-provider-is-not-registered-error-with-vista-64bit.aspx

If you're getting this error while trying to connect to Access 2007 or Excel 2007 via the Office 12 OleDB provider, you must first make sure you have the Office 2007 data providers installed.

Next, under x64 (64bit), the data providers will not work by default as they are 32-bit only (x86), even if the data providers download page doesn't say it. You have to explicitly compile for x86 instead of the default "Any CPU" platform:...

Read full article

The description for Event ID ( 17137 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found

2010-01-22T01:52:00.000-08:00

Post from: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sharepoint.setup_and_administration&tid=71af2356-f92e-4b15-8b09-798a91288cc3&cat=〈=&cr=&sloc=&p=1

Solution:

Open SQL server management studio.

Right click the database and select Properties->Options.
See if Auto close is set to True. If it is true, set it to false.

The evaluation version of Microsoft Office SharePoint Server 2007 for this server has expired

2010-01-04T06:54:00.000-08:00

http://support.microsoft.com/kb/971620

No exact match was found domain users. Domain users

2010-01-04T04:17:00.001-08:00

Post from: http://weblogs.asp.net/erobillard/archive/2007/07/06/how-to-change-service-accounts-and-their-passwords-in-moss-and-wss-3-0.aspx

Change the Application Pool Identity for SharePoint Central Administration (SCA)

Repeat these steps on each server which hosts the SharePoint Central Administration web application. If the web front-end (WFE) and application (APP) server roles are served by separate machines, SCA should be enabled on one APP server (or more) and stopped and/or removed from the WFE servers. This allows control over access to the SCA. The SCA service account should not be the same as that used for the SharePoint application pool so even if one is compromised, the other remains secure.

Open a command prompt.
Run: stsadm -o updatefarmcredentials -userlogin domain\username -password password
Be patient. This may take a few minutes to run.
To restart the application pool, either open IIS and recycle the application pool, or open a command prompt and type iisreset -noforce
Open SharePoint Central Administration in a browser to confirm that the change was successful.

The above steps create an Administration Application Pool Credential Deployment timer job. You can see this in the Timer Job Definitions page. The job is complete when it no longer appears in the list of definitions (refresh the browser, this isn't automatic).

Cannot connect to the configuration database. Event ID: 33002

2009-12-09T07:21:00.000-08:00

Post from: http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/8b3094a1-31ee-49d7-ab02-72ca0dc440a7

Description:
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.

Solution:

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

BizTalk Error: Project Creation Failed

2009-10-20T02:08:00.000-07:00

Post from: http://blogs.msdn.com/kerreybpi/archive/2009/05/12/biztalk-error-project-creation-failed.aspx

SYMPTOMS

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.

RESOLUTION

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

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

2009-10-14T04:57:00.000-07:00

Post from: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/af7650a8-148c-455e-99f3-3384b073e66f/

Problem:

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".

Resolution:

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.

Rebuild master DB SQL Server 2008

2009-10-10T03:24:00.000-07:00

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.

JavaScript in C#

2009-10-01T23:35:00.000-07:00

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

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

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

2009-09-23T03:26:00.001-07:00

Post from: http://kbarret3.spaces.live.com/blog/cns!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

2009-09-23T02:46:00.000-07:00

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

32 Bit ODBC Drivers in Vista 64

2009-09-22T23:21:00.000-07:00

Post from: http://postgresqldbnews.blogspot.com/2008/03/32-bit-odbc-drivers-in-vista-64.html

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.

C:\Windows\syswow64\odbcad32.exe

Using App.Config Settings in BizTalk 2004

2009-09-01T02:22:00.000-07:00

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:


<configuation>
<configSections>
<section name='MyConfigSection' type='System.Configuration.NameValueSectionHandler' />
</configSections>

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

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((
System.Collections.Specialized.NameValueCollection)
System.Configuration.ConfigurationSettings.GetConfig("MyConfigSection"));

// Now, we can access keys in the config section
varConfigHandler.Get("MyKey");

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

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

2009-07-21T06:20:00.000-07:00

Post from: http://blogs.msdn.com/balachandra/archive/2008/10/20/error-5009-registration-of-bam-performance-counters-failed-return-code-1.aspx

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.

No item exists at . It may have been deleted or renamed by another user.

2009-06-10T03:43:00.000-07:00

Remove <SharePoint:FieldDescription tags

Beyond Compare Synchronization Sheduling

2009-06-03T05:38:00.000-07:00

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

2009-06-03T05:33:00.001-07:00

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

Getting Access Into Windows Internal Database Instance MICROSOFT##SSEE

2009-06-01T04:35:00.001-07:00

\\.\pipe\mssql$microsoft##ssee\sql\query

Configuring MOSS 2007 to search pdf documents - install and configure pdf ifilters

2009-06-01T00:35:00.001-07:00

http://msmvps.com/blogs/sundar_narasiman/archive/2008/02/06/configuring-moss-2007-to-search-pdf-documents-install-and-configure-pdf-ifilters.aspx

Disable MySite and MyLinks in Sharepoint (MOSS) 2007

2009-05-29T05:42:00.000-07:00

Post from: http://geekswithblogs.net/RogueCoder/archive/2006/11/01/95766.aspx

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"

Launching VPN at startup

2009-05-28T04:18:00.000-07:00

Post from: http://geekswithblogs.net/thibbard/archive/2005/04/27/38581.aspx

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.

Check For Outlook Subject

2009-05-25T04:43:00.000-07:00

Post from http://vsivakumar.wordpress.com/2006/02/13/outlook-blank-subject-warning/

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 Sub

The file is checked out or locked for editing by

2009-05-13T04:32:00.000-07:00

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

{

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

{

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

try

{

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

listItem.Update();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

Console.ReadKey();

}

Add WSS templates in MOSS

2009-05-11T04:54:00.000-07:00

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

When using inline code in master page

2009-05-08T02:28:00.000-07:00

Add an extra PageParserPath:

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

Your license for Microsoft Search Server has expired

2009-05-08T01:25:00.000-07:00

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

2009-05-08T01:03:00.000-07:00

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

Code snippets do not appear in Visual Studio

2009-05-07T02:19:00.000-07:00

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.

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

2009-05-06T04:32:00.000-07:00

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.

View GAC Content

2009-04-28T01:28:00.000-07:00

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

ManagementObjectSearcher Access Is Denied

2009-04-20T04:36:00.000-07:00

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

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

2009-02-17T00:22:00.001-08:00

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“…

to…

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

You will also need to set custom errors to '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!!

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

2009-02-09T02:14:00.000-08:00

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

Locate and then click the following registry subkey:

HKEY_CLASSES_ROOT\CLSID\CLSID value

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},

Double-click on AppID in the right pane, .

A dialog box appears. Leave this box open

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

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

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

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

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.

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

Click OK two times and quit the registry editor

Save and retrive the value in ViewState object before the PostBack

2009-02-04T23:39:00.001-08:00

//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();

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

2009-01-27T04:46:00.000-08:00

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

Import user profiles from Active Directory to MOSS 2007

2009-01-14T04:46:00.000-08:00

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

2009-01-14T03:11:00.000-08:00

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

Edit document from dataview

2008-12-10T02:54:00.000-08:00

Redirecting from NewForm.aspx to DispForm.aspx after creating a new item

2008-12-02T01:05:00.000-08:00

public class CustomEventReceiver : SPItemEventReceiver
{
private HttpContext _currentContext = null;

public CustomEventReceiver () : base ()
{
if (null != HttpContext.Current)
{
_currentContext = HttpContext.Current
}
}

public override void ItemAdding (SPItemEventProperties properties)
{
using(SPSite site = new SPSite(properties.SiteId))
{
using(SPWeb web = site.OpenWeb(properties.RelativeWebUrl))
{
SPList list = web.Lists[properties.ListId];

DisableEventFiring();
SPListItem itemToAdd = list.Items.Add();
foreach (SPField field in itemToAdd.Fields)
{
if (!field.Hidden && !field.ReadOnlyField && field != null && field.InternalName != "Attachments")
{
itemToAdd[field.InternalName] = properties.AfterProperties[field.InternalName];
}
}
itemToAdd.Update();
EnableEventFiring();

// Redirect
SPUtility.Redirect("/cn/Lists/Bills%20of%20Lading/DispForm.aspx?ID=" + itemToAdd.ID, SPRedirectFlags.Default, _currentContext);
}
}
}
}

Errors were found when compiling the workflow.The workflow files were saved but cannot be run.

2008-11-20T01:17:00.000-08:00

Check web.config file authorizedTypes section.

JavaScript: Get URL Parameters

2008-11-14T01:10:00.000-08:00

var _GET={};
for(var m, v=location.href.split(/[?&]/), k=v.length-1;k>0;k--)
_GET[(m=v[k].split(/[=#]/))[0].toLowerCase()] = m.length>1?decodeURI(m[1]):"";

example:

mypage.aspx?MyParameter=2

var param=_GET.myparameter; (always use lowercase)

focus field javascript

2008-11-11T04:25:00.000-08:00

401 Unauthorized, WebServices, Sharepoint

2008-10-20T05:07:00.000-07:00

SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(web.Site.ID))
{
// do things assuming the permission of the "system account"
}
});

Show/Hide control

2008-10-15T04:42:00.000-07:00

control.style.display = 'block'; //show
control.style.display = 'none'; //hide

Set event onchange in JavaScript

2008-10-15T04:41:00.000-07:00

document.getElementById("something").onchange = function(){hideFields()}

Javascript get dropdownlist Label value?

2008-10-15T04:38:00.001-07:00

<select name="menu" id="menu"><option value="1">label 1</option><option value="2">label 2</option></select>

<button onclick="'show()'">Click me</button>

<script type="text/javascript"><br />function show(){<br />var theContents = document.getElementById('menu')[document.getElementById('menu').selectedIndex].innerHTML;<br />window.alert(theContents);<br />}<br /></script>

Access WebParts maintaince page

2008-10-10T06:36:00.001-07:00

Append the querystring ?contents=1

Speed Dial Tweaks In Opera: create more speed dial tabs

2008-10-08T00:27:00.000-07:00

1. In opera address field type: opera:config

2. At the top is field for search. Type speed

3. Under "User Prefs" find "Speed Dial File" (speeddial.ini file location)

4. Go to that location and open file speeddial.ini for edit.

5. At top add:

[Size]
Rows=3
Columns=5

Code blocks are not allowed in this file

2008-10-07T03:45:00.000-07:00

Whenever I start a new SharePoint project and put server side code in the master page I get this error. The fix to this is quite easy, all you need to do is locate the <pageparserpaths> </pageparserpaths> tags and put the following inbetween:

<pageparserpath virtualpath="/_catalogs/masterpage/MyMasterPage.Master" compilationmode="Always" allowserversidescript="true">

Impersonation in SharePoint 2007

2008-09-29T01:45:00.001-07:00

In SharePoint 2003 there was no easy way to use impersonation. In SharePoint 2007 there is a nice and easy build in way to use impersonation:

SPSite site = new SPSite("SiteCollection_Url");
SPWeb web = site.OpenWeb();
SPUser user = web.AllUsers["User_Name"];

SPUserToken token = user.UserToken;
SPSite impersonatedSiteCollection = new SPSite("SiteCollection_Url", token);

You can also check whether an SPSite object is using impersonation:

SPSite siteCollection = SPControl.GetContextSite(HttpContext.Current);
bool impersonating = siteCollection.Impersonating;

Enable Anonymous Access In SharePoint 2007 / WSS 3.0

2008-09-25T03:21:00.000-07:00

From Central Administration > Application Management > Application Security > Authentication Providers, select a Web application and the zone you want to modify. This is usually default.

In the middle of the page, check Enable Anonymous Access and choose Save

All site collections in that Web application can now have anonymous access enabled.

Go to a site collection in the Web application you just enabled anonymous access for

From Site Actions > Site Settings, open Advanced Permissions

From the Settings drop-down menu, select Anonymous Access

For this example, enable anonymous access for Lists and Libraries and click OK

Browse to any document library in this site collection

From the Settings drop-down menu, select Document Library Settings

In the Permissions and Management column, select Permissions for this document library

From the Actions menu, select Edit Permissions to break inheritance

From the newly appeared Settings drop-down menu, select Anonymous Access

Check View Items and click OK.

CAML - Query Lookup Field by ID; not by Value

2008-09-10T04:51:00.001-07:00

When lookup fields are created, sharepoint stores them as
ID;#Value format in related list.

for e.g.
in list “Contacts” there is column called “Country”.
There is item in contact with value “India” assigned in Country, having item ID=10.

Now for another list “List2″ when column “Country” is stored as Lookup column named “refCountry”; and for certain data item “India” is selected from combo box, Sharepoint stores it in,

10;#India in “List 2″ -> “refCountry” column.

When having CAML query in List2

The typical query looks like
<Query>
<Where>
<Eq>
<FieldRef Name=”RefCountry” />
<Value Type=”Lookup”>India</Value>
</Eq>
</Where>
</Query>

The disadvantage of this way is If list Contacts is having more than one entry(item or row) having value India for Country it will return the only first one. This may give inconsistent data for further.

To avoid this query should be base on ID not by Value.
This can be achieved thru :

<Query>
<Where>
<Eq>
<FieldRef Name=”RefCountry” LookupId=”TRUE” />
<FieldRef Name=”RefCountry” LookupId=”TRUE” />
<Value Type=”Lookup”>10</Value>
</Eq>
</Where>
</Query>

where 10 is the ID for item having country=”India”

Hide fields in New, Display or View forms in SharePoint

2008-09-10T04:40:00.000-07:00

One of the limiting factors in using the default forms (NewForm.aspx, EditForm.aspx) is that there is no obvious way to hide columns from appearing in the form. By default all columns in a list or document library will appear in your forms.

After doing quite a bit of research on this I found a fairly easy way to hide fields by using JavaScript within the form pages themselves. In my research I found several different sets of JavaScript code, but some of the scripts are easier to implement than others. Below I provide the best and most straight forward JavaScript and some simple steps to guide you along.

To hide fields in a SharePoint 2007 form, follow these steps (I will use the NewForm.aspx in my example)

Open SharePoint Designer and navigate to the site that contains the list or document library you wish to customize.
Expand the folder named “Forms” under the desired list or document library. You should see about seven .aspx pages (AllItems.aspx, EditForm.aspx, NewForm.aspx, etc)
Open the NewForm.aspx page and switch to the “code” view to edit the HTML of the page.
Paste the JavaScript code immediately below the the following HTML tag <asp:Content ContentPlaceHolderId=”PlaceHolderMain” runat=”server”> This will add the JavaScript to the HTML inside the content placeholder tag. Note: be sure to include the entire script below, including the <script and </script> tags.
Modify the “hidefields()” section of the JavaScript code to refer to each SharePoint list field name to hide. For example, the code sample below will hide the SharePoint fields named Title, Document Link, and PublishDate Notice that you do not need to worry about internal field names or field types like other JavaScript techniques, you simply need to know the name of the field.
Save the changes. Select “Yes” when prompted to “…customize the page from the site definition…”
Test the form

<script language="javascript" type="text/javascript">

_spBodyOnLoadFunctionNames.push("hideFields");

function findacontrol(FieldName) {

   var arr = document.getElementsByTagName("!");
   // get all comments
   for (var i=0;i < arr.length; i++ )
   {
      // now match the field name
      if (arr[i].innerHTML.indexOf(FieldName) > 0)
      {         return arr[i];      }
   }
}

function hideFields() {

   var control = findacontrol("Title");
   control.parentNode.parentNode.style.display="none";
   control = findacontrol("Document Link");
   control.parentNode.parentNode.style.display="none";
   control = findacontrol("PublishDate");
   control.parentNode.parentNode.style.display="none";

}
</script>

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

2008-09-05T02:18:00.000-07:00

I used query with left outer joins.

First i used Server Explorer to drag and drop my table, than i modified query.

When i draged and droped my table there was unique field (id) with key logo. Because of joins, query returned more than one unique id, so solution is:

Make this unique field (id) property "Unique" into False.

That solved my problem.

Embed a hyperlink into data view web part XSLT

2008-08-26T00:45:00.000-07:00

URL:

http://[server]/[site]/Lists/Open%20Positions/AllItems.aspx?View={84EEA2F5-121B-40B7-946F-0FA704A1DAA1}&FilterField1=Recruiter&FilterValue1=Hold

Convert it into:
http://www.blogger.com/Lists/Open%20Positions/AllItems.aspx?View=%7b84EEA2F5-121B-40B7-946F-%200FA704A1DAA1%7d&FilterField1=Recruiter&FilterValue1=Hold

I have manually transformed the first argument from:

{84EEA2F5-121B-40B7-946F-0FA704A1DAA1}

to:

%7b84EEA2F5-121B-40B7-946F-0FA704A1DAA1%7d

(In this, the open brace transforms to %7b and the closing brace transforms to %7d)

The server could not complete your request. Contact your Internet service provider or Web server administrator to make sure that the server........

2008-08-22T01:54:00.000-07:00

soap:ServerServer was unable to process request. ---> A Web Part or Web
Form Control on this Web Part Page cannot be displayed or imported because
it is not registered as safe on this site. You may not be able to open this
page in an HTML editor that is compatible with Microsoft Windows SharePoint
Services, such as Microsoft Office SharePoint Designer. To fix this page,
contact the site administrator to have the Web Part or Web Form Control

configured as safe.

Solution:

1. Open the site, for example http://mossportal/site/default.aspx
2. add "?contents=1" to the end of url, like this: http://mossportal/site/default.aspx?contents=1
3. You have a Web Part Page Maintenance and if you have some web part error delete it
4. Open the page with SharePoint Designer and all work correctly

Change Contents Types Display Form

2008-08-22T00:04:00.001-07:00

SPD refuses to update the supporting files for a content type unless it is the first in the 'create new' list.

Solution:

1. Change content type to first in New list

2. Assign custom form

Do that with all content types you want

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, ... failed (CLR Procedure)

2008-08-10T01:15:00.000-07:00

Solution:

1) ALTER DATABASE [Database Name] SET TRUSTWORTHY ON

2) Change the Permission Set of the CLR Code to External (Visual Studio's Project Properties)
a) Properties > Database > Permissions Level
b) Set to external