SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL server problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Dzha2000
Starting Member

8 Posts

Posted - 04/17/2008 :  08:53:27  Show Profile  Reply with Quote
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 abour SQL server authentication, but that didn't work either.

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

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/17/2008 :  22:21:51  Show Profile  Reply with Quote
Why sql authentication doesn't work? Got any error?
Go to Top of Page

Dzha2000
Starting Member

8 Posts

Posted - 04/18/2008 :  08:18:09  Show Profile  Reply with Quote
nothing special, just saying couldn't connect.
I guess, but I might be wrong, you don't have to be on the domain for SQL authentication. correct me if I'm wrong.

on another forum I have been told that the only way for me to get connected to SQL server is to establish two way trust between the domains, is that true?
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 04/19/2008 :  05:48:44  Show Profile  Visit jackv's Homepage  Reply with Quote
Could you confirm that the 1 server can see the other server , and and the ports are available

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/19/2008 :  17:01:01  Show Profile  Reply with Quote
>> the only way for me to get connected to SQL server is to establish two way trust between the domains, is that true?

Not true for sql authentication. Can those servers ping each other? Can they telnet each other with sql port? Can you post error?
Go to Top of Page

Dzha2000
Starting Member

8 Posts

Posted - 04/21/2008 :  08:19:37  Show Profile  Reply with Quote
Yes they have full connectivity between them, but SQL still doesn't let me connect to database saying connection problem.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 04/21/2008 :  14:28:44  Show Profile  Reply with Quote
Can you post the errors you are receiving (look in the error log)?

Terry
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 04/21/2008 :  14:44:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
You haven't mentioned where they are getting the error. From your application, from Management Studio, ...? And we need the exact error, not your abbreviation of it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000