November 10, 2007 at 2:46 pm
SQL 2005 SP2 | 2 Instances same SQL version | Server1 on domain "domain.com" | Server2 not in domain | Login on both with local Windows Account | Servers are "mapped" to each other with respective IP addresses (192.xxx.xxx.xx)
Server1 and Server2 show green arrows in Registered Servers on both Servers in SQL Server Management Studio.
Server1 and Server2 show green arrows ONLY for Local instance in Object Explorer Connections on both Servers in SQL Server Management Studio. Non-local is empty green circle. Is this normal??? The login to each is using the Windows login.
After a Local Publication is created, when attempting to "Add SQL Server Subscriber", that is, the non-local database, no connection will be made. Only TCP/IP is enabled on both instances as Native Client Configuration protocols. Only port 1433 is opened and selected for IP Default Port.
Cannot create either a push or pull Subscription.
Error message: TCP provider no such host is known. Even though it is already connected to the non-local Instance.
Both Servers are brand new, identical boxes running Win03SP2.
There is nothing I can find in the literature which addresses this exact issue.
What have I missed???????
November 11, 2007 at 4:55 am
tried creating alias for each other in sql configuration manager?
November 11, 2007 at 9:09 am
Yes.
On Server1 I created Alias "Server1", on Server2 Alias "Server2".
Is it possible that the problem is due to Server 2 not being "in" the network of Server 1 and visa versa, because Server 1 is in its own Domain, but Server 2 is not in that Domain or any Domain? Does Server 1 Domain have to "trust" Server 2 which is not in its Domain? Do both Servers have to be a member of the same "workgroup"?
Each Server only "sees" the other via being mapped as a Drive letter to the other's IP address. Both of these servers are part of the same company, same business, just 2 locations.
There is no GREEN arrow on the non-Local Database Engine in the Object Explorer in SQL 2005 Studio Manager at either server, even though there are GREEN arrows for both Database Engines in the Registered Servers area at both servers.
The "connection" in the Object Explorer appears only by logging in using the IP address of the non-local Server using Windows Authentication where the User has full Admin rights on each respective server, but not with the name of the server - - Server1 or Server2 and the same User. No green arrow for the non-local Database engine appears, only an empty circle. The Alias name doesn't work either.
November 12, 2007 at 10:08 am
how does server2 connect? needs domain credential i believe
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply