Results 1 to 15 of 15
  1. #1

    SQL Server express

    Is there any varhosting.net reseller here?
    Does anyone know whether varhosting.net supports SQL express or not?
    Nazmul Hassan, CEO / Founder BNH Production
    Domain Registration, Web Hosting, Website Design
    ASP.NET, MS SQL 2005, Ajax, PHP, MySql, HELM & more
    Networking and IT consultancy service in Bangladesh

  2. #2
    Join Date
    Oct 2004
    Location
    Trivandrum, Kerala, India
    Posts
    221

    sql express

    I am not aware of any hosting provider who provides SQL Express. Most hosts provide SQL Server 2005. If you want express then you can buy a VPS and install SQL Express on it.

  3. #3
    Thanks web_host_guy for your reply. I sent a mail to varhosting.net asking whether thet support sql server express or not and Rick (varhosting.net) has informed me that his server supports sql server express.

    This is just for your info...
    Nazmul Hassan, CEO / Founder BNH Production
    Domain Registration, Web Hosting, Website Design
    ASP.NET, MS SQL 2005, Ajax, PHP, MySql, HELM & more
    Networking and IT consultancy service in Bangladesh

  4. #4
    Join Date
    Oct 2003
    Location
    UK
    Posts
    3,375
    SQL Express is not used for clients database hosting, SQL that hosts use would be workgroups/standard/enterprise
    Cyber Host Pro Ltd - over 10 years in the UK hosting industry.
    Website Hosting | Reseller Hosting | Cloud VPS Servers | Dedicated Servers
    ★ WhiteLabel OnAPP Cloud VPS Reseller Program, Failover, 10Gbit SFP+ Dual SAN storage with Cpanel, Plesk & Windows server.
    www.cyberhostpro.com - UK Call Centre + 24x7 Online Chat

  5. #5
    Join Date
    Mar 2005
    Posts
    290
    Yeah, our servers support SQL 2000 and SQL 2002 databases of course...as well as this you can install sql server express on your own local machine and use the client connection wizard to make a connection to a remote database (similar to Enterprise Manager) I believe.

    HRK, if you have any questions feel free to contact me directly anytime.

    Thanks,
    Rick

  6. #6
    Join Date
    Mar 2005
    Posts
    290
    Yeah, our servers support SQL 2000 and SQL 2002 databases of course...as well as this you can install sql server express on your own local machine and use the client connection wizard to make a connection to a remote database (similar to Enterprise Manager) I believe.

    HRK, if you have any questions feel free to contact me directly anytime.

    Thanks,
    Rick

  7. #7
    Join Date
    Oct 2004
    Location
    Trivandrum, Kerala, India
    Posts
    221

    Sql 2002

    Well. There is no SQL 2002. It should be either SQL 2000 or SQL 2005. I think you are providing wrong replies.

  8. #8
    Join Date
    Mar 2005
    Posts
    290
    Whoops, meant to say SQL 7

  9. #9
    Join Date
    Aug 2005
    Location
    Earth
    Posts
    326
    is there a reason why webhost dont offer sql express?
    No, i am not the guy from the simpson's, what's his name again?

  10. #10
    Join Date
    Nov 2004
    Location
    Tega Cay
    Posts
    763
    There are some that do, if it's a low volume server it is no problem. SQL Express is limited in a few ways:
    • Can only use 1 cpu (but can be installed on a dual proc sys)
    • Can only use 1 GB RAM
    • DB size is limited to 4GB (not usually a concern in shared hosting environment)

    Is there a reason you are specifically looking for SQL Express? If it's to host one of the SK's that can be easily accomplished on a SQL 2005 box of any flavor and even on SQL 2000 in most cases.

  11. #11
    Join Date
    Aug 2005
    Location
    Earth
    Posts
    326
    Quote Originally Posted by Squorpeeon
    There are some that do, if it's a low volume server it is no problem. SQL Express is limited in a few ways:
    • Can only use 1 cpu (but can be installed on a dual proc sys)
    • Can only use 1 GB RAM
    • DB size is limited to 4GB (not usually a concern in shared hosting environment)

    Is there a reason you are specifically looking for SQL Express? If it's to host one of the SK's that can be easily accomplished on a SQL 2005 box of any flavor and even on SQL 2000 in most cases.

    Are these the only limitation to sql express vs sql 2000
    No, i am not the guy from the simpson's, what's his name again?

  12. #12
    Join Date
    Nov 2004
    Location
    Tega Cay
    Posts
    763
    Check out the comparison chart for the ful differences in the 2005 versions at http://www.microsoft.com/sql/prodinf...-features.mspx

    To get all the features available including full text search make sure you download w/advanced features version ~234 megs instead of ~50

  13. #13
    Join Date
    Aug 2005
    Location
    Earth
    Posts
    326
    After reviewing the difference between express and work group there isn't much of a difference so for those who would like to know i think sql express is ok in production environment for a small database.

    *** Note this is note professional advise, i am no sql pro.
    No, i am not the guy from the simpson's, what's his name again?

  14. #14
    Join Date
    Oct 2003
    Location
    UK
    Posts
    3,375
    I thought SQL express was limited to 1 database?
    Cyber Host Pro Ltd - over 10 years in the UK hosting industry.
    Website Hosting | Reseller Hosting | Cloud VPS Servers | Dedicated Servers
    ★ WhiteLabel OnAPP Cloud VPS Reseller Program, Failover, 10Gbit SFP+ Dual SAN storage with Cpanel, Plesk & Windows server.
    www.cyberhostpro.com - UK Call Centre + 24x7 Online Chat

  15. #15
    Join Date
    Nov 2004
    Location
    Tega Cay
    Posts
    763
    Quote Originally Posted by CyberHostPro
    I thought SQL express was limited to 1 database?
    There is no limit to the number of databases you create but each database can only be up to 4GB.

    Orlando, I agree with you, especially since when you do find yourself needing more than 1GB of memory you can simply upgrade to Workgroup edition. SQL Express is an easy way to get your feet wet in SQL hosting. I do however suggest anyone who will begin to host SQL server learn some things about it before just putting a control panel in front of it to create databases and users. You will have to be able to support it if something goes wrong.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •