?
Solved

installing sql server 2000/2005/2008 on laptop and using it as server for other client systems

Posted on 2014-01-18
8
Medium Priority
?
457 Views
Last Modified: 2014-02-09
Hi,
I have a laptop with following config :
Processor - i3
RAM - 4GB
HDD - 500GB
with windows 7 as the OS.

Scenario:

I need to install sql server 2000/2008 on this machine (L1) and use it to enable another laptop (L2) with same config to access the sql database installed on L1 through an application.

My Question :

 Can I use L1 as a server machine. If yes, what OS do I need to install on it or windows 7 will work fine to enable L2 to identify L1 as a sql server and be able to access the database using an application.

An answer or a suggestion in this regard shall be appreciated.

Best...
0
Comment
Question by:ankurdk
[X]
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
8 Comments
 
LVL 4

Expert Comment

by:colditzz
ID: 39790635
It depends on the version of SQL server you are installing.  From memory you can only install the free (SQL Express) or developer editions (not licensed for live production use) on non-server Operating Systems.

If you are installing the SQL Express edition, make sure you enable TCP/IP, Named Pipes, etc in the SQL Server Configuration Manager.

Hope the above helps.
0
 
LVL 7

Expert Comment

by:peea
ID: 39790697
SQL2K5 and SQL2K5 can be supported by main stream Windows from Windows 2003 to Windows 2012. Why SQL2K?

If you have to keep SQL2K, SQL2K5 and SQL2K8 on the same physical machine, I think the only way is to run them in individual VM on the same physical server.

For SQL2K, you may run NT4 or W2K; for SQL2K5 you may choose W2K3, and W2K8 for SQL2K8.

Using bridge mode for each VM's virtual NIC allows all the three VMs to run on the same subnet and to be visible for all SQL client computers.
0
 
LVL 5

Accepted Solution

by:
rk_india1 earned 1000 total points
ID: 39791104
For Machine L1 please use Windows 2003 so you can install SQL 2000 and 2008 both ,

first Install SQL 2000 along with all the service pack once it is done then installed SQL 2008 as a name instance.

http://social.msdn.microsoft.com/Forums/en-US/c1461907-8e2d-428b-a49c-e206f808be09/how-to-install-sql-server-2000-in-windows-server-2003?forum=sqlsetupandupgrade


Can I use L1 as a server machine.-- Yes Windows 2003

  windows 7 will work fine to enable L2 to identify L1 as a sql server and be able to access the database using an application--Yes. Please make sure you enable TCP/IP, Named Pipes, etc in the SQL Server Configuration Manager.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 7

Expert Comment

by:peea
ID: 39806884
May I know the reason(s) for installing three SQL databases on the same physical computer?
0
 

Author Comment

by:ankurdk
ID: 39808612
Well, I apologize for not being able to clarify the case. I want to install either versions of the server i.e either sql server 2008 or sql server 2000, sql server 2008 more preferably on the two laptops.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39809092
Hi,

I believe in the past I've had SQL 2000/SQL 2005/SQL 2008 installed on my workstation for testing etc. I tend to install them as named instances. And install them in order - SQL 2000, then SQL 2005, then SQL 2008.

Do note the OS requirements, which means you need windows XP or windows 2003 as the OS.

Otherwise use VM's.

Regards
  David
0
 
LVL 7

Expert Comment

by:peea
ID: 39811881
> Otherwise use VM's.

VMs should be the most safe way to build a SQL test lab with varied versions from 2000 to 2008.
0
 

Author Closing Comment

by:ankurdk
ID: 39846418
Thanks all for your valuable comments. I specially thank rk_india1 for the most precise solution.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

771 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