Anything about IT

Daily IT topics by Alex Verboon

  • .NET Framework (1)
    64-bit (2)
    ACT (2)
    Active Directory (20)
    AGPM (1)
    AIK (11)
    AMT (1)
    Android (1)
    App-V (7)
    Apple (1)
    Applocker (1)
    Automation (66)
    Backup (1)
    Beta (8)
    BIOS (14)
    Bitlocker (2)
    BITS (2)
    BranchCache (5)
    Broadband (1)
    BSOD (1)
    Citrix (2)
    Cloud (3)
    Compaq (2)
    Compatibility (16)
    Computer Science (1)
    Deployment (93)
    DHCP (1)
    DirectAccess (2)
    drivers (9)
    Embedded (2)
    Energy (1)
    Excel 2007 (1)
    Fun (30)
    Google (3)
    Green (3)
    Group Policy (24)
    History (2)
    HP (9)
    Hyper-V (14)
    Hypervisor (1)
    IE8 (1)
    imagex (1)
    Intel (2)
    Internet (4)
    Internet Explorer (7)
    IPV6 (1)
    Job (1)
    Knowledge (53)
    Licensing (8)
    Live Mesh (4)
    MDOP (1)
    MED-V (4)
    Media Player (1)
    Microsoft (2)
    Microsoft Office (3)
    Mobile (4)
    MSE (1)
    MUI (1)
    Network (3)
    Office 2007 (5)
    Office 2010 (2)
    Office2010 (1)
    OS (1)
    Packaging (12)
    PDF (1)
    Performance (1)
    Powerpoint (1)
    PowerShell (3)
    product lifecycle (2)
    Protocols (5)
    Reading (50)
    Recovery (2)
    registry (3)
    RSAT (1)
    RTM (2)
    SCCM 2007 (1)
    Scripting (15)
    Security (20)
    Sequence (1)
    Sequencing (1)
    Sharing (1)
    Silverlight (1)
    SMS 2003 (1)
    SQL (2)
    SQL Server 2008 Express (1)
    Streaming (1)
    Symantec (1)
    TCP/IP (4)
    Tip (163)
    Tools (96)
    Tweak (1)
    Uncategorized (13)
    USMT (1)
    VDI (2)
    VHD (3)
    Virtualization (59)
    Vista (74)
    vmware (10)
    vPro (10)
    WAIK (2)
    Web (2)
    WHS (1)
    Windows 2000 (1)
    Windows 7 (92)
    Windows Home Server (1)
    Windows Mobile (1)
    Windows Server 2008 (25)
    Windows Server 2008 R2 (8)
    Windows Server 2008R2 (4)
    Windows Update Services (1)
    Windows XP (33)
    Windows7 (33)
    Windows7E (1)
    WinPE (1)
    Wireless (2)
    WMI (1)
    WSUS (1)
    WWW (1)
    XenDesktop (1)
    XP Mode (6)
    XPSP3 (1)
    YouTube (1)

    WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.

  • Archives

  • Meta

  • Visitor Locations

Archive for the 'SQL' Category

SQL Server 2008 Express Installation Sources

Posted by Alex Verboon on 7th March 2010

I got a bit confused by all the different SQL Server 2008 Express downloads that exist, so spend a little time in getting some insight. If you want to download SQL Server 2008 Express you have the following options:

Package Download
Microsoft® SQL Server® 2008 Express Edition Service Pack 1 Download
Microsoft® SQL Server® 2008 Express with Tools Download
Microsoft® SQL Server® 2008 Express with Advanced Services Download

 

Then I recommend reading the following blog posts. What’s up with SQL Server 2008 Express editions provides an overview of the supported feature of each distribution. The SQL Express 2008 family is getting bigger gives a good insight what the different installation packages do contain.

Tags: , , , ,
Posted in SQL, Tip | No Comments »

SQL Server services user account

Posted by Alex Verboon on 20th November 2008

When you install SQL Server 2000 / 2005 / 2008 you can configure under what user account the services are running. In the past i’ve often seen people selecting “local system”, I also selected that….not thinking too much about security then and it was the easiest to do with no need to create an additional user account and as long as you don’t need to access any other domain resources that worked fine.

Today from a security perspective though running the SQL services under the local sysem account is probably not a good idea, as the local system account is equivalent to a local administrator, so bad code that might get into your SQL server might hit the underlying system as well. From reading various sql forum postings and articles and Microsoft Technet articles it appears to be the best to simply create standard users accounts, during installation these accounts are being given the necessary permissions on the system they need.

If you don’t need access to other domain resources, the creation of local user accounts on the system that hosts the SQL server is enough, if not create them in AD.

The article “Picking Service Accounts” describes it all in more detail. (note that you must register yourself to read articles on SQLServerCentral.com

Tags: ,
Posted in SQL, Security, Tip | No Comments »