SBS 2008 std and Sql Server 2008 std question
|
From: john doe on 9 Jun 2010 10:42 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.
From: Cliff Galiher - MVP on 9 Jun 2010 13:17 "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-Server-2008-Administrators-Consultant/dp/0735627118/ref=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" <johndoe(a)johndoe.com> wrote in message news:eacFsH#BLHA.1888(a)TK2MSFTNGP05.phx.gbl... > 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. >
From: "Robbin Meng [MSFT]" on 11 Jun 2010 04:19 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. ==================================================================
From: john doe on 11 Jun 2010 09:11 Thanks for the reply. That helps. ""Robbin Meng [MSFT]"" <v-robmen(a)online.microsoft.com> wrote in message news:KHVbe7TCLHA.2364(a)TK2MSFTNGHUB02.phx.gbl... > > 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. > ================================================================== > > >
From: john doe on 11 Jun 2010 09:11 Thanks for the reply. That helps. "Cliff Galiher - MVP" <cgaliher(a)gmail.com> wrote in message news:C69540FE-71C5-4C16-82A8-514A77C4440F(a)microsoft.com... > "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-Server-2008-Administrators-Consultant/dp/0735627118/ref=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" <johndoe(a)johndoe.com> wrote in message > news:eacFsH#BLHA.1888(a)TK2MSFTNGP05.phx.gbl... >> 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. >>
|
Next
|
Last
Pages: 1 2 Prev: Fierwall / AV /Spam Sugestions Next: Outlook 2003 and Exchange 2003 (SBS) |