Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dzha2000
Starting Member
8 Posts |
 Posted - 2008-04-17 : 08:53:27
|
| 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
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-17 : 22:21:51
|
| Why sql authentication doesn't work? Got any error? |
 |
|
|
Dzha2000
Starting Member
8 Posts |
Posted - 2008-04-18 : 08:18:09
|
| 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? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-04-19 : 05:48:44
|
| Could you confirm that the 1 server can see the other server , and and the ports are availableJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 17:01:01
|
| >> 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? |
|
|
|
Dzha2000
Starting Member
8 Posts |
Posted - 2008-04-21 : 08:19:37
|
| Yes they have full connectivity between them, but SQL still doesn't let me connect to database saying connection problem. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-21 : 14:28:44
|
| Can you post the errors you are receiving (look in the error log)?Terry |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-21 : 14:44:35
|
| 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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
SQL server problem