Re: SQL 2000 DOMAIN CONTROLLER

Hello Mr Durand,

In Enterprise Manager when you go to the logins folder. You can create a login for the computer account. In the name just put domain\computer name and then give the account sysadmin rights and then it should work. Also make sure that the BUILTIN\Administrators group is in SQL server.
and what if the SQL server is a domain controller?

"tziegmann" <tziegmann@xxxxxxx> wrote in message
news:428ac052238e8c80cf2fe261f9a@xxxxxxxxxxxxxxxxxxxxx

Hello,

The SMS Server account needs to be a member of the Administrators
group on the SQL Server. If it still not working that way you can add
the machines account into SQL Server as a login and give the account
dbo and sysadmin rights to the SQL Server.

Actually this is the error message I've been getting

The Windows server SQLSERVERNAME\SQLINSTANCE that is running the SQL
Server is down or not on the network, or your current Windows logon
ID does not allow you to access the Windows server.

Either the SQL Server is in a Windows NT 4 domain or this computer's
machine account does not have Administrator's privileges on the SQL
Server. To install a site in advanced security, all servers must be
in Active Directory and the site server's machine account must have
Administrator's privileges on the SQL Server.

I'm fine with everything in that message except the "the site
server's machine account must have Administrator's privileges on the
SQL Server".

Does this mean the machine account needs to be in the local
administrators group of the server or have admin privileges on the
database itself? First off the SQL server is on a domain controller
(small company, fast CPU's with lots of RAM) and secondly I thought
I was somewhat SQL savvy however how in the world do you give a
computer account access to a database?

The machine account for the SMS server itself (a member server) is
in the 'Administrators' group as shown on the domain.

Maybe I didn't have enough caffeine yet today.

Mr Durand

"Mr Durand" <eldocomp@xxxxxxxxx> wrote in message
news:%23rjcJBuPGHA.5020@xxxxxxxxxxxxxxxxxxxxxxx
Can the SQL 2000 server be an AD domain controller? If so, how do
you get the SMS machine (a member server) into the local admins
group?

Mr Durand



.

Relevant Pages

  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
Loading