Now I’ll see with our network admin to install a new domain with the default parameters and try to see the domain group on the SQL Server computer.

Anyway, many thanks...

To give you more information somebody give me this link:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q258/0/25.ASP&NoWebContent=1

But in my case, when I try to “Add GlobalGroup to SQLLocalGroup”, he can’t find the GlobalGroup on the...

Thanks for your help bkelley.

The exact error that I have when a member of the group try to connect is:

“Unable to Connect to server xxx

Server: Msg 18456, Level 16, State...

Sorry for your head 😉

Yes I’m able to connect to the server by “BUILTIN\Administrators” but I remove it for security reason.

I can also connect to a DB of the SQL...

(1)Yes, I’ve Terminal Services installed. And Yes, I can log in with my Domain Account (It’s also a Local Admin on the SQL Server Computer)

(2)Yes I can easily map to...

Yes the user is really connected at the windows login on the Domain.

Question about your point 2

“Log in as the administrator account for the SQL Server”. What do you...

SQL Server is on the same domain that the Domain NT Group. Just for information how do you trust the other Domain? Is it at the Domain Side or SQL...

Thanks for your help a5xo3z1.

Members of the Dommain Group haven't access to windows. The only access that they have is on SQL Server. And the only way where I try to connect is with...

Yes I used the Search. the problem is not their. In fact, the login appears in the list. And I associate some right to the Group. The problem comes from...

It's exactly what I've done.

If it's a NT Group Security on the SQL Server computer, it works.

If it's on the Domain, I don't find the NT Group Name in the...

I use mostly SQL Server 2000. But it will be better if it works on SQL Server 7

And yes, I put the right with Enterprise Manager. Could you help me...

And how do you retrieve the system error message for example? Do you catch the error description raised by the system? I’m really interested to do that.

The only way that...

Could you give more details about your need and with an example if it's possible.

Thanks

JMackels Developper/DBA

You can also use directly the system table if you want integer into a T-SQL statement

SELECT

SD.NAME,

SF.*

FROM

MASTER..SYSDATABASES SD, MASTER..SYSALTFILES SF

WHERE SF.DBID = SD.DBID

JMackels Developer / DBA