Dedicated SQL Server Hosting Specialist LiveZilla Live Help
Sales: sales@dedicatedsqlserver.com
Support: support@dedicatedsqlserver.com
Phone: 409-877-4238



Firewall/VPN/Load Balancing/SQL Server Mirroring Solutions for Dedicated SQL Servers

Here are some sample configurations. Our SQL Server/Windows expert can do any custom configurations to meet your requirements. Please click here to contact us.

Solution #1: Sample Firewall/VPN Solution for Hosted SQL Servers (More Information)

Solution:

  • Use Cisco ASA5505 as firewall.
  • Customer can use VPN to access the server

Price:

#
Item
Description
One Time Fee
Monthly
Fee
Note
1
ASA5505
Includes 10-user license, 8-port Fast Ethernet switch, stateful firewall, 10 IPsec VPN peers, 2 SSL VPN peers, 3DES/AES license, and 1 expansion slot
$99.00
$49.00
 
2
Web Server 1
1u Supermicro Super Server
Quad-Core Xeon E5410 CPU
2GB DDR2 RAM
2x500GB SATA
Onboard RAID 1
Win2003 R2 Standard x32
$0.00
$199.00
 
Total
 
$99.00
$248.00
 

Diagram:

Firewall/VPN Solution

Solution #2: Sample Windows Load Balancing Solution for Hosted SQL Servers (More Information)

Solution:

  • Configure web server 1 and web server 2 as Windows Load Balancing servers.

Price:

#
Item
Description
One Time Fee
Monthly
Fee
Note
1
ASA5505
Includes 10-user license, 8-port Fast Ethernet switch, stateful firewall, 10 IPsec VPN peers, 2 SSL VPN peers, 3DES/AES license, and 1 expansion slot
$99.00
$99.00
 
2
Web Server 1 & 2
1u Supermicro Super Server
Quad-Core Xeon E5410 CPU
2GB DDR2 RAM
2x500GB SATA
Onboard RAID 1
Win2003 R2 Standard x32
$0.00
$398.00
$199.00/each
 
Total
 
$99.00
$497.00
 

Diagram:

Windows Load Balancing Solution

Solution #3: Sample SQL Server Mirroring Solution for Hosted SQL Servers (More Information)

Solution:

  • Configure database server 1 and 2 to use SQL Server mirroring
    • Database server 1 as principal server
    • Database server 2 as mirroring server
    • Use our shared SQL Server as witness server for free
    • Automatic failover
  • Only need one SQL Server 2005 Standard Edition license

Price:

#
Item
Description
One Time Fee
Monthly
Fee
Note
1
ASA5505
Includes 10-user license, 8-port Fast Ethernet switch, stateful firewall, 10 IPsec VPN peers, 2 SSL VPN peers, 3DES/AES license, and 1 expansion slot
$99.00
$99.00
 
2
Database Server 1 & 2
1u Supermicro Super Server
Quad-Core Xeon E5410 CPU
2GB DDR2 RAM
2x146GB 15KRPM SCSI Driver
RAID 1
Win2003 R2 Standard x32
$0.00
$518.00
$259.00/each
3
SQL Server License
SQL Server 2005 Standard Edition
 
$249.00
 
 
Total
 
$99.00
$866.00
 

Diagram:

SQL Server Mirroring Solution

Solution #4: Sample Windows Load Balancing with SQL Server Mirroring Solution for Hosted SQL Servers (More Information)

Solution:

  • Configure web server 1 and web server 2 as Windows Load Balancing servers.
  • Configure database server 1 and 2 to use SQL Server mirroring
    • Database server 1 as principal server
    • Database server 2 as mirroring server
    • Web server 1 as witness server (SQL Server 2005 Express Edition)
    • Automatic failover
  • Only need one SQL Server 2005 Standard Edition license

Price:

#
Item
Description
One Time Fee
Monthly
Fee
Note
1
ASA5505
Includes 10-user license, 8-port Fast Ethernet switch, stateful firewall, 10 IPsec VPN peers, 2 SSL VPN peers, 3DES/AES license, and 1 expansion slot
$99.00
$99.00
 
2
Web Server 1 & 2
1u Supermicro Super Server
Quad-Core Xeon E5410 CPU
2GB DDR2 RAM
2x500GB SATA
Onboard RAID 1
Win2003 R2 Standard x32
$0.00
$398.00
$199.00/each
3
Database Server 1 & 2
1u Supermicro Super Server
Quad-Core Xeon E5410 CPU
2GB DDR2 RAM
2x146GB 15KRPM SCSI Driver
RAID 1
Win2003 R2 Standard x32
$0.00
$518.00
$259.00/each
4
SQL Server License
SQL Server 2005 Standard Edition
 
$249.00
 
 
Total
 
$99.00
$1264.00
 

Diagram:

Windows Load Balancing with SQL Server Mirroring Solution