Home / server / Questions / 105162
Accepted
Justin
Asked: 2010-01-22 11:57:12 +0800 CST

SQL Server Standard/Enterprise Edition hosted differently from SQL Express

  • 772

So SQL express in hosted on a machine, and I am assuming that SQL Enterprise or Standard is hosted on a dedicated server or something??

So I am a total rookie at this and am looking for learning resource for the host/connection/server side of this.....

Can anyone point me in the right direction please?

Thanks

sql-server sql-server-2005 connection hosting

3 Answers

  1. Not necessarily. SQL Express is frequently used on servers and even hosting environments. It's free! There are feature limitations that it has, though, which make it not an appropriate choice for large scale deployments. Standard and Enterprise editions have more enterprise features, and requirements, which make them better choices. For small volume apps / web sites Express is very very often an acceptable choice.

    Have a look at the edition comparison on the MS SQL site.

    If you can give us some details as to your environment and what you need to get set up then we could probably help you figure out what would be best for your situation.

    • 2
  2. Best Answer

    Your question is difficult because it seems like it's covering 2 different aspects; a SQL Server setup and connecting to it.

    The SQL part is actually not that difficult and is quite similar to installing it on your home PC. All you would do is install a version of SQL (even Express is okay) on to a server. One important aspect of this installation is the use of an instance name. On a workstation this might not be as important, but for a production SQL Server database it's very important. You can have multiple instances of SQL Server on one server so instance names help you define which one you would be connecting to. In most cases, the default instance name, MSSQLSERVER, is fine.

    Outside of that, it gets more dependent on how you'll be connecting to the SQL server. Did you have something in mind that would require a dedicated server? We might be able to give you more advice if you had something in mind.

    Here are some links in regards to setting up SQL Server as well as information about instances:

    Server Fault question about instances
    MSDN for Planning a SQL Server Installation
    MSDN for Multiple SQL Server Instances
    Multiple SQL Server Instances article from InformIT

    • 1

  3. All versions of SQL Server are service applications that you install and run on top of Windows. Architecturally, there are no differences in how the Express version runs vs. the others. SQL Server Standard, Enterprise, and Development just give you access to additional features (such as Reporting Services and Analysis Services), and don't have restrictions on the size of the databases.

    I also believe that Standard and Enterprise can only be installed on a server version of Windows (Server 2003, Server 2008), where as Express and Development may be installed on either a server or client (XP, Vista, 7) version.

    • 1