Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same pass
word) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and the
y
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domai
n.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same pa
ssword) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>
Showing posts with label domains. Show all posts
Showing posts with label domains. Show all posts
Sunday, February 19, 2012
Connection between two domains
Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same password) in both domains.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and
> > they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>> Hi,
>> You can try doing a Run As ...
>> Shift + Right Click on EM shortcut and select Run As ...
>> Enter your other domain user credentials in the form:
>> domain\username
>> password
>> I'm not 100% sure that this will work though. Is your computer a member
>> of
>> both domains?
>> It will somehow have to authenticate your credentials with the other
>> domain.
>> --
>> HTH
>> Dan Artuso
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>> > Hi All,
>> >
>> > We have two different domains in our environment, say ABC and XYZ, and
>> > they
>> > are not trusted. I login into my PC using ABC domain .
>> >
>> > I have windows authenticated login in SQLServer that is in XYZ domain.
>> >
>> > Can anyone tell me how I can connect to SQL server that is in different
>> > domain using Enterprise Manager or query analyzer?
>> >
>> > Thanks,
>> > Vinod
>> >
>>
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same password) in both domains.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and
> > they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>> Hi,
>> You can try doing a Run As ...
>> Shift + Right Click on EM shortcut and select Run As ...
>> Enter your other domain user credentials in the form:
>> domain\username
>> password
>> I'm not 100% sure that this will work though. Is your computer a member
>> of
>> both domains?
>> It will somehow have to authenticate your credentials with the other
>> domain.
>> --
>> HTH
>> Dan Artuso
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>> > Hi All,
>> >
>> > We have two different domains in our environment, say ABC and XYZ, and
>> > they
>> > are not trusted. I login into my PC using ABC domain .
>> >
>> > I have windows authenticated login in SQLServer that is in XYZ domain.
>> >
>> > Can anyone tell me how I can connect to SQL server that is in different
>> > domain using Enterprise Manager or query analyzer?
>> >
>> > Thanks,
>> > Vinod
>> >
>>
Connection between two domains
Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
Vinod
Hi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||I believe that your only option is to create the same account (and same password) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>
|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
Vinod
Hi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||I believe that your only option is to create the same account (and same password) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>
|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
Subscribe to:
Posts (Atom)