Can not Log in with windows user after installing active directory



After installing active directory I failed to connect SQL server 2000 with
eather with Active directory user accont and sa.
It's showing a messege unable to connect sql server Mainserver\SQL2000DB
server msg 17, level16 state 1
server does not exist or access denied.
Please help
.



Relevant Pages

  • Re: T-Sql & Active Directory Roles, Identification of original login of impersonated IDs an
    ... We want to be able to control access to data within a table based on a ... role within Active directory. ... All the sites are held in a single database table. ... can grant permissions in SQL Server to Windows groups. ...
    (comp.databases.ms-sqlserver)
  • Re: sql2005/linked server+imperonate
    ... When you go from the first SQL Server to the second SQL ... Active Directory attempts to use Kerberos as the authentication method first. ... so through delegation, but you have to do some setup. ...
    (microsoft.public.de.sqlserver)
  • Re: Querying Windows Active Directory from Sql Server 2000
    ... is added to the active directory and i've rights in active directory to ... account in SQL Server to run the query. ... have permission to read the ActiveDirectory tree. ... OLE DB provider 'ADSDSOObject' reported an error. ...
    (comp.databases.ms-sqlserver)
  • Re: SMS Component errors after installing SP2
    ... MVP Windows Server System - SMS ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ... is used to publish fully qualified host names in Active Directory. ...
    (microsoft.public.sms.setup)
  • Re: Email unkown when trying to add user in AD mode
    ... The problem is that I can't add them as a user in Active Directory mode. ... Wayne Snyder, MCDBA, SQL Server MVP ... > SharePoint Services). ... >> community of SQL Server professionals. ...
    (microsoft.public.sharepoint.windowsservices)