ankurdk
asked on
installing sql server 2000/2005/2008 on laptop and using it as server for other client systems
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...
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...
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
May I know the reason(s) for installing three SQL databases on the same physical computer?
ASKER
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.
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
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
> Otherwise use VM's.
VMs should be the most safe way to build a SQL test lab with varied versions from 2000 to 2008.
VMs should be the most safe way to build a SQL test lab with varied versions from 2000 to 2008.
ASKER
Thanks all for your valuable comments. I specially thank rk_india1 for the most precise solution.
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.