Need some workaround( security question)

We have SQL 2005.
Say our SQL servers are in Domain 'ABC' and our clients are in Domain 'XYZ'
where the domains dont trust one another.
Theres more details but in short,I want to add Windows accounts i.e.
(XYZ\User1,XYZ\User2,etc.) without being authenticated against the domain
controller 'ABC'. When I try to add these Windows logins, it fails since it
wants to authenticate against XYZ but theres no trust.
So how can I bypass the authentication and get those entries added to my SQL
Account? Any way to hack the system tables? If not, thats fine. If theres
anyway to get these entries in the equivalent logins/users tables in the
databases is what I want to accomplish.
ThanksIf I understand what you are asking for, you want to allow connections
to users who say they are in the XYZ domain without any authentication
at all.
As someone who has to rely on SQL Server security I hope there is no
way to do this.
The obvious alternative for users in a non-trusted domain is to use
SQL Server logins, which are domain independent. That requires
individual logins be created, and they have to connect excplicitly by
name with a password
Roy Harvey
Beacon Falls, CT
On Thu, 28 Jun 2007 21:35:33 -0700, "Hassan" <hassan@.hotmail.com>
wrote:

>We have SQL 2005.
>Say our SQL servers are in Domain 'ABC' and our clients are in Domain 'XYZ'
>where the domains dont trust one another.
>Theres more details but in short,I want to add Windows accounts i.e.
>(XYZ\User1,XYZ\User2,etc.) without being authenticated against the domain
>controller 'ABC'. When I try to add these Windows logins, it fails since it
>wants to authenticate against XYZ but theres no trust.
>So how can I bypass the authentication and get those entries added to my SQ
L
>Account? Any way to hack the system tables? If not, thats fine. If theres
>anyway to get these entries in the equivalent logins/users tables in the
>databases is what I want to accomplish.
>Thanks

Need some workaround( security question)

We have SQL 2005.
Say our SQL servers are in Domain 'ABC' and our clients are in Domain 'XYZ'
where the domains dont trust one another.
Theres more details but in short,I want to add Windows accounts i.e.
(XYZ\User1,XYZ\User2,etc.) without being authenticated against the domain
controller 'ABC'. When I try to add these Windows logins, it fails since it
wants to authenticate against XYZ but theres no trust.
So how can I bypass the authentication and get those entries added to my SQL
Account? Any way to hack the system tables? If not, thats fine. If theres
anyway to get these entries in the equivalent logins/users tables in the
databases is what I want to accomplish.
ThanksIf I understand what you are asking for, you want to allow connections
to users who say they are in the XYZ domain without any authentication
at all.
As someone who has to rely on SQL Server security I hope there is no
way to do this.
The obvious alternative for users in a non-trusted domain is to use
SQL Server logins, which are domain independent. That requires
individual logins be created, and they have to connect excplicitly by
name with a password
Roy Harvey
Beacon Falls, CT
On Thu, 28 Jun 2007 21:35:33 -0700, "Hassan" <hassan@.hotmail.com>
wrote:
>We have SQL 2005.
>Say our SQL servers are in Domain 'ABC' and our clients are in Domain 'XYZ'
>where the domains dont trust one another.
>Theres more details but in short,I want to add Windows accounts i.e.
>(XYZ\User1,XYZ\User2,etc.) without being authenticated against the domain
>controller 'ABC'. When I try to add these Windows logins, it fails since it
>wants to authenticate against XYZ but theres no trust.
>So how can I bypass the authentication and get those entries added to my SQL
>Account? Any way to hack the system tables? If not, thats fine. If theres
>anyway to get these entries in the equivalent logins/users tables in the
>databases is what I want to accomplish.
>Thankssql

need some TSQL help

I have some entries in a column as such
XYZ ( ABC ) ( 1)
XYZ ( ABC ) ( 11)
XYZ ( ABC ) ( 2)
XYZ ( ABC ) ( 3)
XYZ ( ABC ) ( 4)
UVW ( XYZ ) ( 10)
UVW ( XYZ ) ( 12)
UVW ( XYZ ) ( 41)
So i want to group entries like this by the first ')' seen
so I can get distinct values such as
XYZ ( ABC )
UVW ( XYZ )
How can i write the query ? Thankscreate table t (
s varchar(40)
)
go
insert into t values ('XYZ ( ABC ) ( 1)')
insert into t values ('XYZ ( ABC ) ( 11)')
insert into t values ('XYZ ( ABC ) ( 2)')
insert into t values ('XYZ ( ABC ) ( 3)')
insert into t values ('XYZ ( ABC ) ( 4)')
insert into t values ('UVW ( XYZ ) ( 10)')
insert into t values ('UVW ( XYZ ) ( 12)')
insert into t values ('UVW ( XYZ ) ( 41)')
go
select distinct
substring(s,1,charindex(')',s)) as s
from t
where charindex(')',s) > 0
go
drop table t
Steve Kass
Drew University
Hassan wrote:

>I have some entries in a column as such
>XYZ ( ABC ) ( 1)
>XYZ ( ABC ) ( 11)
>XYZ ( ABC ) ( 2)
>XYZ ( ABC ) ( 3)
>XYZ ( ABC ) ( 4)
>UVW ( XYZ ) ( 10)
>UVW ( XYZ ) ( 12)
>UVW ( XYZ ) ( 41)
>So i want to group entries like this by the first ')' seen
>so I can get distinct values such as
>XYZ ( ABC )
>UVW ( XYZ )
>How can i write the query ? Thanks
>
>|||or
select substring(s,1,charindex(')',s)) as s
from #t
where charindex(')',s) > 0
group by substring(s,1,charindex(')',s))
Madhivanan