SBS 2008 std and Sql Server 2008 std question

Discussion in 'Windows Small Business Server' started by john doe, Jun 9, 2010.

  1. john doe

    john doe Guest

    SBS2008 came with Windows Server std 2008 and Sql Server std 2008.
    I installed SBS2008.
    I installed Windows Server 2008.
    I joined Windows Server 2008 to the SBS 2008 domain with a regular user
    account (I had to make a regular user account in SBS2008 so that when I
    joined the Windows Server 2008 to it, I would be able to install SQL Server
    I then installed SQL Server 2008.
    My question is this. Do I have to continue to login on Windows Server 2008
    as a regular user or can I login to it as the administrator? If I do, will
    that affect my domain connection to SBS2008? Also, will my SQL Server 2008
    run correctly if I login as an administrator instead of the regular user?
    Please advise and thanks.
    john doe, Jun 9, 2010
    1. Advertisements

  2. "regular users" don't have the appropriate permissions to join machines to
    the domain by default. So this is very likely a domain admin account. It
    just isn't *named* "Administrator" which is normal in 2008 (and Vista and
    Win7.) The default Administrator account is disabled (Since it is a popular
    attack vector) and one (or more) domain admin accounts are created for each
    user that needs Admin privs. You can rename that account to something with
    "admin" or similar at the end so you can distinguish it from a limited user

    You can then create yourself a limited user account via the SBS console.

    Will logging in with your new shiny limited-user account affect your domain
    connection? No.

    Will SQL Server run correctly? Yes. It runs as a service which means how
    *you* log in doesn't matter. Background servies can run as a different user
    than the logged-in user (and do). This is a basic feature of the Windows NT
    line (3.51, 4, 2000, XP, 2003, 2003 R2, Vista, 2008, windows 7, 2008 R2,

    If you aren't comfortable with how permissions work in windows, I recommend
    picking up a quick book to learn this stuff. Maybe something like this...

    Cliff Galiher
    Microsoft has opened the Small Business Server forum on Technet! Check it
    Addicted to newsgroups? Read about the NNTP Bridge for MS Forums.
    Cliff Galiher - MVP, Jun 9, 2010
    1. Advertisements

  3. Hello John,

    Thanks for your post and Cliff's clear input and suggestions.

    So you are using SBS 2008 Premium edition, right? Just for your reference, if you plan to install SQL Server 2008 on the second server running Windows Server 2008 in Windows SBS 2008 Premium, do
    the following before you run the installation:

    1. Log on as a domain administrator. If you fail to log on as a domain administrator, the installation is blocked.

    2. Join the second server into the Windows SBS 2008 domain.

    3. If the second server is not in the Windows SBS 2008 domain, the SQL Server 2008 installation is blocked. You can only install the included version of SQL Server 2008 on a Windows SBS 2008

    4. It is recommended that you do not install SQL Server 2008 on a domain controller. If you must install SQL Server 2008 on a server that is a domain controller, you should promote the server as a
    domain controller prior to installing SQL Server 2008. Do not promote the server as a read-only domain controller. SQL Server 2008 is not supported on read-only domain controllers.

    Note , If you do not promote the server before the installation, SQL Server encounters an access control list (ACL) issue. After SQL Server is installed on a computer, you cannot change the computer
    from a domain controller to a domain member. You must uninstall SQL Server before you change the computer to a domain member.

    More information :
    Using SQL Server in Windows Small Business Server 2008 Premium Edition

    Microsoft SQL Server 2008 Standard Edition for Small Business

    Hope this helps.

    Best regards,
    Robbin Meng(MSFT)
    Microsoft Online Newsgroup Support
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Robbin Meng [MSFT], Jun 11, 2010
  4. john doe

    john doe Guest

    Thanks for the reply. That helps.
    john doe, Jun 11, 2010
  5. john doe

    john doe Guest

    Thanks for the reply. That helps.

    john doe, Jun 11, 2010
  6. You are welcome John.

    Please feel free to post back if you have any questions or if you need further assistance. Thanks!

    Best regards,
    Robbin Meng(MSFT)
    Microsoft Online Newsgroup Support
    Robbin Meng [MSFT], Jun 14, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.