Associate
- Joined
- 19 Mar 2008
- Posts
- 638
- Location
- London
Hi all,
I'm trying to set up a development environment at home but I'm lost in setting up the VMs using Workstation 6. I have a few questions that give me way too many dead-end links in Google so I'm hoping someone will be able to shed some light or point me towards the right direction.
wanted Setup:
VM with Server 2003 + SQL Server 2005 (call it sqlsrv)
VM with Server 2003 configured for IIS, XML Web Services (call it appsrv)
2 or more VMs XP Clients (xp01...xp02 etc.)
behaviour:
- XP client VMs with VB.Net front end apps to call XML services on appsrv
- XML services in appsrv must be able to connect to the sql server database sqlsrv to read/write
To do the above, all documentation points towards setting up a team on Workstation or can I have separate VMs? Any settings I need to be aware of/change?
The next bit is where even the documentation looses me:
- On my laptop, where I have Visual Studio setup, along with IIS; I want to be able to configure it to connect to the SQL Server database on appsrv even when I'm not at home. In other words I want my laptop to connect remotely via VPN? to the database sitting at home on a VMWare instance (sqlsrv). And use it just like any other database engine listed in SQL Server Management Studio (on the laptop). I'm hoping this is possible.
How would I go about doing that? I know I need to enable some ports on my router for VPN, which if I google I should be able to do. But how do I expose the SQL server instance within the VM for remote usage?
I'm running VMWare workstation 6 on a vista 64 host at home, XP laptop. Be Broadband, with the speedtouch modem/router.
Loads of questions I know, but I could appreciate some direction.
Many thanks.
I'm trying to set up a development environment at home but I'm lost in setting up the VMs using Workstation 6. I have a few questions that give me way too many dead-end links in Google so I'm hoping someone will be able to shed some light or point me towards the right direction.
wanted Setup:
VM with Server 2003 + SQL Server 2005 (call it sqlsrv)
VM with Server 2003 configured for IIS, XML Web Services (call it appsrv)
2 or more VMs XP Clients (xp01...xp02 etc.)
behaviour:
- XP client VMs with VB.Net front end apps to call XML services on appsrv
- XML services in appsrv must be able to connect to the sql server database sqlsrv to read/write
To do the above, all documentation points towards setting up a team on Workstation or can I have separate VMs? Any settings I need to be aware of/change?
The next bit is where even the documentation looses me:
- On my laptop, where I have Visual Studio setup, along with IIS; I want to be able to configure it to connect to the SQL Server database on appsrv even when I'm not at home. In other words I want my laptop to connect remotely via VPN? to the database sitting at home on a VMWare instance (sqlsrv). And use it just like any other database engine listed in SQL Server Management Studio (on the laptop). I'm hoping this is possible.
How would I go about doing that? I know I need to enable some ports on my router for VPN, which if I google I should be able to do. But how do I expose the SQL server instance within the VM for remote usage?
I'm running VMWare workstation 6 on a vista 64 host at home, XP laptop. Be Broadband, with the speedtouch modem/router.
Loads of questions I know, but I could appreciate some direction.
Many thanks.
