sql server and active directory

From: Mike Read (mike.read.spam.no_at_allwaresolutions.com)
Date: 07/19/05


Date: Tue, 19 Jul 2005 13:40:03 -0400

I have a client who is migrating their network from an nt domain to active
directory domain. I have a number of application running at this
organization that utilize sql server 2000. All logins to the sql server
databases are done using nt groups. This allowed my clients to maintain who
had rights to the various databases through the domain.

Just to point out, i have very little knowledge of active directory.

The network people created a new organizational group for each application
and then created a group under this orgization unit. Then they put the user
into these groups.

Well when i go to Enterprise manager and go to security and Logins and
select new login. I get the login properties window. I change the domain
to the new active directory domain. Here I can see individual accounts and
built in groups but I can not see the groups that were created by the
network people.

Note: They plan to migrate their domain a few users at a time, so the sql
server machine is still on the old domain. The sql server service runs under
a network account from the old domain.

Any idea's?

Thank you,
Mike



Relevant Pages

  • ODBC Connection with SQL Managed Provider
    ... on a "network drive". ... database using the Microsoft .NET Framework 1.1 Data Provider for SQL ... authorizing the user against a table in the SQL server database. ... for the app to display the "splash" screen (which is the first thing it does ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
    ... even gone as far as swapping network cables and updating NIC card drivers to ... If the box itself checked out fine, then move on to runnign SQL Server on ... Perfmon, Disk I/O, Pages, Profiler traces, checked locks/blocks, long running ... slow on these boxes to me. ...
    (microsoft.public.sqlserver.setup)
  • Odd connection problem (proxy + internal)
    ... system and can not be placed facing the internet. ... that belongs to our network and also connects to this accounting ... DSN's) to our internal SQL server. ... by installing the Winsock proxy on the SQL server and mapping the ip ...
    (comp.databases.ms-sqlserver)
  • Re: changing db location on sql2000
    ... Tibor Karaszi, SQL Server MVP ... Therefore I wish MS had let us decide if it was ok to use a usb or network share or whatever to store the data. ... Since your USB drive was showed as a network share, SQL Server could not use it for storing database files. ... If your database is very large, you may consider using SAN, NAS etc which are fast and scalable network storage solutions. ...
    (microsoft.public.sqlserver.setup)
  • Re: What is the best way to administering two separate forests?
    ... Now that you mentioned a trust relationship, it actually makes sense to do ... development and SQL Server management for them. ... network and network resources i.e. Exchange, SQL Server, applications, etc. ... We will just have a separate logical network with a separate ...
    (microsoft.public.win2000.networking)