Pages

Search This Blog

Monday, February 9, 2009

Installation SQL 2008 Express Error: '' is not a valid login or you do not have permission

This is a very strange error. I've received error message "'' is not a valid login or you do not have permission" when trying to install Microsoft SQL Server 2008 Express Edition in my Microsoft XP Pro SP3 Machine.

To know more on installation guide, please check Install and Configure SQL Server 2008 Express by CondorMan.

I've followed the steps and got error message "'' is not a valid login or you do not have permission." and print screen as below.



I have no idea why is this. I've tried few suggestion stated in some of the forum:


  1. I've tried to change my user name and try to install.
  2. Create a new user "sa" with strong password. Login to window using this account and do installation.
Both methods fail.

Finally, i try to rename my machine/computer name and try to install and the installation completed successfully.




Conclusion:
This may be a bug from microsoft but i'm not sure.

My scenario: computer name = my user account

My Solution: change computer name to != user account then do installation.

p/s: Change user account won't help.

Hope this can help you. Share your solution if you have different one.

Saturday, January 31, 2009

Visual Studio 2005 Crystal Reports deployment

Well, we have a visual studio 2005 windows application with crystal report and wish to deploy to customer machine. There are some basic files that needed to deploy to a normal xp home machine:
  • .NET Framework 2.0 - download from microsoft site
  • Project files - compile from Visual Studio 2005
  • Crystal reports merge module - discuss here

Here we will discuss how to create crystal reports merge module setup for deployment purposes.

Below are the steps :
  1. Generate a setup using setup wizard (either create a new project or add a new project to existing project), name it setup1.


  2. Right click in Setup1, select Add-> Merge Module. and open files listed below (by default, it will go to the correct directory which is C:\Program Files\Common Files\Merge Modules).


    Crystal_Database_Access2003.msm
    Crystal_Database_Access2003_enu.msm
    Crystal_Managed2003.msm
    Crystal_regwiz2003.msm



  3. now right click on Crystal_regwiz2003.msm , Click Properties. in properties window, Click on (MergeModuleProperties), in License Key property set license code of crystal report.

    This code can be obtained from Help menu -> About Microsoft Visual Studio, here u find a licence code for 'Crystal Reports'. copy this code and paste it in license key proparty.

  4. Almost done. Now build setup by Right click on Setup1 and Click on Build


  5. Copy the setup1.exe from you project output folder (normally is in Project's Debug or Release folder)

Install this exe during deployment. Done

More reference:

http://msdn.microsoft.com/en-us/library/ms225227(VS.80).aspx
http://msdn.microsoft.com/en-us/library/aa287924(VS.71).aspx
http://msdn.microsoft.com/en-us/library/aa288179(VS.71).aspx
http://msdn.microsoft.com/en-us/library/ms227409(VS.80).aspx


http://resources.businessobjects.com/support/additional_downloads/runtime.asp

Friday, January 23, 2009

A Happy, Healthy & Properous Year 2009

Well, everyone know it a tough time but we have to face and over it patiently and enjoy life at the same time. Happy Chinese New Year 2009.

新年安康, 心想事成!

Sunday, January 11, 2009

DSL 2640T wireless router Save and Reboot

There is an question that always ask by surfer on where can i find [Save and Reboot] button after i have change the port forwarding. There a lots of good article on port forwarding, hence, i wont discuss here. You can get a good one here http://www.portforward.com/english/routers/port_forwarding/Dlink/DSL-2640T/BitComet.htm

My concern here is where to find [Save and Reboot] button after all the setting.
Well, it's here
1. Click on Tools
2. Click on System
3. You can find the [Save and Reboot] button.






Done. Hope this help.

Wednesday, December 31, 2008

Happy New Year 2009!

Happy New Year 2009! may better year ahead.

Wednesday, December 24, 2008

Merry Christmas!!!!

Wish you all merry christmas!!!!!!!!!!!!

Tuesday, December 16, 2008

Lock Windows XP

Sometimes, we need to lock our windows XP when we go out for a walk or leave our computer for a while in order to protect our information from others. Normally, pre install windows xp wont have the button/menu for us to lock it.

Here are few steps we can do to lock out computer.
  1. Go to Desktop, use your mouse right click on your desktop and select "New/Shortcut" from the list



  2. Once done, copy and paste the command rundll32.exe user32.dll, LockWorkStation and click "Next"



  3. Give a name to your shortcut before choosing the "Finish" option

Done.

Monday, December 15, 2008

Local Folders have xx new messages

Yes, i receive this message in taskbar but i cannot find any new email in my Local Folders .. strange.

After check on MozillaZine Knowledge Base. I found out that there is one setting that i left out and cause this issue:

My scenarion: I'm using pop mail.

To solve it, go to Tools --> Account Settings ...



Expend the account. Click on Server Settings. Checked/Select Automatically download new messages.




Now i can see my email after receive alert that "Local Folders has 1 new message".

Problem solved!

Sunday, December 14, 2008

SQL Server 2005 Developer Edition at USD49.95




Yes, this is true. Only USD49.95!



Overview for SQL Server 2005 Developer Edition: SQL Server 2005 Developer Edition provides a complete set of enterprise data management and business intelligence features. Because—like Enterprise Edition—it is optimized to run on x64 and Itanium-based servers, it is the most scalable and available edition of SQL Server 2005.

Check out in microsoft store.

Friday, December 12, 2008

AJAX PHP CAPTCHA

Thanks for http://www.phpcaptcha.org/documentation/quickstart/ provide a cool php captcha code. One of my colleague supporting a php site which need CAPTCHA to prevent spamming but most of the example given needed page post back which is not so practical. I have implement an AJAX CAPTCHA for ASP in my previous post on AJAX ASP CAPTCHA.

Now, we are using the same method to implement in PHP. By reuse the same javascript code with jquery, there is only a small changes in PHP part. Within 20 minutes, the code done and tested working. The files available for download here.

Happy programming. Please let me know if you have any problem.