Skip to main content

Whaddya know how to manage different version of MSSQL Database?

Image
By [email protected] and Support @ Whaddya.com
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 

Labels:

Comments

Post a Comment

Popular posts from this blog

Alternative Social Networks

By [email protected] and EM @QUE.com
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.com http://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) S
3 comments
Whaddya know more?

Learning Vulnerability Scanning by KING.NET

By [email protected] and EM @QUE.com
Learning Vulnerability Scanning is fun and easy. So I hope you enjoy reading this short how to guide on how to use vulnerability scanning to secure your servers and networks. NMAP is the swiss tool that you need to learn if you're serious in Cyber Security profession. The NMAP tool can be use with NSE scripting (Nmap Scripting Engine) to automate your tasks. For example using NSE Script using a  single vulnerability (cold fusion)  to scan our test lab machine. root@kali:~# nmap -v -p 80  --script http-vuln-cve2010-2861  10.11.1.220 Starting Nmap 6.47 ( http://nmap.org ) at 2016-07-22 17:34 EDT NSE: Loaded 1 scripts for scanning. NSE: Script Pre-scanning. Initiating ARP Ping Scan at 17:34 Scanning 10.11.1.220 [1 port] Completed ARP Ping Scan at 17:34, 0.04s elapsed (1 total hosts) Initiating Parallel DNS resolution of 1 host. at 17:34 Completed Parallel DNS resolution of 1 host. at 17:35, 13.01s elapsed Initiating SYN Stealth Scan at 17:35 Scanning 10.11.1.220 [1 port] Comp
Post a Comment
Whaddya know more?