SQL server and VMware/virtual server

[multiband8303]

There are some minute issues going with a SQL server, after doing research I came to the conclusion that .NET framework 2.0 needs to be deployed on it to resolve the problem, however I don't know what it could potentially impact.

Therefore I want to make a virtual server that is basically a duplicate of the actual environment and use it as a test bed.

Should I put this server on a DMZ? If it is an exact image copy that is (also would nortons ghost, be the best way to deploy the image on that test bed) I just don't want the actual server effecting clients that are requesting any information from that database so i'm wondering if going to the extent of putting it on a DMZ would be the best bet..or if I even have to go that far, since technically all the ODBC connections should look by hostname/ip address, and if I technically just change the hostname it should never request it.

 

[multiband8303]

Wrong forum?

 

[Nothinman]

If you disable the NIC in the VM instance or set it up for host only networking it won't be accessible from the network. Of course whether you can do that depends on how you intend to verify the system after you install the framework.

 

[multiband8303]

Microsoft Virtual PC would be a good candidate for this would it not? Or rather should I choose VMWare ESX?

 

[mxnerd]

Why would this has anything to do with DMZ? Unless you want the client access from the outside.

If you are just testing, either VMWare workstation (which cost you $189), or the free VMWare Server for WIndows or Virtual PC / Virtual Server will be fine. You absolutely don't need ESX server which cost you thousands of dollars to begin with.

Just give the virtual machine a different IP and change or modify the application that use SQL to point to this IP, that's it.

 

[multiband8303]

I should have specified, I need to access this outside, hence why I am putting it in the DMZ

as I will be in a couple different offices, and want to examine the results periodically..

I am giving Virtual Server a go, thank you guys.