Active Directory and SQL Server 2000

[Guest_imported]

Does anyone know how to logon to SQL Server 2000 across a Win2k Active Directory?

I must be doing something wrong. My development server is running Win2K Server with Active Directory. I created the domain and then Installed SQL Server 2000. I have connected my other computer to the domain through the System Properties in the control panel.

However, I cannot access my instance of SQL Server. My 2000 User account has Administrator and Domain Admin priveledges and my SQL Server login has dbo priveledges on the master database. I have tried loging in using Windows Authentication and SQL Server authentication using both my own login and the 'sa' login.

Can anyone help me? I appreciate it very much.

Thank you.
-Steve
(sparks@houston.rr.com)

 

[aalmeida]

Here my 3 cents on this issue:
First the SQL server shoulb be set to run using a domain account;
Second it should be set to use NT authentication;
Third SQL Account should be your 2k Domain Account.
For more info try the BOL article "Connecting to SQL Server", "Setting up Windows Services Accounts"
I hope it helps you or at least leads you to the right direction
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[jhall156]

I find it pretty easy to just use terminal services to connect and work on my SQL Server. Are there advantages to be gained from active directory services?