Skip to main content

Whaddya know how to manage different version of MSSQL Database?

I've asked the question because I have different version of MS SQL databases version 2000 and 2005. I normally managed my database in MSSQL Server 2000 using Enterprise Manager tool and I am using SQL Server Management Studio to manage MSSQL Server 2005 database.

The Enterprise Manager is not available for download. You can install the client tools from the CD.

"The Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy to use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services" (Microsoft.com, 2008).

Here's the download link.

How to install Enterprise Manager (client tools) for MS SQL Server.
  • Insert your MS SQL Server CD, browse the CD, go to e:\english\SQL2000\ent ; this is what I have in my installation CD.
  • Double click on AUTORUN
  • Select the SQL Server 2000 components to continue.
  • Click on Install Database Server; the install shield will begin.
  • In Microsoft SQL Server 2000, click on Next
  • Computer Name, select Local Computer then click Next ; I'm using my test computer for this install so I choose local computer.
  • In Installation Selection, put check on Create a new instance of SQL Server, or install Client Tools, click on Next.
  • In User Information, type your Name and Company, click Next to continue.
  • Software License Agreement, click Yes to accept.
  • In Installation Definition, select Client Tools Only, click Next.
  • Select Components, I select Management Tools, Client Connectivity, Books Online, and Development Tools.
  • Click Next
  • Start Copying Files, click on Next ... setup is preparing to copy files.
  • Click on Finish.
To test your Enterprise Manager (client tools) installation, simply run the program. It should be added to your All Programs, Microsoft Server, Enterprise Manager.

How to connect to DB Server?
  • When you open your Enterprise Manager (client tools), you don't have anything setup.
  • In SQL Server Enterprise Manager, highlight Microsoft SQL Servers, right click and select New SQL Server Group
  • In Name, type Testing, click Ok ;I use Testing for my own test only, you can change this ofcourse.
  • Select the group Testing (the you just created), right-click and select New SQL Server Registration.
  • In Register SQL Server Wizard, click Next
  • Select a SQL Server in Available Servers, click Add, then Next
  • Select an Authentication Mode, Windows Authentication or The SQL Server login information. I choose the SQL Server login so I can use the built-in sa account for testing.
  • Select Connection Option, Login automatically or Prompt. I prefer Prompt for the SQL Server account information when connecting to provide extra security.
  • Add the SQL Server to an existing SQL Server group. I created Testing group or you can choose the default SQL Server Group (most db admin do anyway). I create my own group so I can organize DB connection management.
  • Completing the Register SQL Server Wizard, click Next, then Close to end.
The installation of Management Studio for SQL Server 2005 should be the same approach. You can't go wrong by accepting default. Visit our Geek community for assistance.

Thank you,
EM @KING.NET 

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 ===