Re: Adding additional server in a windows small business network

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Floyd wrote:
How can I than assign appropriate priviledges on the Windows 2003
Server for the domain account created on the SBS 2003?

File system privileges? When you go to select users (or better, groups), you
select "from this location" and choose the domain. The UI is a little
different is some rights/permissions assignments, but generally this is how
it's done.


"kj [SBS MVP]" wrote:

Floyd wrote:
I have a SBS 2003 network where I'm planning to add additional
Windows 2003 server that will host MS SQL 2000 database.

I have created a server account on the SBS and joined the Windows
Server 2003 to the SBS 2003 domain.

I'm planning to create a specific domain account for SQL AGENT and
SQL Server (Service Account) for the MS SQL 2000 installation and
servicing purposes.

After I create a domain account on the SBS AD, how I can add that
user to the Windows Server 2003 server that hosts database?

You don't "add" it, the domain accounts are available to domain
members in the form of domainname\domainaccount.

Do I have
to enable AD on teh Windows Server 2003 and if yes, would it have
any impact on the existing AD on the SBS 2003?

No, just being a (domain) member server allows access. (Generally
it's a drop down when choosing accounts)


Thanks.

--
/kj

--
/kj


.

Relevant Pages

  • RE: 0x80004005 - you need permission to view its data
    ... Based on the information in the "Security Account Delegation" topic in SQL ... When connecting to multiple servers, and with each server change, we need ... Establish a SPN for your domain account which will enable Kerberos ...
    (microsoft.public.sqlserver.security)
  • Re: ISP scenario for AD and DNS
    ... WSS needs a domain account to connect with a non-local SQL ... non-local SQL Server, so it has to be a member of a domain. ... Exchange does require Active Directory, but if your thinking of Exchange ...
    (microsoft.public.windows.server.dns)
  • Re: Security
    ... by running a job and my domain account which is also ... SA on both SQL servers by using exec xp_cmdshell 'dtsrun'. ... in the dts package connection is a SQL Login that is SA on the server it is ... >> connection to the other server uses to sysadmin. ...
    (microsoft.public.sqlserver.server)
  • Re: Jobs Failed do not work when scheduled done via DTS Scheduled Package
    ... EM/QA directly on the server? ... > Anything that was done via DTS' FAILS. ... > the account that is logged on is a domain account and we even made it ... the sql is set to use either sql or windows authentication. ...
    (microsoft.public.sqlserver.server)
  • Re: Error 22042
    ... Itīs member of Domain Admins group, ... configured it as the account for SQL Service and SQL ... Server Agent in another server in the same domain with no ... >> Everytime I try to configure a domain account for SQL ...
    (microsoft.public.sqlserver.security)