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
    2008)
    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
    1. Advertising

  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
    account.

    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,
    etc.)

    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...

    http://www.amazon.com/Windows-Serve...=sr_1_3?ie=UTF8&s=books&qid=1276103841&sr=8-3


    --
    Cliff Galiher
    Microsoft has opened the Small Business Server forum on Technet! Check it
    out!
    http://social.technet.microsoft.com/Forums/en-us/smallbusinessserver/threads
    Addicted to newsgroups? Read about the NNTP Bridge for MS Forums.

    "john doe" <> wrote in message
    news:eacFsH#...
    > 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 2008)
    > 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.
    >
     
    Cliff Galiher - MVP, Jun 9, 2010
    #2
    1. Advertising

  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
    network.


    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
    http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx

    Microsoft SQL Server 2008 Standard Edition for Small Business
    http://www.microsoft.com/sqlserver/2008/en/us/small-business.aspx

    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
    #3
  4. john doe

    john doe Guest

    Thanks for the reply. That helps.
    ""Robbin Meng [MSFT]"" <> wrote in message
    news:...
    >
    > 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
    > network.
    >
    >
    > 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
    > http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx
    >
    > Microsoft SQL Server 2008 Standard Edition for Small Business
    > http://www.microsoft.com/sqlserver/2008/en/us/small-business.aspx
    >
    > 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.
    > ==================================================================
    >
    >
    >
     
    john doe, Jun 11, 2010
    #4
  5. john doe

    john doe Guest

    Thanks for the reply. That helps.

    "Cliff Galiher - MVP" <> wrote in message
    news:...
    > "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 account.
    >
    > 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, etc.)
    >
    > 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...
    >
    > http://www.amazon.com/Windows-Serve...=sr_1_3?ie=UTF8&s=books&qid=1276103841&sr=8-3
    >
    >
    > --
    > Cliff Galiher
    > Microsoft has opened the Small Business Server forum on Technet! Check it
    > out!
    > http://social.technet.microsoft.com/Forums/en-us/smallbusinessserver/threads
    > Addicted to newsgroups? Read about the NNTP Bridge for MS Forums.
    >
    > "john doe" <> wrote in message
    > news:eacFsH#...
    >> 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 2008)
    >> 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 11, 2010
    #5
  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
    #6
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Charles

    SQL Server Std over SBS 2003 std

    Charles, May 28, 2007, in forum: Windows Small Business Server
    Replies:
    10
    Views:
    412
    bass_player
    May 31, 2007
  2. Gary Drost

    Can I load SQL 2008 Std on SBS 2003 R2 Std server?

    Gary Drost, Dec 15, 2008, in forum: Windows Small Business Server
    Replies:
    2
    Views:
    358
    Gary Drost
    Dec 15, 2008
  3. Larry Struckmeyer [SBS-MVP]
    Replies:
    0
    Views:
    546
    Larry Struckmeyer [SBS-MVP]
    Feb 24, 2009
  4. kj [SBS MVP]
    Replies:
    0
    Views:
    706
    kj [SBS MVP]
    Feb 24, 2009
  5. ATS
    Replies:
    1
    Views:
    340
    Larry Struckmeyer [SBS MVP]
    Jun 10, 2009
Loading...

Share This Page