Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Windows Small Business Server > SBS 2008 std and Sql Server 2008 std question

Reply
Thread Tools Display Modes

SBS 2008 std and Sql Server 2008 std question

 
 
john doe
Guest
Posts: n/a

 
      06-09-2010
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.


 
Reply With Quote
 
 
 
 
Cliff Galiher - MVP
Guest
Posts: n/a

 
      06-09-2010
"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...6103841&sr=8-3


--
Cliff Galiher
Microsoft has opened the Small Business Server forum on Technet! Check it
out!
http://social.technet.microsoft.com/...server/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.
>

 
Reply With Quote
 
 
 
 
Robbin Meng [MSFT]
Guest
Posts: n/a

 
      06-11-2010

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/l...97(WS.10).aspx

Microsoft SQL Server 2008 Standard Edition for Small Business
http://www.microsoft.com/sqlserver/2...-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.
================================================== ================



 
Reply With Quote
 
john doe
Guest
Posts: n/a

 
      06-11-2010

Thanks for the reply. That helps.
""Robbin Meng [MSFT]"" <v-> 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/l...97(WS.10).aspx
>
> Microsoft SQL Server 2008 Standard Edition for Small Business
> http://www.microsoft.com/sqlserver/2...-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.
> ================================================== ================
>
>
>



 
Reply With Quote
 
john doe
Guest
Posts: n/a

 
      06-11-2010
Thanks for the reply. That helps.

"Cliff Galiher - MVP" <> wrote in message
news:C69540FE-71C5-4C16-82A8-...
> "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...6103841&sr=8-3
>
>
> --
> Cliff Galiher
> Microsoft has opened the Small Business Server forum on Technet! Check it
> out!
> http://social.technet.microsoft.com/...server/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.
>>



 
Reply With Quote
 
Robbin Meng [MSFT]
Guest
Posts: n/a

 
      06-14-2010

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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Migrating Windows server 2003 Std. to Windows server 2008 SBS Std. ATS Windows Small Business Server 1 06-10-2009 08:58 PM
Re: A new member server - Windows Server 2008 + SQL Server 2008 OR Windows Server 2003 + SQL Server 2005 kj [SBS MVP] Windows Small Business Server 0 02-24-2009 04:21 PM
Re: A new member server - Windows Server 2008 + SQL Server 2008 OR Windows Server 2003 + SQL Server 2005 Larry Struckmeyer [SBS-MVP] Windows Small Business Server 0 02-24-2009 12:36 PM
Can I load SQL 2008 Std on SBS 2003 R2 Std server? Gary Drost Windows Small Business Server 2 12-15-2008 07:44 PM
SQL Server Std over SBS 2003 std Charles Windows Small Business Server 10 05-31-2007 01:06 AM