Pankaj Tahiliani

Problem: When I try to bring up Outlook it has just begun giving me the following error message "Cannot start Microsoft Outlook. Invalid XML, the view cannot be load.

Solution: Start-> Run; outlook.exe /resetnavpane

You dont need to make any changes to IIS7 to get url rewriter working properly. You just need to properly declare the module in web.config. Make sure you have the following in your web.config file:

<system.webServer>
 <modules runAllManagedModulesForAllRequests="true">
  <add name="UrlRewriter" type="Intelligencia.UrlRewriter.RewriterHttpModule" />
 </modules>
 <validation validateIntegratedModeConfiguration="false" />
</system.webServer>

Write this line in web.config file (for IIS 7)

<system.webserver>
<validation validateintegratedmodeconfiguration="false">
</validation>

I got the above errror when I tried to run WSS default site after installing and running the Advance System Optimizer 3.o. I resolve this by going to the following locations and adding permission for the admin users accounts (ASP.NET & IIS_WPG) I have set up for Sharepoint.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
C:\WINDOWS\System 32\Log Files
C:\WINDOWS\Temp

After the correct permissions have been added, Sharepoint works as normal.

Have you ever wanted to connect to the “Windows Internal” database that WSS V3 uses?

While “Windows Internal Database” is Microsoft SQL Server 2005 in a limited edition (just like MSDE, WMSDE before it), the familiar access tools to the DB went missing, and connecting using standard ways doesn’t work either.

It doesn’t work right out of the box. First, you need SQL Management Studio Express.

Install and start it. Specify the following connection string:

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

Please note that, as implied by the connection string, this connection only works locally. If you are looking for the connection string than here it is:

“Provider=Sqloledb;Data Source=\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query;Database=SUSDB;Trusted_Connection=yes”

I've attempted to install WSS 3.0 with SP1 several times as both stand-alone and server farm with no luck on Windows Server 2008.  When I get to step 5 of Configuration wizard it begin installing and publishing services but on Step 5 I get the message "Failed To Register Sharepoint Services". The detail behind this message reads "An exception of type Microsoft.SharePoint.SPException was thrown". Then I

Run the command psconfig -cmd configdb -create -database <whatever_unique_name>

Click on Start / All Programs / Administrative Tools / SharePoint Products and Technologies Configuration Wizard

Should work now (it did with me).

PS: This was done on a Virtual Machine (VMware)

Sometimes we got this error message when we try to validate our asp.net website on w3c. To solve this error you need to write the PreRender event. Here is the complete event:

Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender
        imgBtnGo.Style.Remove(HtmlTextWriterStyle.BorderWidth)
        imgBtnGo.Attributes.Remove("border")
End Sub

To Check the date format of sql server:
select name ,alias, dateformat from syslanguages where langid =(select value from master..sysconfigures where comment = 'default language')

Execute this query on "master" database

You can set the Culture in your web.config file as below:
<system.web>
<globalization culture="en-US" />
</system.web>

INSERT INTO hits (recorded_time,ip,ua,request,referer,is_unique)
SELECT Convert(datetime,'2010-02-10 11:00:00'),00001001,'IE','default.aspx','direct',0
WHERE NOT EXISTS (SELECT ID FROM  Hits WHERE IP=00001001);SELECT @@IDENTITY;

Above query will check the existing record of the given IP. If found than it will return the ID else it will insert the new record and than return the newly generated ID.

Problem: Sometimes this error occurs due to the use of <input type="file"> control and make this control as "runat=server".

Solution: Delete this control and use <asp:FileUpload> control.