Re: External trust & resources sharing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Both domain and forest are in "Windows 2003 mode".
I think the problem is in SQL 2000 server. I have tried to share folder on
Windows 2003 server, where SQL 2000 resides - everything is OK. But it is
not possible to grant permissions to the domain local group on the database
throught SQL enterprise manager - local group is not visible. Of course, I
can manually add this group typing it`s full name - but in this case user
can not access the database...
I will try to ask this question on sql newsgroup :-)

Thanks for your help.

Rytis

>
>> But if I am trying to search for this domain local group from SQL server
>> (in domainA), I can not found it - only global groups are listed. What I
>> am doing wrong?
>
> Well, this sounds like you're not in native mode. You have to be in
> native
> mode to use domain local groups on member servers. Verify that you are
> indeed in native mode, and that this server is authenticating with the
> domain, and *carefully* look through the object picker. The domain local
> group (in this domain) should be there.
>
>


.



Relevant Pages

  • Re: domain local group inivisible at non-DC computers
    ... changed to Native mode. ... After that Domain Local Group will be displayed in either of the PC with in domain. ... different Domain Local Groups to control the file security. ... Now I want to transfer these share files from the DC to a non-DC server which is a member server of the same domain. ...
    (microsoft.public.windows.server.active_directory)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)