Create database on local machine

Posted on 2007-11-20
Last Modified: 2012-06-27
I'm learning how to use MSSQL, I have SQL Enterprise Manager installed on my machine at work. I was also given access to the databases so I could start creating reports using Crystal Reports. (I have experience using MySQL and I just started this new job). What steps do I need to take to create a database on my local machine that I can use to practice? I'm going to be creating stored procedures that will run be the background of the report, and I would like to get some practice. Thanks!
Question by:horalia
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2

Expert Comment

ID: 20322044
Microsoft SQL Server 2005 Express Edition can be found here:

It will have almost everything you need to begin working with SQL Server.  This appears in the SQL Server 2008 zone, but is your company using 2008 for their production data already?

For your Crystal development SQL Server 2005 Express Edition should do all you need.


Author Comment

ID: 20322075
The Enterprise Manager and the SQL Query analyzer are both 8.0. I can see the databases that each server has, but I would like to create one on my desktop. Can my local machine run as a server too?
LVL 18

Accepted Solution

Yveau earned 500 total points
ID: 20322567
version 8 ? That means that you are running SQL 2000, not SQL 2008 ...

Anyway, yes your local machine can act as a SQL server as well, just install the SQL Server 2005 Express on your own machine. It's free and there is a SQL 2005 client as well (SQL Server Management Studio). Here is the home page for the SQL 2005 Express:

You should be able to find the download links here.

Hope this helps ...
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  


Author Comment

ID: 20322738
Exactly what I need. Thanks!
LVL 18

Expert Comment

ID: 20322773
Glad I could be of any help and thanks for the grade !

Expert Comment

ID: 20323050
isn't that the same link I provided?

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question