[SOLVED] SQL problem

Dzha2000 · 04-17-2008, 06:54 AM

Hi Guys.

I have a problem with SQL. I have two servers running 2 separate domains (let's call them old server and new server). I'm trying to migrate users from old to new server. I have a user who need access to SQL on old server (which will not be migrated to new server), but him being on new server. How can I do that without establishing two way trust between domains? was thinking through about SQL server authentication, but that didn't work either.

if anyone can give me some pointer I would really appreciate it.

XtabbedoutX · 04-17-2008, 12:12 PM

As far as I can remember you will have to create the trust between the NEW and OLD servers since they are running two DIFFERENT Domains.

Dzha2000 · 04-17-2008, 12:30 PM

Quote:

Originally Posted by XtabbedoutX

As far as I can remember you will have to create the trust between the NEW and OLD servers since they are running two DIFFERENT Domains.

yes that's what I though, but I was wondering if there is another way without trust between the domains. I'm trying to keep them separate.
other thing is I had to setup two way trust in order for that to work, one way trust where old domain authenticates new domain user didn't work for SQL

XtabbedoutX · 04-17-2008, 12:44 PM

I don't think so since it will need mutual trust authentication between the two domains.

Dzha2000 · 04-17-2008, 12:55 PM

Quote:

Originally Posted by XtabbedoutX

I don't think so since it will need mutual trust authentication between the two domains.

ok. that's what I was afraid of. thanks for you help.

XtabbedoutX · 04-17-2008, 12:56 PM

Not a problem that is what we are here for.

04-17-2008, 06:54 AM	#1 (permalink)
Dzha2000 Registered User Join Date: Apr 2008 Posts: 3 OS: XP SP2	[SOLVED] SQL problem Hi Guys. I have a problem with SQL. I have two servers running 2 separate domains (let's call them old server and new server). I'm trying to migrate users from old to new server. I have a user who need access to SQL on old server (which will not be migrated to new server), but him being on new server. How can I do that without establishing two way trust between domains? was thinking through about SQL server authentication, but that didn't work either. if anyone can give me some pointer I would really appreciate it.

04-17-2008, 12:12 PM	#2 (permalink)
XtabbedoutX Tech, Microsoft Support Join Date: Sep 2007 Location: Oklahoma City Posts: 861 OS: Server 2K3 R2, Server 2K, XP PRO, Mac OS X 10.4, Mac OS X 10.5, Ubuntu Linux 7.10, iPhone My System	Re: SQL problem As far as I can remember you will have to create the trust between the NEW and OLD servers since they are running two DIFFERENT Domains. __________________ HJT - 5 steps against malware. Post your HijackThis log there and not here ! Posting system specs

04-17-2008, 12:44 PM	#4 (permalink)
XtabbedoutX Tech, Microsoft Support Join Date: Sep 2007 Location: Oklahoma City Posts: 861 OS: Server 2K3 R2, Server 2K, XP PRO, Mac OS X 10.4, Mac OS X 10.5, Ubuntu Linux 7.10, iPhone My System	Re: SQL problem I don't think so since it will need mutual trust authentication between the two domains. __________________ HJT - 5 steps against malware. Post your HijackThis log there and not here ! Posting system specs

04-17-2008, 12:56 PM	#6 (permalink)
XtabbedoutX Tech, Microsoft Support Join Date: Sep 2007 Location: Oklahoma City Posts: 861 OS: Server 2K3 R2, Server 2K, XP PRO, Mac OS X 10.4, Mac OS X 10.5, Ubuntu Linux 7.10, iPhone My System	Re: SQL problem Not a problem that is what we are here for. __________________ HJT - 5 steps against malware. Post your HijackThis log there and not here ! Posting system specs