SBS 2008 std and Sql Server 2008 std question

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.

 

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

 

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

 

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

 

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

 

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