| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-09-27 : 16:46:43
|
| I have two servers running independently on 2008, and want to transfer one database to the other. On the same LAN network. Why can't they see each other? One is on the HOMEUSER domain and the other is PRO ... I have no idea. I don't think I'll ever understand Microsoft domains. Ridiculous. I have a Pro\Pro instance about 3 times faster on my Mac Pro hardware, both with xp SP3.Cannot communicate. Why not? What do I need to do with VIA, TCP/IP, named pipes and shared memory??? WHAT DOES THAT MEAN? Ridiculous!iTunes has no problem. Done. Shared. What's the problem?I thought SSMS could connect to a live server? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-27 : 16:50:04
|
| Are you using SQL logins or Windows authentication? SQL auth plus IP address should work every time unless there's a firewall block on port 1433 somewhere. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-09-28 : 06:13:37
|
| Thanks Rob. I was assuming that any 'service' should be visible by another app, such as SSMS, or... iTunes, TwonkyMedia..?. Maybe SQL Auth will fix it.Tara, the error is that if I put either server name in SSMS, it cannot be found. Not an error. Just a window timing out with no server listed. Shared memory and named pipes.. what is that? Is it local? My approach is to enable TCP/IP and disable the other three.What about the Windows domain? Is that set by switches, or W2K3 Server, which I don't have. How do you get machines on the same domain? Is it necessary?Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-28 : 07:30:23
|
| Log in to each SQL Server and add your Windows account as a login, using the "DOMAINNAME\USERNAME" format. There's a button/wizard option where you can choose which machine or domain to select the login from.If 2 different Windows domains are trusted and the Windows credentials have permission, then Windows auth should work between domains. I haven't done this myself so there could be other issues, Books Online or Google will help. I can say that if domains are NOT trusted, Windows auth is a pain in the ass. You'd have to log in to the domain first, then connect to SQL from that machine. A SQL login is better in this case.Don't disable shared memory or named pipes, it won't help and could cause problems with other components. Check with your network IT group and see if they have a firewall or IPSec restriction on those machines, especially for port 1433. This is pretty normal, as they usually block all ports except standards like 80, 8080 and 25. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-09-28 : 11:05:53
|
| Outside of SQL Server, how do you set the domainname? Do you set that for a PC? Or is it done by Windows Server? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-28 : 11:14:09
|
| The domain is set up by whoever your network architects are. You then add a computer to the domain under My Computer:Properties, which requires domain admin (or similar) privileges. Setting up trusted domains is another operation that requires network architect or domain admin privileges. A computer can only belong to 1 domain at a time.I'm guessing that SQL authentication is not an option for you? It's going to be a lot easier to set that up than to wrangle domain trust. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-09-28 : 12:54:24
|
| This is at home, on a router. I want to transfer databases between machines. Both machines have WORKGROUP set. In the window, there is a radio button for WORKGROUP or on above for Domain: How are these different? Can't I set up the domain for my machine? I have xp SP3 and everything is set up, trying to get everything the same. When browsing the WORKGROUP, each machine can only see itself - not the other. What do I need to set for DNS, .....? Firewalls are disabled on both machine.I have been trying SQL Auth |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-09-28 : 13:06:27
|
| DNS suffixes are localdomain and private for the different machines. They have IP addresses. Cannot ping each other |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-28 : 13:24:06
|
| It's probably a network sharing setting somewhere in the XP Control Panel (sorry, I've never used it, Google will have to be your guide). If they cannot ping each other through your home router (assuming 192.168 IP addresses) then there's a configuration problem. In either case Windows Authentication is probably not going to work. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
What a mess