Skip to main content

Whaddya know how to install MS SQL Management Studio Express?

Here's the step by step procedure on how to install MS SQL Management Studio Express. If you are looking for MS SQL Server 2000 Enterprise Manager (client tool) install guide, clik it here. Let's begin:
  • First download the MS SQL Management Studio installer (SQLServer2005_SSMSEE). Please note, x64 is a different file to download.
  • Double click the install exe to begin the installallation.
  • You will be prompted by a welcome screen. Click Next to continue.
  • In Program Maintenance, select Modify, click Next
  • In Feature Selection, click the down arrow to see which feature(s) will be installed. Click on Next
  • Ready to Modify the program, click Install, then wait ... 
  • When you see Completing the Microsoft SQL Server Management Studio Express Setup, click Finish.
To test your installation, start the program.
  • Click on Start check your All Programs, Microsoft SQL Server 2005, select SQL Server Management Studio Express. It will start the program, please wait. 
  • Select the Server name and the Authentication (Windows or SQL Server login)
  • then Connect
If you have the right db server name and login information, you should be able to connect to your SQL Server 2005.


Popular posts from this blog

Alternative Social Networks

If you are planning to create your social network e.g. similar to Facebook. Here's a short list of alternative software's:

Open Source and Free​
http://buddypress.org/ - Wordpress (Open Source and Free)http://elgg.org/ - (Open Source and Free)Commercial Social Networks software
http://www.socialengine.com/ ($299 Stand Alone, $29/mo Cloud)http://www.jomsocial.com/ (run with Joomla, need to know CMS)http://www.boonex.com/ (very expensive, $399 for Standard)http://www.anahitapolis.com/http://www.oxwall.org/http://sharetronix.com/http://www.moosocial.com/http://www.jcow.net/http://phpdolphin.comhttp://www.grou.ps (from free to Commercial, I left my networks and they are selling it http://www.phpfox.com/ (I used this before, it's hard to maintain. I moved to NING but left too after it was sold to another company)http://www.ning.com (I don't recommend using this service, it's hard to export your data when it's time to move)Something to check when selecting your next soc…

Frequent Account Lockout in Active Directory

I have a user in Windows Pro 7, and Windows Server 2003 environment that is frequently account locked out. I tried many different scenarios to resolve this account lockout issue, from resetting his password, changing a new password, remove and re-join the domain, rebooting the workstation and active directory servers.

I tried to use the command prompt utility to run "rundll32.exe keymgrdll, KRShowKeyMgr" (case sensitive) to delete the account in Windows 7 password cache, and still no luck.

Still searching for answer ... Let me know if you encounter a similar issue in Windows Pro 7 and Windows Server 2003.

Continue reading updated post here:
http://www.whaddya.com/2011/09/windows-needs-your-credentials.html

Example of Out of Office Reply for Terminated Employee

This is a sample message that I used for terminated employees, unless HR staff specified a different message.
=== Example for KING.NET Employee === John Doe (employee or consultant) is no longer with KING.NET effective June 1, 2008 (termination date). For matters relating to "Project Name here" please direct your concerns to John Smith at johnsmith@king.net (Manager or Supervisor). For all other matters, please direct your email to Mary Smith HR at marysmith@king.net.
Please call our main office 703-345-6789 if you have other concerns.
Thank you.
=== end of message ===