How to install Sql Server 2005 SP1 on existing SQL Server 2005 SP2 Install:- If you are getting "A recently applied update, KB913090, failed to install".

  If you are getting this error then one probable reason can be that you are trying to install Sql Server 2005 SP1 on a machine already having Sql Server 2005 SP2 Installed on it. This error might be followed by another error telling "SqlSupport.msp is not digitally signed" The best way to fix this error is by following these steps:-

  1. Save the data in the following Registry key HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90BootstrapMSIRefCountUninstall

  2.Copy this value data in a text file and save it for future use. 3.Go to control panel , add/remove program and remove the Microsoft Sql Server Setup Support Files.While uninstalling you might get some error message or warning that this uninstall may effect some other Sql Server Components which are already installed. 4.Click Yes to uninstall on the error message. 5.From the installation CD browse to the folder ToolsSetup and start the SqlSupport.msi to again install the Sql Server Setup Support Files 6.After this step again browse to the registry location mentioned earlier  and change the data value to the one we saved in the text file. 7.Now you can successfully start the install of Sql Server 2005 SP1


Reporting Server Not Starting:Starting Report Server Failed

How to tackle this situation as it may be really frightening

  1. Find your SQL server installation folder it might be in C:Program FilesMicrosoft SQL ServerMSSQL.xReporting ServicesReportManager.Here MSSQL.x can be anything where you Reporting Service is installed, generally if you have installed every thing including Notification Service,Analysis Service,Integration Service and DataBase service then it is MSSQL.4

  2. Use the All Programs menu to open the Report Server Status page.

From here you can locate the instance id ie. is it MSSQL.2 or MSSQL.4 etc...
3.Now open the ReportServer.config File and find the line containing <WebServiceAccount></WebServiceAccount>
4. Add IWAM_ComputerName like this <WebServiceAccount>IWAM_ComputerName</WebServiceAccount>   5. Save and then close the RSreportserver.config file. 6. Restart the SQL Server Reporting Services service.


Windows Live Writer Portable

Here is a very good post where you may know about Windows Live Writer Portable.For those who don't know Windows Live Writer is a desktop based application from which you can manage you n number of blogs.It consits of a rich sets of plugins to achieve different blogging objectives. Its a musch check and must have tool for bloggers The link to the post which i mentioned earlier is http://www.techlifeweb.com/2007/09/08/windows-live-writer-portable-20-now-with-u3/ You can download the portable version of Windows Live Writer from the below given link and you have to follow the instructions given above to install this portable version. http://www.techlifeweb.com/download/WLWPortable2.zip


Some useful properties,classes and methods which we require mostly during development in .net

 1: System.Web.HttpContext.Current.Request.ApplicationPath

System.Web.HttpContext.Current.Request.ApplicationPath gives you the applications current running path.

 

 

This list will be ever increasing as soon as i found some useful content i will publish it once again.

If you also want to share some common,useful and often ignored things in .net you can comment in there i will surely include them in the list.


Internet Explorer always ask for password for my Sharepoint Site.........is this causing havoc

  1. Although When you install Sharepoint it by default configures all the settings to be used with Internet Explorer, but sometimes it may happen that when you installed sharepoint server at that time you were having IE6 or some other version and now you want to switch to some other version.
  2. Now when you install this new version every setting made by Sharepoint is gone  and if you open your sharepoint website in the browser it always asks for the credentials
  3. So what you have to do is follow these simple steps to again configure Sharepoint Sites to run smoothly with you IE browser
  4. Now in Internet Options go to Local Intranet and make the security lever for this zone to low
  5. Then click on the sites tab

 

Now click on the advanced tab   Here in advanced settings make sure that you sharepoint site is included,and if not than just write the url of your site and press add and then close and then press OK     Now you sharepoint site should work fine in IE7 or others If you still have some queries than do leave a comment. There is also another article on how to configure and install sharepoint http://localhost/smallworkarounds/index.php/2008/10/24/share-point-series-basic-sharepoin/


Windows Live Writer Important Shortcuts

Few important shortcuts which can make you more productive using Windows Live Writer

  1. Ctrl + F11 for normal view, no styling information is applied while you are writing your blog entry
  2. Shift + F11 this is the Html Mode, here you can edit the Html contents of your posts and just do any manipulations in the HTML or do any inline styling to you post
  3. F11 If you want to writer your blog with all the styling information about the blog in your background while writing.
  4. F12 To see the web preview of the post once you write it, this shows how your post will look after publishing.
  5. Ctrl + L to insert an image either from web or from your desktop
  6. Ctrl + K Insert Hyperlinks
  7. Ctrl + Shift + V is the shortcut to Paste Special Command what it does is if you copy the content from somewhere else it can remove the styling information from the original content and yet preserving all the image and link tags,its thus really powerful
  8. F7 is to check spelling on the post.

If you want some more information regarding windows live writer than you can obtain it from these posts http://smallworkarounds.blogspot.com/2008/10/windows-live-writer-portable_24.html http://localhost/smallworkarounds/index.php/2008/08/10/download-windows-update-agent-5802469/ http://localhost/smallworkarounds/index.php/2008/08/10/downloading-windows-writer-2008-and/


Share Point Series:- Basic Sharepoint Installations And Configurations Part1

This is the first article in the series of Sharepoint articles, a lot of stuff will be coming in next few months. Here in this first article i will just talk about simple steps to follow to install Microsoft Office Sharepoint Server 2007 on Windows Server 2003. It will refer MOSS 2007 to Sharepoint Server from now on. It should be made clear in early phase of this article series that Sharepoint Server can only be installed on Windows Server Installations it cant be installed on Windows XP and Windows Vista Installations. Installing Sharepoint Server

  1. Just follow this useful link already present on MSDN to install Sharepoint Server.I will not rewrite the whole thing but i will discuss where ever required and some problems i faced and their solutions.
  2. http://technet.microsoft.com/en-us/library/cc263202(printer).aspx
  3. As satated at last in the above article when the installation finishes than you have to click next and then it will ask you for the configurations,so you can just click next and start the configurations.
  4. If you install the standalone install with all basic settings it basically performs 10 diffrent basic configuration tasks and these tasks may take time so be patient.
  5. If everythings goes on smoothly after sometime it will say configuration completed successfully.
  6. Now at this stage we are ready to test our first sharepoint site.     
  7. If this is the scenario with your system than probably you might be running something else on your port 80 such as your Source Controls Server Such as SVN or Source Vault.
  8. So first you have to stop those or configure them on another port to work in synchronization with Sharepoint Server.
  9. If you are using SVN than you just have to stop the Default running apache server which is uses by default and configures it to use port 80.
  10. Make sure if you have made the default install of Sharepoint Server than no other thing is running on port 80 or your default Sharepoint website will not run.


PostBack Events are not firing in asp.net................Why????????

This seems to be a problem with all the beginners at one or the other moment in their coding profession they face this problem. One of the silly mistake due to which this problem can occur is that you have some validation controls on your page which you are initialy not showing up on the page ie there might be a situation wherein you might have various divs on a page and you might be using tabbed navigaiton to show one particular div's contents at one time and hiding rest of the div's.So sometimes you might have some validation controls in one particular div and you might be working on the contents of another div which doesnot have any validation controls but do have postback controls ie asp controls. But what happens in this situation is that although the divs are hidden yet the markup is processed and loaded on the page now if you click on any postback buttons or linkbuttons or any control to do postback it will not postback because you have not met the required validation fulfilment reuqirements as the text boxes which you are using for validation might be empty or there might be some other problem in there which is causing validation to be false, thus no postback to the server. So if such is your scenario then just enter a property of the asp control called "CausesValidation" to false. Setting this will remove that button from checking that are the validation requirements fulfilled on the page and thus it will cause a postback.


Why is Guid Sometimes better than Identity in Database

When the application demands that the just inserted value should be returned back.In such cases it is much wise to use GUID instead of auto- incrementing identity column in the database. One benifit of using GUID is that it can be generated programatically beforehand using the GUID class in .net frmework We can have Guid guid  = new Guid(); Now we can pass this newly generated guid to any no of insert statements this way we can save our application from the complex logic of using output parameters or return statement and also from the use of SCOPE_IDENTITY(). But you are free to use the other approach also it all depends on the need of the application